RTC Forums
November 24, 2024, 06:22:56 PM *
Welcome, Guest. Please login or register.

Login with username, password and session length
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: Does RtcDataSetMonitor Support the joined DB-table?  (Read 4299 times)
sunstone
RTC License++
*****
Posts: 16


« 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?

Logged
D.Tkalcec (RTC)
Administrator
*****
Posts: 1881


« Reply #1 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
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.023 seconds with 16 queries.