Link to home
Start Free TrialLog in
Avatar of AndySulz
AndySulz

asked on

Simple MYSQL VB Question ....

TestTable has 2 columns i is an auto number the other is an integer value table..

If I do
adoconn.execute "Insert into TestTable(FIELD1), Values(123);"

how would i get the autonumber back out of the table?

Avatar of AndySulz
AndySulz

ASKER

FIELD0 IS THE AUTONUMBER FIELD AND FIELD1 IS THE INTEGER(3) COLUMNS
ASKER CERTIFIED SOLUTION
Avatar of GregJennings
GregJennings

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
i actually figured it out a while ago.... but i will give you the points..
Thanks.  Have you seen the MySQL docs?  They are in HTML in the "docs" folder under the main MySQL folder.
i read it at mysql.com