Page 1 of 1
Connecting(linking) two table
Posted: Mon 29 Jan 2007 07:15
by boloyoung
Hello
How can I joint two tables using ODAC TOraTable ?
I want to make similar thing as in case BDE Masterdata/Mastefields.
When I try use Masterdata/Mastefields I don`t see ellipsis button next to the MasterFields and I Can not invoke the Field Link Designer.
Please help
Regards
Posted: Tue 30 Jan 2007 12:26
by Plash
The ellipsis button should be shown for the MasterFields property of TOraTable. We cannot reproduce the problem. Please specify full ODAC version (with build number) and Delphi version you use.
Posted: Tue 30 Jan 2007 16:32
by boloyoung
Borland C++ Builder 6 Enterprise Suit (Build10.157)
ODAC 5.80.0.39
Ora Tools Add in 2.60
Posted: Thu 01 Feb 2007 09:27
by Plash
Currently ODAC has no special editor for the MasterFields property in C++ Builder. You can define values for the MasterFields and the KeyFields properties of the TOraTable component in object inspector by typing field names manually.
We'll add the editor for the MasterFileds property in the next build of ODAC.
Posted: Thu 01 Feb 2007 16:35
by boloyoung
Thx plash for help.
However, manual defining of values does not work.
If you can please, write down how can I make it? Regards
Posted: Fri 02 Feb 2007 08:38
by Plash
You should set the MasterSource property of the detail table to a TDataSource component that is connected to the master table. Then assign master table field name(s) to the MasterFileds property of the detail table. Assign detail table corresponding field name(s) to the KeyFileds property of the detail table.