AH! T-SQL I've used a bit. I considered triggers for some of this project (audit trail tables), but I think I'm going to go with additional Tango inserts for now. It'll be faster than to learn and build the same thing in SQL, since I'm not up to speed there yet.
Thanks for the explanation though! > -----Original Message----- > From: Ken Glover [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 21, 2002 10:38 AM > To: Multiple recipients of list witango-talk > Subject: Re: Witango-Talk: Tango & MSSQL questions > > > Actually, PL/SQL is an Oracle programming language that runs in and > Oracle database (as well as in Oracle forms and reports, > possibly other > Oracle products). > > If you want to write triggers and stored procedures/functions > in MS SQL > Server you use a language called Transact-SQL. > > Ken > > Lokesh Ram wrote: > > >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 > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
