Skip site navigation (1) Skip section navigation (2)

Can't use current_timestamp or currval functions

From: Mike Fahey <mfahey(at)enter(dot)net>
To: Postgres list <pgsql-odbc(at)postgresql(dot)org>
Subject: Can't use current_timestamp or currval functions
Date: 2004-11-10 17:03:45
Message-ID: 419249F1.9020504@enter.net (view raw or flat)
Thread:
Lists: pgsql-odbc
I can't call currval() with the odbc driver.

I'm using odbc driver version 8.0.0.2  with MS ACcess 2003.

I get the following error in access

run-time error 3085:

undefined function 'currval' in expression.

How can i make this work?

Thanks







-- 
With best regards,

Mike Fahey - Systems Administration
********************************************************************
      ENTER.NET - "The Road to the Internet Starts Here!" (tm)
  (610) 437-2221 * http://www.enter.net/ * email:support(at)enter(dot)net
********************************************************************


Responses

pgsql-odbc by date

Next:From: Mike FaheyDate: 2004-11-10 17:59:04
Subject: @@IDENTITY
Previous:From: Scot LoachDate: 2004-11-10 16:57:03
Subject: Re: 08.00.0002 useless :-)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group