Unanswered: SELECT query for AUTOINCREMENT field in VB6
Dear my friends....
I have a DB2K column with auto_increment, namely "PO_NO".
I want to know how to Select a record based on Autoincrement field.
selectquery = SELECT * from TBLPO where PO_NO = " + CSTR(inputPO.Text) + "
It gives me an ODBC error. while if I runthe same query with a Numeric field, it works fine.
Please let me know how can I search on the BASIS of Autoincrement field.