Back to Function Index

RECID()

Overview

RECID() generates a unique identifier for each record in a project. This function is useful for tracking records, creating relationships between tables, and ensuring data integrity. Each call to RECID() produces a unique hexadecimal string that can be used as a record identifier.

Function Format

RECID()

Return Value

RECID() returns a character string (hexadecimal format)

Examples

RECID() = "000000660000000a"        (first record)
RECID() = "000000660000001e"        (second record)
RECID() = "0000006600000032"        (third record)
RECID() = "0000006600000046"        (fourth record)

Notes

• Important behaviors:
  • Returns a unique hexadecimal string
  • No parameters required
  • Each record gets a unique identifier
  • Identifiers are sequential
  • Format is consistent across records
  • Not available on directly connected external tables
• Common use cases include:
  • Record identification
  • Data relationships
  • Data integrity
  • Record tracking
  • Audit trails
• The function can be used in:
  • Primary keys
  • Foreign keys
  • Record references
  • Data linking
• This function is often used in combination with other functions for data management and relationship tracking.
• For other types of identifiers, consider using UUID() or other ID generation functions.

See Also

• UUID()
• GUID()
• ROWID()
• IDENTITY()