Dotnetindex.com

Error-5132-Returned-Maintaining-81-Triggers-Using-Pre81-ADS-Clients

The Error "5132: The Specified database object name is not valid. There is no such named Trigger in the data Dictionary" (is returned when trying to maintain a trigger that has been created with Advantage version 8.1 or greater using a pre-8.1 Advantage Client (i.e. ARC).

This error is returned due to a change in the trigger architecture between Advantage Database Server 8.1 and previous versions. The following information from the README.txt file located in the Advantage 8.1 server directory will give more information as to why this error is returned. In order to maintain Advantage 8.1 or greater triggers a client of version 8.1 or greater (but not to exceed the server version) is required.

Routines that manage trigger metadata, including trigger deletion,
have been modified. If you use any of the following functions or
canned procedures, read the function/procedure specific help page
for details on identifying the trigger:
- AdsDDRemoveTrigger
- DROP TRIGGER
- sp_RenameDDObject
- AdsDDRenameObject
- AdsDDGetTriggerProperty
- TAdsDictionary.GetTriggerNames
- TAdsDictionary.GetTriggerProperty
- TAdsDictionary.RemoveTrigger
These functions and procedures will still work when used on
existing triggers in a database. If, however, new triggers are
created, or if triggers are modified (via ARC, or by dropping and
re-creating them), 5132 (object not found) errors will be returned.
The trigger name now has to be qualified with a table name. See the
function/ procedure specific help file page for details on the
qualifier format.