Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Syntax error
Message
 
 
À
15/08/2007 09:05:35
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:
01248230
Vues:
29
Change
USE (ma) alias WorkTable

to

USE (ma) alias WorkTable exclusive

I could not figure out what's wrong with the syntax in this line
delete from WorkTable inner join RecToDelete on WorkTable.telNo = RecToDelete.TelNo
I have VFP8, and INNER JOIN is not listed in DELETE-SQL command in Help.

Anyway,
delete from WorkTable where exists (select * from RecToDelete)
should work in VFP8 as well as in VFP9.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform