Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
1 App N Databases
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00820139
Message ID:
00820670
Views:
19
Take a look at http://fox.wikis.com/wc.dll?Wiki~TightlineDataClasses

>Hello!
>
>I've been thinking about create just one exe that could access one of this list of databases: DBF, SQL Server or Postgree.
>
>1) Security!
>
>With DBF, I have a USERS table and I control security using it. For example: If user can view, insert, update or delete records from a table.. How control how much discount each user could offer in an order... and so on...
>
>If I'd use SQL or Postgree, I know I can control this kind of stuff using the DB. But each DB controls it the different ways...
>
>And... Lets suppose that one user can delete a kind of customer (inactive), but he can't delete other (active)... How control it?
>
>2) Difference in Sintax
>
>DBC: Select Nome+Sobrenome From Customers ou Update Customers Set Name = "Rodolfo" Where Id = "100" works without problems... But others databases doesn't. How handle it?
>
>I'd like to use CursorAdapter... Does CA control it for me? If I change from NATIVE to OBCD, CA will works without problems?
>
>3) Other stuff:
>
>DBC: Begin Transaction / End Transaction / Rollback ... If I use SQL Commit... - How prepare my app to handle transactions with 3 (or more) databases?
>
>Views / Backup / Stored Procedures: Each database works one way... How minimize this differences?
>
>TIA! TIA! TIA! :-)
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform