Subject | Generator link not working right |
---|---|
Author | Steve Fields |
Post date | 2002-04-14T18:36:56Z |
Hi all,
D5 Ent, IBO 4.2g, IB6, XP Pro
I am using a simple master/detail setup:
Table : Shipper : ShipperID(CHAR(4)), ShipperName
Table : ShipMethod : UniqueID(integer), ShipperID(CHAR(4)),
ShipMethod, Description
Generator : G_SHIPMETHOD
TIB_Query: qryShipper
SQL = SELECT * FROM SHIPPER
TIB_Datasource: srcShipper
DataSet = qryShipper
TIB_Query: qryShipMet
SQL = SELECT * FROM SHIPMETHOD FOR UPDATE
GeneratorLink = UniqueID=G_SHIPMETHOD
MasterSource = qryShipper
MasterLink = SHIPPERID=SHIPPERID
When used it in a TIB_Grid I start typing the ShipMethod
(the ShipperID is correctly put in the field) but the
UniqueID is not filled in and it, of course, gives an
error that the id is needed when I try to go to the next row.
I was under the impression that it was also to be filled
in by the component.
The table (ShipMethod) has no triggers set, the UniqueID
is set as the primary key, with the regular constraint.
Only the generator is included in the database but is not
included in a trigger as I was going to use GeneratorLinks
in the TIB_Query definition.
Any clues?
TIA
Steve Fields
D5 Ent, IBO 4.2g, IB6, XP Pro
I am using a simple master/detail setup:
Table : Shipper : ShipperID(CHAR(4)), ShipperName
Table : ShipMethod : UniqueID(integer), ShipperID(CHAR(4)),
ShipMethod, Description
Generator : G_SHIPMETHOD
TIB_Query: qryShipper
SQL = SELECT * FROM SHIPPER
TIB_Datasource: srcShipper
DataSet = qryShipper
TIB_Query: qryShipMet
SQL = SELECT * FROM SHIPMETHOD FOR UPDATE
GeneratorLink = UniqueID=G_SHIPMETHOD
MasterSource = qryShipper
MasterLink = SHIPPERID=SHIPPERID
When used it in a TIB_Grid I start typing the ShipMethod
(the ShipperID is correctly put in the field) but the
UniqueID is not filled in and it, of course, gives an
error that the id is needed when I try to go to the next row.
I was under the impression that it was also to be filled
in by the component.
The table (ShipMethod) has no triggers set, the UniqueID
is set as the primary key, with the regular constraint.
Only the generator is included in the database but is not
included in a trigger as I was going to use GeneratorLinks
in the TIB_Query definition.
Any clues?
TIA
Steve Fields