jdbc insert

[simon1663]

Hi There,

Does anyone know how do I get the recordID of the record that I just inserted using jdbc ? In CDML after doing "-new" it's available in the page. But the JDBC documentation does not tell me any such thing.

Thanks.

[Garry Claridge]

Try this:

SELECT LAST_INSERT_ID() FROM tablename;

Good Luck

Garry

[simon1663]

Hmmm...

Are u sure?

that seems too similar to MySQL.

In fact, can u give me any reference about where u got it from?

[Garry Claridge]

This is what I use with PHP/mySQL. However, it may be worth trying with JDBC.

All the best.

Garry

[VoidState]

I have had this problem with ODBC and it can't be done like that with filemaker as far as I know. Something to do with cursors.

You might try: SELECT * FROM AUTOINCREMENT_FIELD IS NULL. I haven't tried it, but just happened to notice it a few minutes ago on another web page.