GUID()
From Lianjapedia
Contents
Purpose
Function to generate and return a 36 character unique GUID
Syntax
GUID()
See Also
CURSYNCNUM(), INSERT, RECNO(), ROWNUM(), PSEUDO COLUMNS, SELECT, SYNCNUM(), UPDATE
Description
The GUID() function generates and returns a 36 character unique GUID. It can be used for Primary Keys and is unique across all locations and operating systems: Windows, Mac and Linux.
Example
create table country; (id char(36) description "ID" default guid(),; countryname char(100) description "Name",; countrycurr char(100) description "Currency",; countrycap char(100) description "Capital") create index id on country (id) insert into country (countryname, countrycurr, countrycap); values ("United Kingdom","Pound sterling","London"),; ("United States of America","United States dollar","Washington, D.C."),; ("France","Euro","Paris"),; ("Italy","Euro","Rome"),; ("Germany","Euro","Berlin"),; ("Brazil","Brazilian real","Brasilia"),; ("Thailand","Thai baht","Bangkok") select * from country