TOraTable, Mastersource, indexfieldnames

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
h.hasenack
Posts: 48
Joined: Tue 20 Jan 2009 12:35

TOraTable, Mastersource, indexfieldnames

Post by h.hasenack » Tue 31 Mar 2009 07:24

What do I need to do with TOratable to make master/detail using mastersource work?
Here's what I do
TOratable1, tablename LUMaster (LookupID, Name)
TOraTable2, tablename LUDetails (LookupID, ID, Name)
TDatasource1, connected to LUMaster

Set IndexFieldNames of LUDetails to LookupID;ID
Set MasterFieldNames of LUDetails to LookupID
Set Mastersource of LUDetails to tDatasource1

Do I need to enter SQL for this? I was actually hoping the smart table would generate it's own master/detail parametered query.


UPDATE

:idea: Aha! Had to fill in the detailfields property. No worries: problem fixed.

Regards - Hans

Post Reply