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! :-)