benh57

Using php + ODBC. I have a table where each record has a unique id, maintained by filemaker, and i need to know the unique id of the record i just inserted later on the page. Is there an equivalent to MySQL's LAST_INSERT_ID() using filemaker + ODBC? I couldn't find anything on their site. here's a description of LAST_INSERT_ID: http://www.mysqlfreaks.com/statements/90.php As a workaround i suppose could calculat e my own unique id, and not have filemaker do it.

As a test a while back, I successfully got around this limitation using stunnel (stunnel.org) to tunnel local ODBC queries to another machine and vice versa. All seemed to work fine. However, that may be against the eula and wouldn't be fully supported by filemaker..

I am using the raw php interface w/ ODBC+ FM8. I had serious problems / extreme slowness / bad data from FM8 ODBC until i connected to the ODBC driver using SQL_CUR_USE_ODBC as the 4th argument to odbc_connect. http://us2.php.net/odbc_connect (Similarly, my tests were fast using ODBC test apps, but slow from php.)