SQL JDBC

[sharad]

HI All
I want to insert a row into my Database which is in the form of a MDB File . Now the problem is that one of the entries in the row is a AutoNumber which Microsoft Access generates itself .

Suppose i have 4 entries in a row and the 1st is AutoNumber .
If i give the Query

INSERT INTO thetable values(,q,w,e)
it gives an SQL error , obviuosly

I tried a hell lot of jugglery but to no avail

Help me out
Sharad

[Sameet Nasnodkar]

Sharad

Let me assume that the fields are called f1 f2 f3 f4. As you said f1 is an autonumber.

Then your statement changes to

INSERT INTO thetable (f2,f3,f4) values (q,w,e)

Try this....it should work....Tell me if it doesn't...