Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
String too long to fit
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 5
Divers
Thread ID:
01192359
Message ID:
01192564
Vues:
11
>>>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform