From: | "Gosling, Oliver" <o(dot)gosling(at)lancaster(dot)ac(dot)uk> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | calling nextval function |
Date: | 2004-12-06 15:11:15 |
Message-ID: | 7F332A8009EE5D4CB62C87717A3498A10A3A2D9F@exchange-be1.lancs.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Does anybody know how to get the next value of a sequence?
I'm presuming that nextval is an SQL procedure in postgres which can be
called by passing the name of the sequence as a parameter. The code
below shows what I've done in VB. This does not work however - JET
throws up an error saying that 'nextval' table or query cannot be found.
Dim objCmd As New ADODB.Command
Dim objPrm As ADODB.Parameter
objCmd.ActiveConnection = CurrentProject.Connection
objCmd.CommandType = adCmdStoredProc
objCmd.CommandText = "nextval"
Set objPrm = objCmd.CreateParameter("@name", adBSTR, adParamInput, ,
"bed_id_seq")
objCmd.parameters.Append objPrm
Set sequenceNumber = objCmd.Execute
seqNum = sequenceNumber!nextval
Can anbody help me with this?
Regards,
Oliver Gosling
From | Date | Subject | |
---|---|---|---|
Next Message | Eric E | 2004-12-06 15:33:54 | Re: calling nextval function |
Previous Message | Dave Page | 2004-12-03 08:56:04 | Re: can't relink from MS access after dropping field |