Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select without Nofilter is Nofilter
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01577987
Message ID:
01577988
Vues:
79
>
SELECT * FROM mytable WHERE keyvalue = "myvalue" INTO CURSOR myCursor
>? DBF('myCursor')
>
>On my computer I get an unexpected result of: c:\tempfilepath\xxxx.tmp
>
>On a co-workder's computer I get the expected result of: c:\path\mytable.dbf
>
>
>
>Is there some setting or condition which controls whether or not a cursor is created NOFILTER by default?
>
>Thanks to all..........Rich


I'm not sure what you mean by NOFILTER ...but does this help??

When SET FULLPATH is ON, DBF( ) returns the path to the table with the table name.
When SET FULLPATH is OFF, DBF( ) returns the drive on which the table resides with the table name

SET PATH and your windows environment settings might play a part in this too (where the temp files are created when doing INTO CURSOR.)
ICQ 10556 (ya), 254117
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform