Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete from many tables
Message
From
07/01/2006 10:05:24
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
07/01/2006 07:36:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01084362
Message ID:
01084398
Views:
8
>>>
>>>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.

I should add that transform() produces inconsistent results among different versions (some errors were fixed, others were added, apparently), but AFAIK, this doesn't affect integers, only some decimals.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform