Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote tables
Message
 
To
23/07/2004 10:06:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00927345
Message ID:
00927520
Views:
17
>>the several applications I have created all share data. I share the remote data from one app to the next using SPT. Some one asked me why I didn't use Open Database command instead of ODBC. I really don't know how to answer the question. I would like to know which is the better method. I have posted this question severl ways with no response, so please help me at least know how to answer this situation. My programming skills are lacking. I can >>usually get the task done, however I don't always know the best way.

Hi,

If you consider security for your data, better use SPT, eventhough it requires more code than ODBC. In ODBC, just create updateable views and thats it, its easier to update & delete. But, if a clever user wants to destroy the data, its very easy install VFP, just browse the remote views and thats it, he has the total control of the data... And in fact, as Borislav says, more easier for you if you plan to migrate/upsize your data to SQL Server...
Jojo R. dela Cuesta, B.Sc.
eConsultant, Programmer
Dalplus Technologies
http://www.dalplus.com
Previous
Reply
Map
View

Click here to load this message in the networking platform