Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Statement Limit
Message
 
 
To
03/03/2003 08:36:35
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00760316
Message ID:
00760328
Views:
19
Renoir,

I meant, Maximum # of characters per command line 8,192 but both of then come to the same number. Can you provide more details, maybe post some code, to explain what are you trying to do and where do you encounter a problem?

>Sergey,
>
>You mean this?
>
> Maximum # of characters per macro substituted line 8,192
>
>My problem is that when testing an SQL statement in the Command Window, it seems to want to "break" (add a ";") at around the 1,015th character. I thought it might be a capacity issue.
>
>Renoir
>
>>>What is the length limit to a SQL Statement? Is it 1024? Couldn't find this documented.
>>>
>>>Regards, Renoir
>>
>>Renoir,
>>
>>The same as for any VFP statement - 8,192 characters. You can find it in the help under Visual FoxPro System Capacities
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform