Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace record from other dbf
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
00994807
Message ID:
00995167
Vues:
22
SELECT 38
ZAP
alias38 = ALIAS()

SELECT 6
mcode  = LCode
msec   = Sec
alias6 = ALIAS()

INSERT INTO (alias38) (scode, lcode, sec, nostudent);
             SELECT DISTINCT scode, lcode, sec,;
                    (SELECT COUNT(*) FROM (alias6) WHERE admtd=1 and lcode=mcode.and. sec=msec);
             FROM (alias6) group by scode,lcode,sec WHERE admtd=1

sele 38
...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform