Advantage Developer Zone

 
 
 

Advantage Knowledgebase Item




Ref No:
101011-2369
Last Modified:
Tuesday, October 12, 2010
Product:
Advantage Database Server ( General )
Category:
Compatibility
Title:
Trigger on DBF Fail to Fire if Table Opened As Free Table
Problem Description:
A DBF has been added to an Advantage Data Dictionary.
A trigger has been defined on the DBF.
If the DBF is opened first as a Free Table (and left open) then the trigger will fail to fire even if the table is opened later via the Data Dictionary.
Solution:
This is expected behavior.
Ensure that the table has been opened through the Advantage Data Dictionary first in order for the trigger to fire.
However, please also note that as of 8.10.0.26 the trigger will never fire on a free connection, only on updates to the table via the Dictionary connection.
Was This Item Helpful?