select nextval. . .

Поиск
Список
Период
Сортировка
От JT Kirkpatrick
Тема select nextval. . .
Дата
Msg-id 01BEA77E.89E72F60.jt-kirkpatrick@mpsllc.com
обсуждение исходный текст
Список pgsql-sql
i am connecting to a postgres 6.4.2 database with msaccess97.  in that 
postgres database i have a sequence defined.  in access i have a form, with 
only one textbox -- when i open that form i'd like to populate that textbox 
with the next value in that sequence.  i can get the next value from psql 
(select nextval('sequencename');), but i can't seem to figure out how to 
get that nextval from within access97 into a control on a form.  i can 
design a pass-through query that inserts the nextval into a database, but 
that isn't what i want to do (it also exposes some risk of non-uniqueness 
that the sequence helps to ensure).  got any ideas??

jt


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] CASE WHEN / 6.4.2? + no doc in installed documentation
Следующее
От: "Steven M. Wheeler"
Дата:
Сообщение: Re: [SQL] Re: pgsql-sql-digest V1 #225