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

    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

    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

Posting Permissions

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