Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Basic Problem
Message
 
 
To
12/07/2002 19:14:40
Rodolfo Novoa
Consultor Independiente
Tegucigalpa, Honduras
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00678312
Message ID:
00678315
Views:
17
VFP has a limit of 255 characters per string literal. You can split it in the shorter parts and join them with '+' operator. The limit on the size of string variable (according to the help) is 16,777,184 characters.
MySele = "12345678901234567890123456789012345678901234567890" + ;
  "12345678901234567890123456789012345678901234567890" +  ;
  "12345678901234567890123456789012345678901234567890" +  ;
  "12345678901234567890123456789012345678901234567890" +  ;
  "12345678901234567890123456789012345678901234567890" +  ;
  "12345678901234567890123456789012345678901234567890" +  ;
  "12345678901234567890123456789012345678901234567890" +  ;
  "12345678901234567890123456789012345678901234567890" +  ;
  "12345678901234567890123456789012345678901234567890"
>I am working in Visual Foxpro 6.
>
>1-. if i want to use SQLEXEC and my SQL sentence is to some extend,
> Visual Foxpro send me one error relation with string too longe. so
> that, can't work with sentence SQL Large, and this is my case.
> example:
>
>
< snip >
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform