Re: [JDBC] [GENERAL] need help of getting PK after insertRow in JDBC

2008-09-29 Thread Gauss
Martin, Have you tried using the "RETURNING" function in your SQL insert statement to immediately return the auto-generated key value? For example, how about something like this: String insert = " INSERT INTO \"schema_name\".\"XX\" (\"BB\", \"CC\", \"DD\", \"EE\") VALUES (?, ?, ?, ?) RETUR

[GENERAL] Omnis Driver

2000-06-21 Thread gauss
Is there a way or has anybody connected an Omnis (Omnis Studio / www.omnis.net) front end to a PGSQL database. The RAD says it will connect to Oracle, sybase, Informix, DB2 and MySQL. Any suggestions? Bryon