Re: Access SQL Server Express over the Internet

Arthur Hoornweg brought next idea :
danny heijl wrote:

us advantages of any xml/rpc or soap or home-brew xml solution:

- decoupling of the front end and back-end. You can change one end without having to change the other end => less deployment problems when upgrading
- you don't have to configure database connections and database middleware on the clients => less deployment problems
- you can add any logic at the back-end that you like
- you can do content-checking at the back-end to increase security
- you can aggregate several result sets into a single request if round-trip time becomes a problem


How about the tons of data-aware components that are around?
Are they still usable? Is in-place editing in dbgrid's still possible?

If implented corectly yes, you can use all this. You can simply get any XML based result and inserted in a memory dataset like ClientDataset or kbmMemTable. When you have finised editing a row the you could just post the changes back on a before post event and issue a an abort if this fails or let the post complete if everything is OK.


Regards
Yannis.


.