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 SintaxDBC: 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! :-)
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Rodolfo Duarte