const SQLComp: array [0..20] of TSQLCompInfo = ((Token: 'GEN_ID'; Comp: '"<generator>,", "<step>"'), (Token: 'CAST'; Comp: '"<value> AS <datatype>"'), (Token: 'DECIMAL'; Comp: '"<precision>,", "<scale>"'), (Token: 'NUMERIC'; Comp: '"<precision>,", "<scale>"'), (Token: 'CHAR'; Comp: '"<count>"'), (Token: 'VARCHAR'; Comp: '"<count>"'), (Token: 'CSTRING'; Comp: '"<count>"'), (Token: 'AVG'; Comp: '"[ALL] <value>"'#13'"DISTINCT <value>"'), (Token: 'MAX'; Comp: '"[ALL] <value>"'#13'"DISTINCT <value>"'), (Token: 'MIN'; Comp: '"[ALL] <value>"'#13'"DISTINCT <value>"'), (Token: 'SUM'; Comp: '"[ALL] <value>"'#13'"DISTINCT <value>"'), (Token: 'COUNT'; Comp: '"*"'#13'"[ALL] <value>"'#13'"DISTINCT <value>"'), (Token: 'UPPER'; Comp: '"<string expr>"'), (Token: 'LOWER'; Comp: '"<string expr>"'), (Token: 'BIT_LENGTH'; Comp: '"<string expr>"'), (Token: 'OCTET_LENGTH'; Comp: '"<string expr>"'), (Token: 'CHARACTER_LENGTH'; Comp: '"<string expr>"'), (Token: 'CHAR_LENGTH'; Comp: '"<string expr>"'), (Token: 'TRIM'; comp: '"<left paren> [[LEADING | TRAILING | BOTH] [<trim char>] FROM]"'#13 + '"<value expr> <right paren> <trim spec> ::= <trim char> ::= <value expr>"'), (Token: 'EXTRACT'; Comp: '"part FROM value"'), (Token: 'SUBSTRING'; Comp: '"<string expr> FROM <pos> [FOR <length>]"')); |