Access Problem

John Yeager webbmaster2001 at directvinternet.com
Tue Dec 25 01:20:14 EST 2001


Useing the following code to access a Access Database, I run into a problem
getting the Database to Autonumber the primary key

Here is my code what am I missing
import time
import odbc

Time = time.ctime(time.time())
connection = odbc.odbc('Everquest')
cur = connection.cursor()
sql = "Insert into Member VALUES( '(Autonumber goes here )','test',
'test','NULL','p','R300478','Testuser','Test','%s')" % ( Time )
cur.execute( sql )
connection.commit()
cur.close()
connection.close()

So what am I doing wrrong here?







More information about the Python-list mailing list