Subject | Trouble with TDataSetProvider, and Master-Detail TIBOQuery |
---|---|
Author | Ashley |
Post date | 2008-11-26T17:11:43Z |
Hi there
I have an app which was working fine. Is a multi-tier app written in
D5, using sockets.
On the server I have master-detail relation setup using TIBOQuery's.
The detail TIBOQuery's (a few of them) linked to the master with
TDataSource.
I then use a single TDataSetProvider which sends all this to the
client app.
On the client app, the detail cds's connect via the DataSetField.
Current app was D5, IBO version 4.2 Hj, FB1.5
Because of limitations in FB1.5, I have migrated db to FB2.1.
Now testing with IBO 4.7.16 it gives many errors when trying to apply
updates.
In all TIBOQuery I have SQL for Insert, Update and Delete.
Now it complains about needing a TableName. If I set a TableName then
it complains "Column Unknown", when there is a detail table with updates.
It is not specifically IBO 4.7 which introduces this problem, it is
any version newer than 4.2Hj
How was 4.2Hj able to properly apply updates to both master and detail
tables, but not since then?
Is the only option for me to do it manually in the BeforeUpdateRecord
event?
Thank you in advance!!
Any help or advise will be much appreciated!
Best Regards
ashley
I have an app which was working fine. Is a multi-tier app written in
D5, using sockets.
On the server I have master-detail relation setup using TIBOQuery's.
The detail TIBOQuery's (a few of them) linked to the master with
TDataSource.
I then use a single TDataSetProvider which sends all this to the
client app.
On the client app, the detail cds's connect via the DataSetField.
Current app was D5, IBO version 4.2 Hj, FB1.5
Because of limitations in FB1.5, I have migrated db to FB2.1.
Now testing with IBO 4.7.16 it gives many errors when trying to apply
updates.
In all TIBOQuery I have SQL for Insert, Update and Delete.
Now it complains about needing a TableName. If I set a TableName then
it complains "Column Unknown", when there is a detail table with updates.
It is not specifically IBO 4.7 which introduces this problem, it is
any version newer than 4.2Hj
How was 4.2Hj able to properly apply updates to both master and detail
tables, but not since then?
Is the only option for me to do it manually in the BeforeUpdateRecord
event?
Thank you in advance!!
Any help or advise will be much appreciated!
Best Regards
ashley