General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2000 Server
>Dear all,
>
>I would like to insert a record with over 20 variables. The compiler always show an error message "Too many parameters". The syntax is ok and I try to minimize the variables into 10. It is ok!! Any limitation of the length of statement? How can I insert more than 20 variables within a SQL statement?
>
>Thanks a lot and feel free to contact me if you have any question.
>
>Best Regards,
>
>Justy
Try to keep the SQL-statement clear to make sure things line up and
not too much on a single line... using ; to break lines... ex:
Insert into MyTable ;
( TblField1,;
TblField2,;
... ,;
TblField20);
values;
( MemField1,;
MemField2,;
... ,;
MemField20 )
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only