Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete from many tables
Message
From
08/01/2006 07:48:49
 
 
To
08/01/2006 06:22:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01084362
Message ID:
01084502
Views:
9
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    &&File must be opened exclusively
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform