Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I force temp cursors to be temp files?
Message
De
27/05/1999 11:50:00
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
27/05/1999 11:00:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00223456
Message ID:
00223498
Vues:
26
>I'm creating a temporary cursor which is based on a .frx and would like to use the temporary cursor to run the report. 80% of the time this is ok as I can obtain the filename using dbf() and run the report from here, but sometimes the cursor seems to exist only in memory and not as a file. Is there anyway to make sure that the temp cursor exists as a file as well as a cursor?
>
>Thanks,
>
>Mace
Mace,
It would be created on disk even cursor so select into table and make it explicitly temporary :
tcTempFileName = getenv("temp")+"\"+"T"+sys(2015)
tcReportFileName = "myreport"
select * from (tcReportFileName+".frx") into table (tcTempFileName)
use in (tcReportFileName)
* frx modifications if needed - ie:blank expr, tag, tag2
*locate for Expr = ["Myheader"]
*replace Expr with ["Where is your header. Your header is RIP"]
use
* select file to report on
report form (tcTempFileName+".dbf") preview
erase (tcTempFileName+".*")
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform