I would like to inquire about best practices for getting the row ID of the last inserted Row.
Currently our team is using a GUID field in nearly every table where our program needs to receive the Row ID after insertion. Every other commercial database I have worked with allows for some iteration of
which will return the value of the auto incremented ID field. Is there any support for this type of command with the 4D SQL Engine? If not are we currently using the best practice to get the row ID after insertion?
Any advice would be much appreciated!
OS : Windows
Product :4D - 4D Server