Sometimes, your computer may display an error code indicating the 42×01 error. There are many reasons that can cause this problem.
Approved: Fortect
The following query results in an error like ERROR 42X01: Syntax error: "KEY" at line 1, column 48
I am not sure exactly what is most important. The available column is KEY and then the data type is integer .
Paste in UOM_TYPE(UNITS_OF_MEASURE_NO, TYPE, KEY, CREATED_BY, CREATED_DATE, MODIFIED_BY, MODIFIED_DATE, VERSION)meaning(79, 'Clinical Properties', 32, 'JRL', DATE ('2007-05-04'), 'JRL', DATE ('2007-05-04'), 2);
requested Jan 9, 15 @ 6:38 am
65
Not The Answer You Are Looking For? Browse Other Questions Tagged SQL Derby And / Or Maybe Ask Your Own Question.
KEY is a keyword in db derby. You must escape, remember:
Paste in UOM_TYPE(UNITS_OF_MEASURE_NO, TYPE, "KEY", CREATED_BY, CREATED_DATE, MODIFIED_BY, MODIFIED_DATE, VERSION)meaning(79, 'Clinical Properties', 32, 'JRL', DATE ('2007-05-04'), 'JRL', DATE ('2007-05-04'), 2);
Approved: Fortect
Fortect is the world's most popular and effective PC repair tool. It is trusted by millions of people to keep their systems running fast, smooth, and error-free. With its simple user interface and powerful scanning engine, Fortect quickly finds and fixes a broad range of Windows problems - from system instability and security issues to memory management and performance bottlenecks.
Resolved on January 9 and 15 at 06:53.
61.3K
Speed up your computer's performance now with this simple download.
