Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding wwSQL to Application Object
Message
 
To
19/12/2000 10:27:22
Gerald McKinsey
Keystone Consulting Services, Inc.
Yorktown, Indiana, United States
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00453654
Message ID:
00455044
Views:
45
>I can understand some needs due to West Wind integration, but do you have to have SQL passthrough for your VFP-MM business objects? What's wrong with just using Remote views to access SQL tables?

I think some things are better left to SPT. For example, I have to import data from a third party source. They have a unique identifier, called MGID, while I use surrogate primary keys in my table. So when I import the data, I have to:

SELECT CompanyID FROM Company WHERE MGID = lcMGID

I suppose I could create a view for this, but it seems as though at some point I will need SPT functionality.
Chris McCandless
Red Sky Software
Previous
Reply
Map
View

Click here to load this message in the networking platform