Page 1 of 1

Master/Detail where the Master-ID is an String

Posted: 13.07.2007, 14:21
by derSegler
I have a problem with Master/Detail

Zeos 6.6.2-beta, Delphi7, Access-DB

These are my tables:

Master
ID : String(10)
Spalte1 : String
Spalte2 : String

Detail
ID : String(10)
detail1 : String

zQuery1.SQL='select ID from Master'
DataSource1.dataSet=zQuery1
zQuery2.SQL='select * from Detail where ID=:ID'
zQuery2.MasterSource=DataSource1
zQuery2.MasterFields=ID

if I set active = true I get the Error "Die Argumente sind vom falschen Typ, liegen außerhalb des Gültigkeitsbereiches oder sind miteinander unvereinbar"

If I set the zQueryDetail.Params[0] DataType from ftUnknown to ftString, no Error, BUT:: there no Data!!

I have build these construct with ADO from delphi7, it run's without any problems

So, what is the Problem??

Thanks for help.

Posted: 15.07.2007, 13:44
by kmr
I think you need the fields of at least the master-dataset in the corresponding field editor (right click on the dataset (query or table) and chose field editor,
right click in the field editor an chose add all fields)
should work

btw. Moin Moin von der Ostsee!