I realize that the getLastInsertID method only returns primary key values of type integer, is there any possible work around to facilitate getting the last primary key id of a table with a primary key of type varchar?
I realize that the getLastInsertID method only returns primary key values of type integer, is there any possible work around to facilitate getting the last primary key id of a table with a primary key of type varchar?
It should not be required since you must know what is the value of primary key before inserting it when PK is a string. Could you share more details?
Thanks for the insight, that’s exactly what was done. I was using a trigger to enter the primary key seeing that is a generated UUID so i thought using a before insert trigger would automatically return the primary on an insert call on the model. This didnt work so what was done was on the beforeSave of the record, the UUID was set for the primary key.