Re: Can't use current_timestamp or currval functions

Поиск
Список
Период
Сортировка
От Jeff Eckermann
Тема Re: Can't use current_timestamp or currval functions
Дата
Msg-id 20041110191558.70665.qmail@web20828.mail.yahoo.com
обсуждение исходный текст
Ответ на Can't use current_timestamp or currval functions  (Mike Fahey <mfahey@enter.net>)
Список pgsql-odbc
--- Mike Fahey <mfahey@enter.net> wrote:

> 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?

You will need to use a pass-through query, if you want
to use Postgresql syntax, functions, operators etc.
Otherwise, Access assumes that you are attempting to
use an Access function etc.

>
> 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@enter.net
>
********************************************************************
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>




__________________________________
Do you Yahoo!?
Check out the new Yahoo! Front Page.
www.yahoo.com



В списке pgsql-odbc по дате отправления:

Предыдущее
От: Gary Doades
Дата:
Сообщение: Re: ODBC Driver stability
Следующее
От: Jaime Casanova
Дата:
Сообщение: Re: ODBC Driver stability