I am new to VB (first week).. and using ObjGen1.1 (www.ewsystems.com) to
generate code for ADO embedded sql access to an ODBC connected Access .mdb
database.
I tried to use SEEK and NOMATCH today and got an error. i DISCOVERED that the
code which ObjGen generated is a SNAPSHOT type, which is a static cursor, and
therefore... i quess, does not support the SEEK command (being a newbe i could
be totally wrong here), but I realized that I could execute a REQUery AGAINST
the underlying table, and product different recordsets with the record or range
of records that I want, and that this served the same purpose as a SEEK.... so
I gave up for now trying SEEK and NOMATCH and i am playing with REQUERY .....
but i have emailed my questions to one more knowledgable that I.. and I await
their criticisms and advice...
hope this helps
email me ... sitaram at xxxaol.com (remove xxx) if anyone has suggestions to
help me
thanks