odbc error

Stephen Prinster prinster at mail.com
Thu Sep 30 02:01:31 CEST 2004

Michele Petrazzo wrote:
> I'm using odbc on win95 and I have an incomprehensible error after a query:
> INSERT INTO test VALUES (f1,f2,f3) VALUES ("t1", "t2", "")
> table test and fields f1,f2,f3 exists :) and I can write to this table.
> The error is :
> [Microsoft][Driver ODBC dBase] Too few parameters. Expected 2.
> What can I do?
> Thanks,
> Michele Petrazzo
In addition to using single quotes and assuming f1, f2, f3 are field 
names, try eliminating the first "VALUES", like this:

INSERT INTO test (f1,f2,f3) VALUES ('t1', 't2', '')

More information about the Python-list mailing list