Subject | Why RDB$DB_KEY? |
---|---|
Author | Steve Fields |
Post date | 2001-08-06T14:18:45Z |
Hi All,
With a simple table: Counter=Integer, LastName=VARCHAR(30), etc.
as OVERTIME.
I have the primary key on COUNTER, a generator. In the program I
have a TIB_Query with SELECT * FROM OVERTIME FOR UPDATE, KEYLINKS:
COUNTER=COUNTER, MASTERLINKS:COUNTER=G_OTCOUNTER, the default
ordering text (built by right-clicking), and the default SQL text
generated with the default settings:Prepared Edit, Search Delete,
Searched Edits.
When I select the Generate For Table I get the three SQL texts
but in the Edit SQL I get the normal setup but at the bottom I
get WHERE RDB$DB_KEY = :DB_KEY
From this point on I get errors of _Invalid Custom DML Column
Reference RDB$DB_KEY.
How do you fix this when it is the default?
Thanks,
Steve Fields
With a simple table: Counter=Integer, LastName=VARCHAR(30), etc.
as OVERTIME.
I have the primary key on COUNTER, a generator. In the program I
have a TIB_Query with SELECT * FROM OVERTIME FOR UPDATE, KEYLINKS:
COUNTER=COUNTER, MASTERLINKS:COUNTER=G_OTCOUNTER, the default
ordering text (built by right-clicking), and the default SQL text
generated with the default settings:Prepared Edit, Search Delete,
Searched Edits.
When I select the Generate For Table I get the three SQL texts
but in the Edit SQL I get the normal setup but at the bottom I
get WHERE RDB$DB_KEY = :DB_KEY
From this point on I get errors of _Invalid Custom DML Column
Reference RDB$DB_KEY.
How do you fix this when it is the default?
Thanks,
Steve Fields