Use GUID autonumber method

Top  Previous  Next

After 2.21 version, fullrecord support GUID autonumber method.

For use this method, only active "Use GUID method" check box in Definitions 2 section of FullRecord global properties.

This options generate a GUID identity and set with this all the Audit ID fields.  To use this options, the identification fields must be type STRING(16)/CSTRING(17).

You can see an example of application and data dictionary in 3rdParty\EXAMPLES\FullRecord2\ODBC-GUID  folder.

 

When you use the GUID autonumber in your tables, add a column properties with label FRUseGUID, type boolean, and set to true for a correct recover of duplicate record.

 

Aditionally, FullRecord provides a "GenerateGUID" function to use for initialize all other fields that you need.

This procedure can imported into the app from

3rdParty\EXAMPLES\FullRecord2\ODBC-GUID\GenerateGUID.txa