TOraTable, Mastersource, indexfieldnames
Posted: 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
Aha! Had to fill in the detailfields property. No worries: problem fixed.
Regards - Hans
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
Aha! Had to fill in the detailfields property. No worries: problem fixed.Regards - Hans