Recent

Author Topic: master/detail tdbf .9.8.0  (Read 6752 times)

mtdew3q

  • Guest
master/detail tdbf .9.8.0
« 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

Anonymous

  • Guest
RE: master/detail tdbf .9.8.0
« Reply #1 on: August 19, 2005, 06:20:06 am »
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

  • Full Member
  • ***
  • Posts: 234
RE: master/detail tdbf .9.8.0
« Reply #2 on: August 19, 2005, 05:49:09 pm »
I usualy just call a procedure in the Master dataset's AfterOpen,AfterPost and AfterScroll events that reconfigures the Detail DataSet.

Hope it helps !
The FRED Trainer. (Training FRED with Lazarus/FPC)

Anonymous

  • Guest
RE: master/detail tdbf .9.8.0
« Reply #3 on: August 20, 2005, 12:54:54 am »
Rudie-

that is an interesting idea.
thanks for the tip.

jim

Anonymous

  • Guest
RE: master/detail tdbf .9.8.0
« Reply #4 on: August 21, 2005, 09:13:55 am »
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

 

TinyPortal © 2005-2018