CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. November 29th, 1999, 03:19 PM #1
    sle
    sle is offline Junior Member
    Join Date
    Nov 1999
    Posts
    1

    SQL Query in VB 5.0

    Can anyone tell me how to get the total number of records in a recordset by using "Select count(*) from table" in VB 5.0?

    Reply With Quote Reply With Quote
  2. November 29th, 1999, 05:59 PM #2
    Crazy D
    Crazy D is offline Member
    Join Date
    Apr 1999
    Location
    Rotterdam, Netherlands
    Posts
    278

    Re: SQL Query in VB 5.0

    rs.Open "SELECT COUNT(*) FROM mytable"
    Debug.print rs.Fields(0)
    rs.Close

    Crazy D :-)
    "One ring rules them all"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured