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
 
À
18/03/2003 14:15:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00766706
Message ID:
00767400
Vues:
13
Hi Tamar. I stil have this error:
Error #:    1
Message:    File 'v_maccounts.dbf' does not exist.
Line #:     44
Code:       SELECT "R" + STR(&lcID.) AS iID, &lcText. AS cName FROM (THIS.cDBCName + "!" + lcVN) WHERE !DELETED() AND EMPTY(&lcVN..&lcPID.) ORDER BY &lcOrder. INTO CURSOR tQuery
Method:     buildtree
Object:     frmmaccounts.pgf.cntiIDTreeView
>>Hi all
>>
>>I have the following logic where THIS.cViewName = "v_mAccounts"
>>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?
>
>Include the database name:
>
>This.cViewName = "MyDatabase!v_mAccounts"
>
>Tamar
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform