Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERT command
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01015160
Message ID:
01015167
Views:
21
>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
Map
View

Click here to load this message in the networking platform