ADOQuery Giving me trouble again....

[memevertical2]

Hi, I'm trying to run a command in SQL, the INSERT INTO command, but it gives the following error: Parameter Object is Improperly defined. Inconsistent or incomplete information was provided.

The SQL text has 50 fields and values. If I use the code, one field at a time, it gives that error in a specific Field, but the funny thing is that the field were it stops, is identical to the other fields, a simple Text Field.

What can be going wrong?

 

[DjangMan]

SIZE a reserved word in SQL.

So if your SQL statement was something along the lines of:

INSERT INTO Listings ([Size]) VALUES ('50');

then that would work.

 

[memevertical2]

So, do you think its a good idea to include [] on all fields in case the user creates a column with other reserved word?

 

[DjangMan]

It doesn't hurt. My SQL code generators do it all the time.

 

[memevertical2]

Ok cool, it works!!! Thanks a lot!!!....