Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    8

    Question Unanswered: Best method of reading a single record into a vb app

    So far have got a connection and a read happening via a SELECT statement? If l wanted to read a single record from a db2 table (8.2 Express) via VB what would be the preferred method, for example SELECT * FROM TABLE where KEY = 'VALUE', is there another method l am unaware of ?

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    1 row

    if key=value returns a single row (unique index) this is preferred
    otherwise : select .... fetch first rows only (if multiple rows apply to result)
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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