simon1663 Posted December 3, 2002 Share Posted December 3, 2002 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. Link to comment Share on other sites More sharing options...
Garry Claridge Posted December 3, 2002 Share Posted December 3, 2002 Try this: SELECT LAST_INSERT_ID() FROM tablename; Good Luck Garry Link to comment Share on other sites More sharing options...
simon1663 Posted December 3, 2002 Author Share Posted December 3, 2002 Hmmm... Are u sure? that seems too similar to MySQL. In fact, can u give me any reference about where u got it from? Link to comment Share on other sites More sharing options...
Garry Claridge Posted December 3, 2002 Share Posted December 3, 2002 This is what I use with PHP/mySQL. However, it may be worth trying with JDBC. All the best. Garry Link to comment Share on other sites More sharing options...
VoidState Posted January 14, 2003 Share Posted January 14, 2003 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7936 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now