Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Missing operand creating view
Message
 
 
À
09/11/2011 11:15:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01528498
Message ID:
01528501
Vues:
53
Try ?&vp_lfilter. . or is it &?vp_lfilter. ?

>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.)
>
>
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform