Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete from many tables
Message
De
07/01/2006 07:36:39
 
 
À
07/01/2006 07:29:37
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Divers
Thread ID:
01084362
Message ID:
01084372
Vues:
10
>>
>>for x=1 to 1
>>  use (trim(str(x,2))+'2005')
>>  delete for no=1151
>>endfor
>
>trim() will only trim to the right, IIRC. Here you need ltrim() or alltrim(); or simply convert the number with trans(x).

Yes, I ment to use alltrim, but I simply forgot. I also thought about the transform function, but on top of my head I was not sure if it defaulted to trim the result or not, but it sure does. So your solution is the simplest in this case.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform