Results 1 to 2 of 2

Thread: How to select one record through SQL?

  1. Oct 12th, 1999, 08:18 PM #1
    ganraj
    ganraj is offline

    Thread Starter
    Member
    Join Date
    Feb 1999
    Location
    dubai
    Posts
    39

    Post

    Hello!

    I want to select any one record from access database without using where clause.How do I do it? I am using VB 5.0 with access MDB.

    Can anyone help?



    ------------------
    ganraj.
    Reply With Quote Reply With Quote
  2. Oct 13th, 1999, 03:01 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105

    Post

    Why?

    If you don't use a where clause, your only other choice is a table scan (sequential read of all table data).
    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