Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete from many tables
Message
From
08/01/2006 03:38:35
 
 
To
07/01/2006 08:41:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01084362
Message ID:
01084491
Views:
7
hi,
thank you.
>>hi,
>>thank you both,so much,it works
>>
>>for x=1 to 13
>>  use ('month'+ltrim(str(x,2))+'2005')
>>  delete for no=714
>>endfor
>>
>
><pre>
>for x=1 to 13
>  delete FROM ('month'+ltrim(str(x))+'2005') where no=714
>endfor
>
>
>>
>>>
>>>for x=1 to 1
>>>  use ('month'+trim(str(x,2))+'2005')
>>>  delete for no=1151
>>>endfor
>>>>hi all,
>>>>any idea help,
>>>>
>>>>i have 13 free tables as table(month12005) to table(month132005)
>>>>i need to delete emplyee number ( no=1151) from all tables,
>>>>
>>>>ex..
>>>>
>>>>for i=month12005 to month132005
>>>>delet for no=1151
>>>>next
>>>>
>>>>thanks
Previous
Reply
Map
View

Click here to load this message in the networking platform