Search Results - VBForums

Search:

Type: Posts; User: CVMichael

Page 1 of 13 1 2 3 4

Search: Search took 0.14 seconds.

  1. Replies
    4
    Views
    84

    Re: database structure

    I guess you are using MS Access, so yes... Autonumber...
  2. Replies
    4
    Views
    84

    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...
  3. Replies
    26
    Views
    635

    Re: Amateur Radio License Tests

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

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

    Here is a 21 century Flintstone: https://www.youtube.com/watch?v=syJq10EQkog :)
  5. 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...
  6. 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...
  7. 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...
  8. 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,...
  9. Replies
    10
    Views
    807

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

    Re: Optimizing Stored Procedure

    What database is this? SQL Server?
  11. Replies
    9
    Views
    36,200

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

    Thank you :)
    спасибо
  12. Replies
    10
    Views
    473

    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...
  13. Replies
    10
    Views
    473

    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 =...
  14. Replies
    10
    Views
    473

    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 =...
  15. 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]...
  16. Replies
    4
    Views
    756

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

    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?
  18. Replies
    9
    Views
    1,453

    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...
  19. Replies
    9
    Views
    36,200

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

    Actually, starting with SQL Server 2005
  21. Replies
    10
    Views
    1,610

    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,...
  22. Replies
    58
    Views
    34,086

    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!
  23. Replies
    13
    Views
    1,225

    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
  24. Replies
    13
    Views
    1,225

    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,
  25. 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>
    ...
  26. Replies
    36
    Views
    7,054

    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
  27. 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...
  28. 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.
  29. [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...
  30. Replies
    20
    Views
    920

    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...
  31. Replies
    20
    Views
    920

    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
  32. Replies
    20
    Views
    920

    Re: winsock question

    And... I choose not to be quick :)
  33. 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....
  34. Replies
    20
    Views
    920

    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,...
  35. Replies
    1
    Views
    789

    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...
  36. Replies
    205
    Views
    10,062

    Re: The State of VBForums

    Is Merri still around?
  37. Replies
    205
    Views
    10,062

    Re: The State of VBForums

    Ohh.. Facebook!

    IHA!!!
  38. Replies
    205
    Views
    10,062

    Re: The State of VBForums

    What is FB?
  39. Replies
    205
    Views
    10,062

    Re: The State of VBForums

    RobDog888, I just noticed this in your signature: API Viewer utility

    Isn't it interesting that one month after I created my add-in, and posted it here API Add-In for Visual Basic, they come up...
  40. Thread: Arduino

    by CVMichael
    Replies
    19
    Views
    1,974

    Re: Arduino

    I stopped working on my CNC.
    The newest thing is a chassis that it was meant to be the base of my new robot, but I did not finish it.
    This is what I have so far:...
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.