Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro expansion of view parameter
Message
 
To
21/07/2003 21:57:23
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00811862
Message ID:
00812214
Views:
11
Glad we got there in the end !!

At Finspreads, I did mostly that: the updatable stuff went through remote views, and the downloads of read-only data came back through SQLEXEC() wrapped up to handle data conversions etc.

Latterly, I started doing updated via stored procedures as well, because then I could call the update routine from the VFP client or an ASP page.

You still have to make sure you're ok with the syntax of the command you're building, i.e. not reference local tables etc, the basic stuff.

Regards
Simon
PS Can't you sleep?
SJC Systems Limited
WorldSpreads Limited (www.worldspreads.com)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform