RE: Witango-Talk: a question

[Ben Johansen]

Title: Re: Witango-Talk: a question

Really, are you using Witango Trans or DB Trans? it also depends on the DB backend Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 5:35 PM To: [EMAIL PROTECTED] Subject: Re: Witango-Talk: a question   I avoid the problem by doing a begin transaction and end transaction around the getting of the ID and the insert. This locks the DB for the time it takes to complete this. -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com From: "Atrix Wolfe" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Mon, 2 Jun 2003 16:40:06 -0700 To: <[EMAIL PROTECTED]> Subject: Witango-Talk: a question   hello, weve been having a really hard to track error and i was wondering about something. We have a table w/ an integer ID that is marked as must be unique. In our code, we do this to get the next id: select max(ID)+1 from table and then in the very next action, its a DBMS using the results of that select to insert into the table. Well the error we are having is that fairly rarely, the insert DBMS will fail saying rows must be unique (and the ID is the only column marked as needing to be unique). Could this be due to the multitasking nature of witango where multiple people would hit the select code and get the same ID before it does the insert? Or does it finish one person's request completely before moving to the next request? Anyone had any problems like this before or know how to get around it? Thanks! Atrix ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf