Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Hello!!
I am with the following problem:
I am constructing a Front-end one (I use VFP9 with CursorAdapter) for a data base SQL,
the data base is "intelligent", or either, all the processes is twirled in the data base,
not existing the processes and calculations in the Front-end one.
In one of tables where I make maintenance of data (inclusion, alteration, consultation)
is gone off in the data base one serie of updates in other tables through TRIGGER.
Example:
TABELA_PRINCIPAL goes off for TABELA_A that goes off for TABELA_B that goes off for
TABELA_C that goes off for TABELA_D that goes off for the TABELA_E. If to occur an
error in the TABELA_PRINCIPAL, without problems, I obtain to use the AERRO() to
capture the error, but, if an error of TABELA_D for TABELA_E occurs, the error
is not reported by AERROR() and the TABLEUPDATE that is given in TABELA_PRINCIPAL
returns .F. and therefore I give to a ROLLBACK
I executed a test using SQLSTRINGCONNECT() and when I execute a
UPDATE in TABELA_PRINCIPAL using SQLEXEC is returned -1 and obtains to
read the error with same AERROR() that the error occurs of
TABELA_D for TABELA_E.
Somebody already passed for this?
Exists some solution to capture error using CA?
[]s Sergio
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement