fetch auto-increment

I want to insert a row in the following table:

CREATE TABLE PATIENT (PATIN serial,PATN varchar(64) NULL);

I want to insert a patient name in the patient table with s.th. like:

insert into patient(patn) values('Doe,John')

Is there a simple way to fetch the datbase generated patin value
without doing a new database query (select patin from patient where ...)
in odbc?


--
GMX - Die Kommunikationsplattform im Internet.
http://www.gmx.net