Hi !
I need to ask for the following secuence number for a field.
I am connecting PostgreSQL with an ODBC Driver and with ADO.
If i ask for the value of the field after updating the recordset, i get it is null (and it can't be), so i read how to ask for information about sequences and i founded that "SELECT * FROM objetos_ID_seq" would be ok, but i got an error: "The Relation 'objetos_Id_seq' does not exist".
The same query works fine in cygwin interface.
What's wrong ? Is it the query or the Driver doesn't really admit this kind of queries ?
Thanks
Tamara D. Blum
Analista de Sistemas
Tel.: 4831-9061 al 66 int. 110
Sistema Argentino de Informática Jurídica
Ministerio de Justicia y Derechos Humanos