Re: Witango-Talk: Tango & MSSQL questions

[Ken Glover]

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