Re: [SQL] Nextval & Currval

2008-06-10 Thread Scott Marlowe
On Tue, Jun 10, 2008 at 7:14 AM, Shavonne Marietta Wijesinghe <[EMAIL PROTECTED]> wrote: > I managed to make the connection work. I tried inserting records from 2 > computers. It works fine untill 2 computers insert a nextwall one after > another. > > Here is a small example of what i see in my DB

Re: [SQL] Nextval & Currval

2008-06-10 Thread Shavonne Marietta Wijesinghe
I managed to make the connection work. I tried inserting records from 2 computers. It works fine untill 2 computers insert a nextwall one after another. Here is a small example of what i see in my DB ++|+|++ N °| Session| Number +

Re: [SQL] Nextval & Currval

2008-06-10 Thread Shavonne Marietta Wijesinghe
This is the test i did for the connection. ' Connecting to the database WriteToFile logfilepath, date & " " & time & "isobject(conn) = " & isobject(session("connection")) & vbcrlf , True if not isobject(session("connection")) then Set conn = Server.CreateObject("ADODB.Connection") conn.Op

Re: [SQL] Nextval & Currval

2008-06-10 Thread A. Kretschmer
am Tue, dem 10.06.2008, um 11:56:39 +0200 mailte Shavonne Marietta Wijesinghe folgendes: > Hello > > I'm using Nextval and Currval in my ASP programme. But everytime i run the > code > only the nextval record is inserted and the currval record is lost. I wrote > the > INSERT INTO in the log a

[SQL] Nextval & Currval

2008-06-10 Thread Shavonne Marietta Wijesinghe
Hello I'm using Nextval and Currval in my ASP programme. But everytime i run the code only the nextval record is inserted and the currval record is lost. I wrote the INSERT INTO in the log and when i tried it via pgadmin both the records were inserted correctly, so there is no syntax error. I