Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
String too long to fit
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 5
Miscellaneous
Thread ID:
01192359
Message ID:
01192564
Views:
12
>>>Zakaria,
>>>
>>>What you need to do first is to reduce the length of the sentence:
>>> remove characters and strings like ";" , " as ", chr(13), etc. Make it as a plain string.
>>>
>>>Something like this:
>>>
>>>lc1=STRTRAN(cVelden,CHR(13)+CHR(10),"")
>>>lc1=STRTRAN(lc1," as "," ")
>>>lc1=chrtran(lc1,";","")
>>>lc1=chrtran(lc1,CHR(9)," ")
>>>DO WHILE SPACE(2)$lc1
>>> lc1=STRTRAN(lc1,SPACE(2)," ")
>>>enddo
>>>
>>>*The length of your statement will be greatly reduced, and you will be able to apply:
>>>
>>>SELECT &lc1. from your_table
>>>
>>
>>Still 7118 bytes :-)
>
>?len(lc1) && I got 6168

:o)
Sorry,
My messagebox with LEN() was with old variable in it, not with converted one. 6168 it is.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform