July 13th, 2003, 12:08 AM
|
 |
Contributing User
|
|
Join Date: Jul 2002
Posts: 123
Time spent in forums: 2 h 51 m 51 sec
Reputation Power: 6
|
|
|
ODBC Access driver error: too few parameters **[RESOLVED]**
Hi,
I'm using an Access XP database to which I connect from my VB application using ADO.
when trying to insert or update a record I get an ODBC Access driver error: too few parameters, expected x (the number change according to whether it's an Insert or an Update SQL).
My SQL is:
INSERT INTO tblPeople (pplFirstName, pplSurname, pplDOB, pplIDNumber, pplImagePath, pplNotes, pplGender, pplAddress, pplCity, pplZipCode, pplPhone1, pplPhone2) VALUES("Guy", "Arbel", #07/13/1977#, "12345678", "", "", 1, "Wall Street", "NY", "19237", "04-9895564", "051-246452")
When I run the SQL as a query in the Access database it runs without a hitch.
The same problem happens with an Update SQL.
Any ideas?
Thanx
Last edited by shafan : July 13th, 2003 at 03:31 AM.
|
Dev Shed Forums Sponsor:
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
