Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Missing operand creating view
Message
De
09/11/2011 11:15:58
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Missing operand creating view
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01528498
Message ID:
01528498
Vues:
120
I am creating a view from a table and wanting to use macro substitution for the last view parameter. I've done this VFP6, but having a problem with VFP9. I am using VFEGenview to create the view. I get an error that I have a missing operand upon saving the view. I don't see the problem, does anyone else? The specific view parameter I'm having a problem with is &vp_lfilter.
CREATE SQL VIEW "LV_PLANSCHOOLS" ; 
	AS SELECT Planschools.cid, Planschools.cschool,;
		Planschools.clogo, Planschools.linsteval, Planschools.cstate,;
		Planschools.ltoprated, Planschools.lacceptds, Planschools.csemqtr,;
		Planschools.lexpcreditok, Planschools.lnatcredok,;
		Planschools.nlltuit, Planschools.nultuit, Planschools.ngltuit,;
		Planschools.nclasshrs, Planschools.nmatcost, Planschools.llockout,;
		Planschools.cfinaidid, Planschools.lacceptclepgen,;
		Planschools.lacceptclepsub, Planschools.lacceptdsst,;
		Planschools.lacceptexcl, Planschools.ccollegeid,;
		Planschools.mnotes, Planschools.lnatacredited, Planschools.tsaved,;
		Planschools.csavedby;
	FROM autodp!planschools;
	WHERE UPPER(Planschools.cschool) LIKE UPPER(?vp_cschool) AND;
		Planschools.cstate = ( ?vp_cstate ) AND &vp_lfilter;
	ORDER BY Planschools.cschool

DBSetProp('LV_PLANSCHOOLS', 'View', 'UpdateType', 1)
DBSetProp('LV_PLANSCHOOLS', 'View', 'WhereType', 3)
DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchMemo', .T.)
DBSetProp('LV_PLANSCHOOLS', 'View', 'SendUpdates', .T.)
DBSetProp('LV_PLANSCHOOLS', 'View', 'UseMemoSize', 255)
DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchSize', 100)
DBSetProp('LV_PLANSCHOOLS', 'View', 'MaxRecords', -1)
DBSetProp('LV_PLANSCHOOLS', 'View', 'Tables', 'autodp!planschools')
DBSetProp('LV_PLANSCHOOLS', 'View', 'Prepared', .F.)
DBSetProp('LV_PLANSCHOOLS', 'View', 'CompareMemo', .T.)
DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchAsNeeded', .F.)
DBSetProp('LV_PLANSCHOOLS', 'View', 'FetchSize', 100)
DBSetProp('LV_PLANSCHOOLS', 'View', 'ParameterList', "vp_cschool,'C';vp_cstate,'C';vp_lfilter,'L'")
DBSetProp('LV_PLANSCHOOLS', 'View', 'Comment', "")
DBSetProp('LV_PLANSCHOOLS', 'View', 'BatchUpdateCount', 1)
DBSetProp('LV_PLANSCHOOLS', 'View', 'ShareConnection', .F.)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform