Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What could cause error on this line
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01526039
Message ID:
01526050
Views:
68
Likes (1)
>Hi,
>
>I am getting an error a line very similar to the following. The error says "command contains unrecognize phrase/keyword".
>
>
>cSqlInsert = "insert into Mytable (fld1, fld2, fld3) values (?MyTable.fld1, ?MyTable.fld2, ?MyTable.fld3)"
>
>
>The list of fields is actually considerably longer. But what should I be looking at? TIA.

Considerable longer? How much longer? There is a limit of 8190 characters for any command in foxpro: try
EXECSCRIPT(REPLICATE('*', 8190))
EXECSCRIPT(REPLICATE('*', 8191))
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform