OK, gotcha. That makes sense, thanks!
> -----Original Message-----
> From: Lokesh Ram [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 21, 2002 3:51 AM
> To: Multiple recipients of list witango-talk
> Subject: Re: RE: Re: Witango-Talk: Tango & MSSQL questions
>
>
> 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
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
