Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter
Message
From
21/09/2005 14:54:40
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
CursorAdapter
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
MS SQL Server
Miscellaneous
Thread ID:
01051743
Message ID:
01051743
Views:
43
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
Map
View

Click here to load this message in the networking platform