Checksum

Table of Contents



The checksum function generates a checksum value based on the data within documents of a specified schema. It's utilized alongside the SELECT statement to produce a checksum value that represents the content of the documents within the schema, aiding in data integrity validation and comparison.


Numeric Checksum(String text)


round-pushpin Selects documents from the Word schema and calculates the checksum of the text field.
SELECT
    Text,
    Checksum(Text) as CRC
FROM
    WordList:Word
WHERE
    Text LIKE 'Cat%'




Home
The home page
SQL :: Concat
Merges or concatenates the values of text fields from documents within a specified schema.
SQL :: DateTime
Gets the local date and time with an optional format string.
SQL :: DateTimeUTC
Gets the UTC/GMT date and time with an optional format string.
SQL :: DocumentID
Returns the internal identifier for a document in a schema document page.
SQL :: DocumentPage
Returns the internal page number that contains the document in a schema.
SQL :: DocumentUID
Returns the internal unique identifier for a document in a schema.
SQL :: Guid
Generates a GUID (globally unique identifier).
SQL :: IIF
Returns one of two specified values depending on whether a given condition
SQL :: IndexOf
Gets the position of one string in another string.