Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete from ...select issue
Message
De
13/09/2007 21:06:22
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01254242
Message ID:
01254264
Vues:
14
>Hi again,
>i found where is the mistake
>i've changed to the line
>
INNER Join (Select cSrc1.formadi;
>instead of below
>
INNER Join (Select formadi;
>
>but code doesnt delete the records :(

Are you sure the selection returns any records? The records to delete would be those returned by
select * From user01;
	INNER Join (Select cSrc1.formName;
	FROM (m.lcSource01) cSrc1;
	LEFT Join (m.lcTarget01) cSrc2 On cSrc1.formName == cSrc2.formName;
	WHERE cSrc2.formName Is Null) cSrc3;
	ON user01.formName == cSrc3.formName
So if this returns one record, that one record would be deleted if we replace Select * with the delete.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform