Get Last Record id from Insert

Idea created by monkeybreadsoftware on Feb 3, 2018
    Active
    Score19

    Hi,

     

    we insert records via plugin.

    With insert statement, a new primary key is usually generated, e.g. an UUID.

    We'd like to know that record ID after creating record.

     

    So the SQL Insert via plugin could return in result the generated primary keys.

    Or via Get(LastInsertID), we could get primary key from last record created by SQL Insert or maybe also Scripts in FileMaker.

     

     

     

    see also older questions

    Can I get last inserted record id FileMaker SQL?

    and

    last_insert_id()