General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only