Search Results - VBForums

Search:

Type: Posts; User: CVMichael

Page 1 of 13 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    12
    Views
    39,310

    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...
  2. Replies
    11
    Views
    305

    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...
  3. 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...
  4. 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...
  5. 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.%'
  6. 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
    -- -- --...
  7. 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...
  8. Replies
    19
    Views
    479

    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...
  9. 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...
  10. Replies
    47
    Views
    8,058

    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......
  11. Replies
    4
    Views
    126

    Re: database structure

    I guess you are using MS Access, so yes... Autonumber...
  12. Replies
    4
    Views
    126

    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...
  13. Replies
    26
    Views
    820

    Re: Amateur Radio License Tests

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

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

    Here is a 21 century Flintstone: https://www.youtube.com/watch?v=syJq10EQkog :)
  15. 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...
  16. 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...
  17. 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...
  18. 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,...
  19. Replies
    10
    Views
    949

    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...
  20. Replies
    10
    Views
    949

    Re: Optimizing Stored Procedure

    What database is this? SQL Server?
  21. Replies
    12
    Views
    39,310

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

    Thank you :)
    спасибо
  22. Replies
    10
    Views
    530

    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...
  23. Replies
    10
    Views
    530

    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 =...
  24. Replies
    10
    Views
    530

    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 =...
  25. 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]...
  26. Replies
    4
    Views
    801

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

    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?
  28. Replies
    9
    Views
    1,562

    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...
  29. Replies
    12
    Views
    39,310

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

    Actually, starting with SQL Server 2005
  31. Replies
    10
    Views
    1,638

    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,...
  32. Replies
    58
    Views
    34,995

    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!
  33. Replies
    13
    Views
    1,305

    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
  34. Replies
    13
    Views
    1,305

    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,
  35. 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>
    ...
  36. Replies
    36
    Views
    7,409

    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
  37. 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...
  38. 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.
  39. [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...
  40. Replies
    20
    Views
    985

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