Subject | TIB_Query with master link not allowing updates |
---|---|
Author | Steve Fields |
Post date | 2004-08-25T15:54:54Z |
All,
I have a problem with a query where it will not allow
updates/inserts, etc when the masterkey is defined.
In the SQL statement I use:
SELECT * FROM INVOLVE
In the KeyLinks field:
COUNTER
A generator:
COUNTER=G_INVOLVE
In the MasterLinks field:
MASTERID=MASTERID
When I set this up I am unable to get the records to
allow an insert (the set is empty). If I use the SQL
statement:
SELECT * FROM INVOLVE WHERE MASTERID = :MASTERID
it will allow edits, but I am then unable to link it
to the Master set that I need to use.
What am I missing?
IB4.3Aa, XP Pro, TIB_Query/TIB_Datasource/TIB_Connection
Thanks,
Steve Fields
I have a problem with a query where it will not allow
updates/inserts, etc when the masterkey is defined.
In the SQL statement I use:
SELECT * FROM INVOLVE
In the KeyLinks field:
COUNTER
A generator:
COUNTER=G_INVOLVE
In the MasterLinks field:
MASTERID=MASTERID
When I set this up I am unable to get the records to
allow an insert (the set is empty). If I use the SQL
statement:
SELECT * FROM INVOLVE WHERE MASTERID = :MASTERID
it will allow edits, but I am then unable to link it
to the Master set that I need to use.
What am I missing?
IB4.3Aa, XP Pro, TIB_Query/TIB_Datasource/TIB_Connection
Thanks,
Steve Fields