Search Results - VBForums

Search:

Type: Posts; User: CVMichael

Page 1 of 13 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    13
    Views
    1,254

    Re: detect sound wave

    The code was written for DirectX 8 (for Windows XP), and Windows 7 has DirectX 9.

    You can't convert the code to new-er version because VB6 was the last version of "Classic Visual Basic", next...
  2. Replies
    13
    Views
    1,254

    Re: detect sound wave

    - still works - Probably... on a Windows XP computer and VB6... (if you still have it...)
    - worked initially - Of course! I don't post things that don't work
    - if you have a copy of the resulting...
  3. Re: Attempting to build and code a drone/Quadcopter

    I went to the hobby shop, and I bought a Ladybird V2 Devo 4 (cost me $73 including tax). Took a long time to charge the battery (about 30 mins?). When finally charged, I had to bind the quad, and...
  4. Re: Attempting to build and code a drone/Quadcopter

    Hi,

    Just a few weeks ago I started looking at getting the Hubsan X4, but they don't have it in stock at my local hobby shops, and I don't want to get some other brands that I don't know about. But...
  5. Re: Attempting to build and code a drone/Quadcopter

    OK, so if you are just starting to learn programming, then there is no chance that you will build a flight controller. There are many very advanced things you need to know to make a flight...
  6. Re: Attempting to build and code a drone/Quadcopter

    Hi Mister Meh,

    Building a quadcopter I would rate it as "average" in terms of difficulty, but coding the software for it, it is extremely difficult.

    First you need to get/build a quadcopter and...
  7. Replies
    12
    Views
    41,682

    Re: API Add-In for Visual Basic

    No.... I don't even have VB6 installed on my PC anymore (for a few years). The only programming I do latelly is at work in .NET.

    My interests changed, my new hobby is flying RC... things... see...
  8. Replies
    11
    Views
    362

    Re: SQL 2012 to SQL 2005

    Instead of a backup, you can generate an SQL script that will re-generate the database, users, tables, procs (etc.) and data into the SQL Server 2005.

    To do this, right click on the database in...
  9. Re: Anyone into Multirotors? (also known as Drones) ?

    Here is my new video with my Hexacopter:


    http://www.youtube.com/watch?v=mIYogu0J16g

    It is about 20 flights, and in total about 2.5 hours of video. I spend about 4 to 5 hours to edit and...
  10. Re: [RESOLVED] Walking a tree with HeirarchyID - SQLServer 2012

    Hmm... interesting, I am glad I solved your problem :)

    At work, we are still using SQL Server 2005, we will soon upgrade to 2012, and I can't wait to learn the new features.

    Normally, when I do...
  11. Re: Walking a tree with HeirarchyID - SQLServer 2012

    Is the format of HeirarchyPath really like this "1.3.1.2", because then you should be able to get the data by simply doing a search like
    SELECT * FROM your_table WHERE HeirarchyPath LIKE '1.3.%'
  12. Re: Walking a tree with HeirarchyID - SQLServer 2012

    So, basically what you are asking if you search for 1.3, then you want to get this result:
    -- -- Sub Location 1.3
    -- -- -- sub sub location 1.3.1
    -- -- -- -- And another location 1.3.1.1
    -- -- --...
  13. 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...
  14. Replies
    19
    Views
    619

    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...
  15. 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...
  16. Replies
    47
    Views
    8,577

    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......
  17. Replies
    4
    Views
    146

    Re: database structure

    I guess you are using MS Access, so yes... Autonumber...
  18. Replies
    4
    Views
    146

    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...
  19. Replies
    26
    Views
    983

    Re: Amateur Radio License Tests

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

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

    Here is a 21 century Flintstone: https://www.youtube.com/watch?v=syJq10EQkog :)
  21. 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...
  22. 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...
  23. 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...
  24. 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,...
  25. Replies
    10
    Views
    989

    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...
  26. Replies
    10
    Views
    989

    Re: Optimizing Stored Procedure

    What database is this? SQL Server?
  27. Replies
    12
    Views
    41,682

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

    Thank you :)
    спасибо
  28. Replies
    10
    Views
    598

    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...
  29. Replies
    10
    Views
    598

    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 =...
  30. Replies
    10
    Views
    598

    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 =...
  31. 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]...
  32. Replies
    4
    Views
    836

    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] = '',
  33. Replies
    18
    Views
    911

    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?
  34. Replies
    9
    Views
    1,612

    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...
  35. Replies
    12
    Views
    41,682

    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...
  36. Re: Update 2 tables in a procedure. Row count of one table unknown

    Actually, starting with SQL Server 2005
  37. Replies
    10
    Views
    1,652

    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,...
  38. Replies
    58
    Views
    35,666

    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!
  39. Replies
    13
    Views
    1,346

    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
  40. Replies
    13
    Views
    1,346

    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,
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.