Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Database consistency with transaction

2 posts in Product Futures Discussion Last posting was on 2005-04-20 04:47:18.0Z
tham Posted on 2005-04-20 04:17:57.0Z
Sender: 6c4b.4265d7d0.1804289383@sybase.com
From: tham
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Database consistency with transaction
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4265d7f5.6c4d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Apr 2005 21:17:57 -0700
X-Trace: forums-1-dub 1113970677 10.22.241.41 (19 Apr 2005 21:17:57 -0700)
X-Original-Trace: 19 Apr 2005 21:17:57 -0700, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1731
Article PK: 96681

i got the problem in my projects.
the requeirmet situation is that
one i enter purchase order form , every item i purchase must
be inserted to database.
ie
Purchase no 0000223
Date 12/2/05
Items
1. soap 2 pieces
2. toothpath 5 pieces
3. washing powder 1 pieces
4. pencil 4 pieces

question ? what scheme should i apply to this situation.
one thing i know is to use transaction ,but to use
transaction, store procedure must be used.
then the problem is that how to pass all the information
like above situation to the store procedure.
anyone have any idea?


Bret Halford Posted on 2005-04-20 04:47:18.0Z
Message-ID: <4265DED4.D05109D7@sybase.com>
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Database consistency with transaction
References: <4265d7f5.6c4d.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpn-dub-129.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-129.sybase.com
Date: 19 Apr 2005 21:47:18 -0700
X-Trace: forums-1-dub 1113972438 10.22.120.129 (19 Apr 2005 21:47:18 -0700)
X-Original-Trace: 19 Apr 2005 21:47:18 -0700, vpn-dub-129.sybase.com
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1732
Article PK: 96680

Is that use of stored procedures a business requirement of your
company?
There is no general requirement to use stored procedures
in order to have transactions.

tham wrote:

> i got the problem in my projects.
> the requeirmet situation is that
> one i enter purchase order form , every item i purchase must
> be inserted to database.
> ie
> Purchase no 0000223
> Date 12/2/05
> Items
> 1. soap 2 pieces
> 2. toothpath 5 pieces
> 3. washing powder 1 pieces
> 4. pencil 4 pieces
>
> question ? what scheme should i apply to this situation.
> one thing i know is to use transaction ,but to use
> transaction, store procedure must be used.
> then the problem is that how to pass all the information
> like above situation to the store procedure.
> anyone have any idea?