Just for the second question:
Use the error HTML output on the specifc action (you need to display
attributes bar in the view menu) this special result will only output if an
error occur during the
execution
you can use this error HTML output to display, assign variables for
debugging, <@sql> report error etc like any other result (if possible with a
complete error free code ;)
* normally each action are processed after each other so the problem you
mention shouldn't occur
You may consider stored procedure to return the id of the inserted record
(the stored procedure make the insert and return the id: SELECT
IDENT_CURRENT('TABLENAME')+1)
Hope this help
Gauthier
----- Original Message -----
From: "Wilcox, Jamileh" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Wednesday, November 20, 2002 5:33 PM
Subject: Witango-Talk: Tango & MSSQL questions
Hi guys. We're running Tango 2000 and MSSQL 2000 on Windows 2000
Server.
1. Is there any check in Tango that confirms that a SQL insert/update
action has completed before the web app continues? I need to set up
some tafs that will be doing multiple inserts each into multiple tables
with several indexes and I'd like to be sure that all actions are
completing correctly.*
2. Is there a way to capture SQL errors in Tango (I'd like to present
more user-friendly error messages than SQL hands back)?
As always, many thanks for your time, attention and patience!
*(I remember doing one app some time back where I had problems because I
did an insert into one table, then searched for the generated ID to make
an insert to the next table; the search would fail because Tango had
started the search before the database had finished the update. But I
can't find the app and don't remember what setup we were using then.)
jamileh wilcox
Information Systems
OU Physicians
(405)271-4647 x54124
[EMAIL PROTECTED]
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
