Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL server vs Foxpro table
Message
From
24/10/2003 04:57:29
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00840975
Message ID:
00841981
Views:
28
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform