Lazarus
Programming => Databases => Topic started by: mtdew3q on August 17, 2005, 05:06:18 am
-
Hi-
I am having trouble getting the master detail relation to work.
Here are my settings:
Datasource3: dataset dbf3
Dbf3 Tablelevel 7
tableName Status_Master.dbf
Datasource4: dataset dbf4
Dbf4 Tablelevel7
tableName Status_Detail.dbf
MasterSource: Datasource3
MasterFields: ID
IndexName: idxstatus
Here are the table structures.
MasterTable
ID L 4
Expense C 30
DetailTable
ID_AUTO +
ID L 4
Amount Float
Status C 4
ID is a primary key in master
ID_AUTO is a primary key in detail
One secondary index is named idxstatus in the detail.
It has ID specified for a field.
it is maintained but not unique.
i dropped 2 grids on the form.
one set to datasource3 and one set to datasource4.
i thought as i scrolled through datasource3 -> gridMaster
i should see changes in grid hooked up to datasource4(detail)
with these settings but nothing is happening.
i use paradox to input the settings for the dbase table like table type and restructure + index stuff. i am lucky i just happened to have a copy.
any ideas? sorry but i am stuck.
thanks,
jim
-
going once ....going twice...
i hope my question wasn't too far off base.
i'll wait until friday night to see if anyone has something to say.
if not, i will just use the sqlite component.
i havent really written any serious code yet so no harm switching if i have to.
thanks,
jim
-
I usualy just call a procedure in the Master dataset's AfterOpen,AfterPost and AfterScroll events that reconfigures the Detail DataSet.
Hope it helps !
-
Rudie-
that is an interesting idea.
thanks for the tip.
jim
-
the filterRecord event isnt working either. unless i am doing something wrong the
db stuff is definitely in progress. maybe in a half year or so i can try again.
i am still very interested in this project and will be back again.
thanks everyone,
jim