Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Ugly SQL
Message
De
02/10/2001 15:15:06
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Ugly SQL
Divers
Thread ID:
00563216
Message ID:
00563216
Vues:
47
This baby seems to fail:
SELECT CONFIGFILES.*, ;
		PARAMETERS.CNAME, ;
		PARAMETERS_A.CNAME, ;
		PARAMETERS_B.CNAME, ;
		PARAMETERS_C.CNAME ;
	FROM GULFSTREAM!CONFIGFILES ;
		LEFT JOIN GULFSTREAM!PARAMETERS ;
		LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_A ;
		LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_B ;
		LEFT JOIN GULFSTREAM!PARAMETERS PARAMETERS_C ;
				ON CONFIGFILES.IREMOTEPARAM4 = PARAMETERS_C.IPARAMID ;
				ON CONFIGFILES.IREMOTEPARAM3 = PARAMETERS_B.IPARAMID ;
				ON CONFIGFILES.IREMOTEPARAM2 = PARAMETERS_A.IPARAMID ;
				ON CONFIGFILES.IREMOTEPARAM1 = PARAMETERS.IPARAMID ;
	WHERE CARTICLEID = ?VP_CARTICLEID
This is a remote view that I coded with viewedit. It can't seem to find iremoteparam4, even though the field is in the database. Any clues as to what's going on?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform