Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax error
Message
From
16/08/2007 02:25:10
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01247986
Message ID:
01248446
Views:
32
hi,
thank you very much,
it works as Mr.Tamar(message).
delete WorkTable;
       from WorkTable;               
inner join RecToDelete on WorkTable.telNo = RecToDelete.TelNo
>VFP9 Help at http://msdn2.microsoft.com/en-us/library/6kt4x6zx(VS.80).aspx doesn't give an example of INNER JOIN in Delete and thus I could not figure out the correct syntax. I don't remember if I tried it in VFP9 before myself.
>
>Sorry.
>
>Should have been double FROM, e.g.
>
>delete from MyTable from MyTable inner join myOtherTable on ...
>
>>thank you very much.
>>it works.
>>>Change
>>>USE (ma) alias WorkTable
>>>
>>>to
>>>
>>>USE (ma) alias WorkTable exclusive
>>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform