Database Access

[Ronald van Tour]

That would be sufficient.

[Kevin Powick]

Would a "Fishfact Demo" be enough, or does it have to be something more complex?

Probably good enough, but it might be nice to include a simple master/detail example, as it is a common real world data scenario.

[D.Tkalcec (RTC)]

RealThinClient SDK v4.28 is now ready for download, with "FishFactClient" and "FishFactServer" Projects. If there are any questions or suggestions about the "FishFactClient" and "FishFactServer" Projects, please post them to the "PRO Support" section.

A master/detail example should be ready in a few days.

Best Regards,
Danijel Tkalcec

[D.Tkalcec (RTC)]

RealThinClient SDK v4.29 is now also ready for download, introducing a "FishFactServer2" Project which demonstrates the use of SQL-capable components on the Server to fetch data from a Database, send it to the Client, then receive changes from the Client (INSERT/UPDATE/DELETE) and execute them on a Database by using SQL.

"FishFactClient" Project (introduced in v4.28) can be used for testing the "FishFactServer2" as well as the "FishFactServer" Project, because both Server-side implementations use the same "protocol".

All "FishFact" Projects can be found in the "Demos\DB_Access" folder.

Best Regards,
Danijel Tkalcec

[Ronald van Tour]

thanks for the extensive demos they are very usefull, I have already tested the demos and I am impressed
I will post on the pro support section if I have any technical remarks or questions.

[D.Tkalcec (RTC)]

I've added another Client-side Database Demo Project by using TClientDataSet as Client-side in-memory storage, utilizing the TRtcDataSetMonitor component to catch any changes made to the DataSet and send them to the Server. This new Project is called "FishFactClient2", can be found in the "Demos\DB_Access" folder and is fully compatible with "FishFactServer" and "FishFactServer2" Projects, just like the "FishFactsClient" Project.

The idea behind using a TRtcDataSetMonitor (as in this new example) is to allow you to work with any 3rd-party TDataSet descendant component on the Client, or even mix different TDataSet implementations, while keeping your Server-side code unchanged. There are a lot of good in-memory TDataSet implementations available for Delphi and you can use any one of them with the RTC SDK, or use the simple and light-weight TRtcMemDataSet, which is now a part of the RTC SDK.

Best Regards,
Danijel Tkacec

[D.Tkalcec (RTC)]

RealThinClient SDK v4.36 is now ready for download, introducing a new "MasterDetailClient" example Project (under "Demos\DB_Access"), which uses asynchronous communication and the TRtcMemDataSet to work with DB-aware controls for displaying and editing of three related Tables received from the "BDEDemoServer" Project: Customers (master table), Orders (customer details) and Items (order details). Should anyone have questions about this new example Project, please post them to the "PRO Support" Forum section.

Best Regards,
Danijel Tkalcec

[D.Tkalcec (RTC)]

RealThinClient SDK v4.37 is now also ready for download, adding a new DB Client example which uses TClientDataSet and TRtcDataSetMonitor components (instead of TRtcMemDataSet) to demonstrates the use of 3rd-party in-memory DataSets for implementing Master/Detail relations in RTC Clients.

Best Regards,
Danijel Tkalcec