Re: [SQL] Nextval & Currval

[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.Open "Form_Store_PSQL"
    session("connection") = conn
    WriteToFile logfilepath, date & " " & time & "IF " & conn & vbcrlf , True
else
    set conn = session("connection")
    WriteToFile logfilepath, date & " " & time & "ELSE " & conn & vbcrlf , True
end if


Thank you.

Shavonne Wijesinghe