SET RANT ON and SET RANT off means that whatever is between those two lines are ment not to be taken too seriously, but more like a friendly joke. They are not VFP commands.
>hi,
>thank you,it works,
>i try to see SET RANT ON/OFF VIA HELP, I get
> PROCEDURE Command,
>
>SET RANT ON/off ,WHEN I MUST USE IT .
>
>THANK YOU
>
>>SET RANT ON
>>Do you ever check with help?
>>SET RANT OFF
>>
>>SET EXCLUSIVE ON & Not OFF, OFF is if you must share, to pack it must be ON!!!!!!!!!
>>
>>By the way, SET EXCLUSIVE OFF is usually only set ONCE in your program, or in the config.fpw file. In stead you add the EXCLUSIVE keyboard whenever you need it
>>
>>
>>for x=1 to 1
>> use ('month'+alltrim(str(x,2))+'2005') EXCLUSIVE
>> delete for no=1151
>> pack
>>endfor
>>And if you need to PACK regularly, you should reconsider your design. PACK should typically be used about once a year to clean up the tables, not daily or weekly!
>>
>>>hi,
>>>i try to make pack only at one pc, i get error message "File must be opened exclusively "
>>>
>>>SET EXCLUSIVE off
>>>for x=1 to 13
>>> delete FROM ('month'+ltrim(str(x))+'2004') where no=1231
>>> pack
>>>endfor
>>>
>>>
>>>thanks
>>>>>>
>>>>>>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.