|
| |
|
|
Guest
 |
INSERT statement problem using variables - 3/5/2001 15:25:00
Jeesh! I know this can't be that difficult! ;-)What am I doing Wrong!? The Insert SQL statement: SQL = "INSERT INTO test.txt VALUES(strName,strStreet,strCity,strState,strZip)" NOTE: the variables come from a firm and are DIM'd prior to the statement. The Error: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Text Driver] Too few parameters. Expected 5.
Help!
Larry
|
|
|
|
Elecia
Posts: 68
From: orlando
Status: offline
|
RE: INSERT statement problem using variables - 3/5/2001 15:39:00
Is test.txt the name of the table or is it actully a text box?
| |
|
|
|
Guest
|
RE: INSERT statement problem using variables - 3/5/2001 15:44:00
The DB is a text DB and the table is test.txt It has something to do with the syntax of the VALUES(xxxxx) variables, it works fine with direct input, SQL = "INSERT INTO test.txt VALUES('Name','Street','City','State','Zip')" This yields the text,ie: 'Name'(single for double quotes here), into the data fields in the record.
| |
|
|
|
Spooky
Posts: 26597
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: INSERT statement problem using variables - 3/5/2001 18:47:00
Did my email help?Im a bit lost on the talk of single vs double quotes too. All quotes should be single ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
Guest
|
RE: INSERT statement problem using variables - 3/5/2001 21:26:00
Yep, Spooky, thanks that was it. Thank you as Elicia!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
