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.
For example:

selectquery = SELECT * from TBLPO where PO_NO = " + CSTR(inputPO.Text) + "

here inputPO.Text is a textbox in VB form.
On Excute statement, It gives me an ODBC error as [Microsoft][ODBC dBase Driver] Unexpected error from external database driver (9986).

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.

Thank you very much.

Anurag