it is stored procedures which u will write in MSSQL ,where u can commit or
rollback all the quries when any of one codition fails
[EMAIL PROTECTED] writes:
>Lokesh - what's a PL/sql program? Thanks. j
>
>> -----Original Message-----
>> From: Lokesh Ram [mailto:[EMAIL PROTECTED]]
>> Sent: Wednesday, November 20, 2002 10:42 AM
>> To: Multiple recipients of list witango-talk
>> Subject: Re: Witango-Talk: Tango & MSSQL questions
>>
>>
>>
>> Hi,
>> if u write PL/sql program it will be much better it will
>> satisfy all your requirements for FIRST task
>> [EMAIL PROTECTED] writes:
>> >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]
>> >___________________________
>>
>>
>> "A goal is created three times. First as a mental picture. Second,
>> when written down to add clarity and dimension. And third,
>> when you take action towards its achievement."
>> Ryan Blair
>> M.lokesh ram
>> office -8142042
>> www.mobilephone.ie
>>
>>
>>
>> _____________________________________________________
>> This email and any files transmitted with it are confidential
>> and intended solely for the use of the individual or entity
>> to whom they are addressed. If you have received this email
>> in error please notify the system manager. This email has
>> been scanned for known viruses.
>>
>> ______________________________________________________________
>> __________
>> 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
>
"A goal is created three times. First as a mental picture. Second,
when written down to add clarity and dimension. And third,
when you take action towards its achievement."
Ryan Blair
M.lokesh ram
office -8142042
www.mobilephone.ie
_____________________________________________________
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This email has been scanned for known viruses.
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
