Search Results - VBForums

Search:

Type: Posts; User: CVMichael

Page 1 of 13 1 2 3 4

Search: Search took 0.10 seconds.

  1. Re: VB - Quick Sort algorithm (very fast sorting algorithm)

    OK... so the code I posted in this thread 11 years ago, is also sorting strings.... so what's the point of your post? you have to be more descriptive than that! Or is this the quality of posts we...
  2. Replies
    19
    Views
    380

    Re: Hey Everyone, Long Time No See.

    Hey Jacob :)

    I'm here for 12 years :eek:, and like you I'm way too busy, i visit the forum maybe once a month...

    Life has changed a lot for me also, the main change for me is that now I have a...
  3. Re: VB - Quick Sort algorithm (very fast sorting algorithm)

    Correct! it MIGHT overflow! ... let's see WHEN?

    So, a Long data type is 32 bits, but we are using a signed integer, so 31 bits, and that is 2,147,483,648... those are array items...
    Now lets see...
  4. Replies
    47
    Views
    7,527

    Re: Winsock & Multithreading with Activex EXE

    Assuming that your solution works, since 2005 finally someone posted a solution to this... it's been more than 9 years since I started the thread, and I am not using VB6 for many years!

    Anyways......
  5. Replies
    4
    Views
    106

    Re: database structure

    I guess you are using MS Access, so yes... Autonumber...
  6. Replies
    4
    Views
    106

    Re: database structure

    Don't have the family ID entered by the user, have the ID generated automatically. Then insert the family data first, get the ID, and then insert that ID in the member table...
  7. Replies
    26
    Views
    726

    Re: Amateur Radio License Tests

    You correctly answered 11 out of 35 questions for 31.4%.

    for the General test :)
  8. Re: Anyone into Multirotors? (also known as Drones) ?

    Here is a 21 century Flintstone: https://www.youtube.com/watch?v=syJq10EQkog :)
  9. Re: Anyone into Multirotors? (also known as Drones) ?

    Yea, I don't think drones will be very widespread... right now the problem is that this technology is still new, and there are many things that should be done to make them safe (if ever), but this is...
  10. Re: Anyone into Multirotors? (also known as Drones) ?

    Those guys were able to achive that precision because they setup cameras around to track where the quadcopter is, and it is computer controlled.
    My hexacopter has no such things of course, and the...
  11. Re: Anyone into Multirotors? (also known as Drones) ?

    The indoor flying things; yes, those are easy to get bored off... and the Chinook Helicopter is very small, so outside the wind will move it side to side, especially that it does not have any...
  12. Anyone into Multirotors? (also known as Drones) ?

    I did not post on the forum for a long time, because I've been busy with other things. But mostly I've been busy with my new found hobby: flying my Hexacopter :)

    From programming to electronics,...
  13. Replies
    10
    Views
    888

    Re: Optimizing Stored Procedure

    OK, so first step I do when I try to understand someone's SQL is to format (my way) it so I can understand it better:

    I removed unnecessary brackets, indented properly, and put "AND"s at the...
  14. Replies
    10
    Views
    888

    Re: Optimizing Stored Procedure

    What database is this? SQL Server?
  15. Replies
    9
    Views
    37,676

    Re: Современная о

    Thank you :)
    спасибо
  16. Replies
    10
    Views
    521

    Re: [RESOLVED] Dynamic IN Clause

    While we are at it :D Here is another way where it's converting the comma separated string to XML, and then converts to a table, and joins with the values:


    DECLARE @user_id int
    DECLARE...
  17. Replies
    10
    Views
    521

    Re: [RESOLVED] Dynamic IN Clause

    Another way is to run your query as a string query, but I know not many like this method:


    DECLARE @user_id int
    DECLARE @perm_ids varchar(max)

    SET @perm_ids =...
  18. Replies
    10
    Views
    521

    Re: [RESOLVED] Dynamic IN Clause

    Actually, because you need to search in a string, you have to use CHARINDEX, like this:



    DECLARE @user_id int
    DECLARE @perm_ids varchar(max)
    SET @perm_ids =...
  19. Re: Need Help In Designing a query for returning students who did not pay fees

    This returns the student who did not pay any type of fee (or none). If all fees are paid, it won't be returned

    SELECT s.*
    , CASE WHEN fp1.Feesid IS NULL THEN 'No' ELSE 'Yes' END AS [Fee 1 Paid]...
  20. Replies
    4
    Views
    784

    Re: Case When Null Issue

    What about ISNULL ?
    This is my test:

    ; WITH tblUploadPackage AS (
    SELECT TOP 0 * FROM (
    SELECT GetDate()-1 AS [Upload_Package_Received_Date]
    ) AS xx
    )
    SELECT
    [Moi_Type] = '',
  21. Replies
    18
    Views
    869

    Re: Can I divide tables for a faster search?

    That would probably be even slower...

    What about the hardware the SQL Server database is installed on? What's the hard-drive, CPU, RAM (how much RAM, and how many MHz) speed?
  22. Replies
    9
    Views
    1,525

    Re: Ideas for very basic Robotics

    I found this thread searching by my name :)

    Talking about robots...

    This is my first robot:
    Ultrasonic obstacle avoidance robot
    http://www.youtube.com/watch?v=L3Dpe1v6G-w

    The second one is...
  23. Replies
    9
    Views
    37,676

    Re: API Add-In for Visual Basic

    At the time I uploaded the file, the forum limit per file was 250 KBytes (I don't know what is the limit now). I had no choice but to split the file using the rar utility. You have to download both...
  24. Re: Update 2 tables in a procedure. Row count of one table unknown

    Actually, starting with SQL Server 2005
  25. Replies
    10
    Views
    1,626

    Re: Background Music (XM/Mod)`

    At that time, there was no button to "resolve" the thread. Back then people were asked to edit their original post, and type the "[Resolved]" in front of their title, and not many people did that,...
  26. Replies
    58
    Views
    34,590

    Re: VB - 31 Bit Encryption function

    I am flattered that you posted in my thread, but I fail to see what your code in .NET has anything to do with my 31 bit encryption?

    PS. Welcome to VB Forums!
  27. Replies
    13
    Views
    1,267

    Re: Find the missing numbers in SQL

    I just realized I missed the 0 (zero) as a cityid, so just modify the schema and add "select 0 union all" to the nums table
  28. Replies
    13
    Views
    1,267

    Re: Find the missing numbers in SQL

    This is what I have so far:
    http://sqlfiddle.com/#!2/de364/17

    I am not sure if that link saves, so here is the code just in case:
    Schema:


    create table runs(
    carid int,
    formCityID int,
  29. XSLT with 2 datasets on the same Worksheet

    I have my data in XML, and both datasets are there, for example:


    <root>
    <data1>
    <data_row>
    <col1>1</col1>
    <col2>aaaaaaaaaa</col2>
    </data_row>
    ...
  30. Replies
    36
    Views
    7,186

    Re: [RESOLVED] Encrypting Password VB6

    It's in the first page: VB6 - Example on how to make a Login where password is stored hashed in Database
  31. Re: [RESOLVED] Setting up IIS for Directory browsing

    Waw, that's sad to hear... I would expect MS to improve things!

    I guess this is when virtual PCs come in handy, because when something goes bad, it's easy to backup the virtual PC (when everything...
  32. Re: Setting up IIS for Directory browsing

    I have setup a dropbox, and I shared it with my friend... The IIS thing did not work for whatever reason, and I turned it off.
  33. [RESOLVED] Setting up IIS for Directory browsing

    I want to share some files with a friend, and I have set up my IIS for directory browsing.
    When I browse the folder using the web-browser, it shows the files, but when I click on the file to...
  34. Replies
    20
    Views
    975

    Re: winsock question

    Yea, that should work, if the sniffer app gives you all the header info, if its a freeware app, that would be OK... but I preffer to do the proxy especially if it's easy to make, rather than...
  35. Replies
    20
    Views
    975

    Re: winsock question

    By the way.... here is someone posting code with a proxy. If you choose to go "winsock only", then this should help you start:

    http://www.vbforums.com/showthread.php?712621
  36. Replies
    20
    Views
    975

    Re: winsock question

    And... I choose not to be quick :)
  37. Re: Creating a compound SQL statement???

    Try this:


    INSERT INTO [CalibrationTest].[dbo].[Categories]
    ([catgID]
    ,[category]
    ,[abbrev])
    SELECT A.catgID, A.category, A.abbrev FROM Categories A

    PS....
  38. Replies
    20
    Views
    975

    Re: winsock question

    Actually, you can do the "click" using winsock... but it's not easy...

    First you have to know what happens when you click in a browser... the browser has to process the code that is in the HTML,...
  39. Replies
    1
    Views
    804

    Choosing Source Control

    We are only 2 developers at my work, and we are not using any source control right now. Most of our projects are quite small, mostly ASP.NET, with VS2008 (but we plan to move to VS2010 soon), with a...
  40. Replies
    205
    Views
    10,983

    Re: The State of VBForums

    Is Merri still around?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.