>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 )