SauveASCII

Avancé

Utilisé par DFF pour faire une sauvegarde de la banque de données en format texte (ascii)

Assure la jointure entre les tables Spec, Cond, Stat, SpecMemo, CondMemo et StatMemo.

SELECT STAT.STAT_ID, PROJECT_ID, STAT.ORD, CODE, CADA, SGIB, TOPO, LOCA, FIPS, DESI, ORIG, UTM, DATUM, LATI, LONG, UGRI, X, Y, PREC, CODEGEO, ALTI, HAB1, HAB2, EXPO, REF, STAT.USERA1, STAT.USERA2, STAT.USERA3, STAT.USERA4, STAT.USERA5, STAT.USERA6, STAT.USERA7, STAT.USERN1, STAT.USERN2, STAT.USERN3, STAT.USERN4, STAT.USERN5, STAT.USERN6, STAT.USERN7, COND.STAT_ID, COND.COND_ID, COND.ORD, DAT1, DAT2, CAPT, CAPN, CPI, MICR, COND.TAX, COND.TAXPRIO, COND.GR1, COND.GR2, COND.GEN, COND.SP, COND.CLAS, ECHA, APPA, COND.USERA1, COND.USERA2, COND.USERA3, COND.USERA4, COND.USERA5, COND.USERA6, COND.USERA7, COND.USERN1, COND.USERN2, COND.USERN3, COND.USERN4, COND.USERN5, COND.USERN6, COND.USERN7, SPEC.STAT_ID, SPEC.COND_ID, SPEC.SPEC_ID, SPEC.ORD, SPEC.TAX, SPEC.TAXPRIO, SPEC.GR1, SPEC.GR2, SPEC.GEN, SPEC.SP, SPEC.CLAS, SEX, DEVL, N, UNIT, ABOND, ABONDUNIT, SOCIAB, DET, REC, AUCT, SRC, COLL, CONF, REFBIB, SPEC.USERA1, SPEC.USERA2, SPEC.USERA3, SPEC.USERA4, SPEC.USERA5, SPEC.USERA6, SPEC.USERA7, SPEC.USERN1, SPEC.USERN2, SPEC.USERN3, SPEC.USERN4, SPEC.USERN5, SPEC.USERN6, SPEC.USERN7, STATMEMO.Memo, CONDMEMO.Memo, SPECMEMO.Memo
FROM ((((STAT LEFT JOIN STATMEMO ON STAT.STAT_ID = STATMEMO.STAT_ID) LEFT JOIN COND ON STAT.STAT_ID = COND.STAT_ID) LEFT JOIN SPEC ON COND.COND_ID = SPEC.COND_ID) LEFT JOIN CONDMEMO ON COND.COND_ID = CONDMEMO.COND_ID) LEFT JOIN SPECMEMO ON SPEC.SPEC_ID = SPECMEMO.SPEC_ID
ORDER BY SPEC.STAT_ID, SPEC.COND_ID, SPEC.SPEC_ID

Paramétrée Type 'action' Interne uniquement Jointure externe

(uniquement si sauvegarde de la requête en fichier externe)
SauveASCII

3/5/2003