odbc error
Stephen Prinster
prinster at mail.com
Wed Sep 29 20:01:31 EDT 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