Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax error
Message
De
16/08/2007 02:25:10
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01247986
Message ID:
01248446
Vues:
33
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
>>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform