master/detail tdbf .9.8.0
lazarus / 16-Databases

----------------------------------------------------------------------
mtdew3q · 2005-08-17 03:06

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

----------------------------------------------------------------------
Anonymous · 2005-08-19 04:20

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

----------------------------------------------------------------------
RudieD · 2005-08-19 15:49

I usualy just call a procedure in the Master dataset's
AfterOpen,AfterPost and AfterScroll events that reconfigures the
Detail DataSet.

Hope it helps !

----------------------------------------------------------------------
Anonymous · 2005-08-19 22:54

Rudie-

that is an interesting idea.
thanks for the tip.

jim

----------------------------------------------------------------------
Anonymous · 2005-08-21 07:13

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