RTC Forums

Subscription => Support => Topic started by: sunstone on July 22, 2012, 02:55:13 PM



Title: Does RtcDataSetMonitor Support the joined DB-table?
Post by: sunstone on July 22, 2012, 02:55:13 PM
Does RtcDataSetMonitor Support the joined DB-table?

if clientdataset include the dataset like the SQL {
select pi.pi_id,pi.pi_name,pi.pg_id,pi.pi_code,pi.pi_barcode,pi.pi_standard,pi.pi_package,pi.pi_unit,pi.pi_price,pi.pi_supplyterm,pi.pi_picture, pi.pi_note,pg.pg_name from product_information pi join product_groups pg on pi.pg_id = pg.pg_id where ci_id = '%s'}

RtcDataSetMonitor can Monitor the clientdataset ? I has try it ,but error was taken place in call(xxx).
Your demo of RtcDataSetMonitor only support olny one table?



Title: Re: Does RtcDataSetMonitor Support the joined DB-table?
Post by: D.Tkalcec (RTC) on July 22, 2012, 04:25:33 PM
TRtcDataSetMonitor component does not support monitoring datasets containing nested dataset fields. For working with related datasets, you can use Master/Detail relations. For examples on using datasets in a master/detail relation, please check the "MasterDetailClient" and "MasterDetailClient2" Projects from the Demos/DB_Access folder.

One TRtcDataSetMonitor can monitor changes made to one table. It can not monitor changes made to multiple tables, nor can it monitor changes made to tables embedded inside fields of other tables (nested datasets). In other words, for a TRtcDataSetMonitor to be able to monitor changes to a dataset so they can be applied to the database on the Server, the data containing in that dataset has to be "flat" (X Fields * Y Rows).

Best Regards,
Danijel Tkalcec