Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL server vs Foxpro table
Message
De
24/10/2003 04:57:29
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00840975
Message ID:
00841981
Vues:
29
Hi Martin,

>This is NOT complex, as the article shows. Take a look at it.
>http://www.utmag.com/July2002/Page22.asp

really nice article.

One comment: Since the idea is to use VFP-tables
"server-alike", it is evident that VFP-tables
can be read by the main app, and this app probably
is a VFP app.

If you are returning medium to large resultsets,
CursorToXML is not very fast: why don't you select
"serverside" into a sys(2015)-named table and StrToFile()
the neccersary files (.dbf, .Fpt?) with a simple
convention like a header block into a lcReturn?

I guess this approach will be significantly faster
if you are returning large sub-sets of very large
tables.

my 0.02 EUR

thomas
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform