SQL Script Step--Where are the Results?

[transpower]

I added an auto-enter text field to a layout in an FM7 table to hold an SQL command. When left, this field automatically uses EventScript to launch a script called "SQL Test" (with the parameter being the field contents). The script has one line: Execute SQL (specified by Get(Parameter)).

The table is correctly set up in ODBC. The script runs, but nothing happens--I expected a window to popup to display the SQL results. I've used FM's SQL Query Builder to import records, but apparently this feature cannot be used to directly query an FM table. I can use MSQUERY to query any FM database (including the current one), but I'd prefer to do this internally through a text field and the script. So, what's the method?

[Tomi Saloniemi]

I'm wondering the same thing.

I need get from MySQL a value to Filemaker using SELECT LAST_INSERT_ID ().

I use ExecuteSQL with INSERT values which does the uploading to MySQL perfectly but i need to get the id number for that specific record from MySQL.

How can i get SELECT LAST_INSERT_ID () set a field value after ExecuteSQL INSERT command?