Sorry if this is an old question.

If I only have the file name, how can I get the last inserted
record's primary key which is using generator in a trigger.

I currently read the system table to get the primary key name. Then
use max() to get the value. But I think this is not good on a
multi-user system.

Any suggestion is welcome.

Regards,

Almond Wong