Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VSP6SP5: How can I select a DBF when it is a view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
VSP6SP5: How can I select a DBF when it is a view
Divers
Thread ID:
00766706
Message ID:
00766706
Vues:
55
Hi all

I have the following logic where THIS.cViewName = "v_mAccounts"
lnSelect = SELECT(0)
lcVN     = THIS.cViewName
lcID     = THIS.cID
lcPID    = THIS.cParentID
lcText   = THIS.cText
lcOrder  = THIS.cOrder

SELECT "R" + STR(&lcID.) AS iID, &lcText. AS cName ;
	FROM (lcVN) ;
	WHERE !DELETED() AND EMPTY(&lcVN..&lcPID.) ;
	ORDER BY &lcOrder. ;
	INTO CURSOR tQuery

SELECT tQuery
LOCATE
now when the query runs it asks me to locate v_mAccounts.DBF. How can I get it to understand that v_mAccounts is a view?
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform