SELECT * FROM PATDATA leads to the following error message
>[Error] Script lines: 1-2 --------------------------
Can't parse index expression UPPER(BLOCK_CAT+SNAME+GNAME+INT)
|
That issue is resulted by int column, because int is a reserved word in sql. Now the sql engine supports using DATE, TIME, TIMESTAMP, GROUP, ORDER, KEY, DESC, SEQUENCE, INCREMENT, MINVALUE, MAXVALUE, CACHE, CHECK, CYCLE, OTHER, SET, INT, and UPDATE directly in SQL, although they're reserved words too. Please download the latest package.
|
Main
webmaster@hxtt.com