Kbase P67752: SQL-92: Cannot insert a value into a field whose datatype is "Logical"
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
SQL-92: Cannot insert a value into a field whose data type is "Logical"
Syntax error (7587)
"insert into <tablename> (<fieldname>) values (true);" is not a valid syntax
"insert into <tablename> (<fieldname>) values (yes);" is not a valid syntax
Table has been created with Data Dictionary tool
FIX:
Insert values into a logical field on a 4GL table as an integer (0=false
o, 1=true/yes) as follows:
"insert into <tablename> (<fieldname>) values (1);"
The following statement inserts a new order line on Sports database (setting value of the "backorder" to "Yes"):
"insert into pub."order-line" ("order-num","line-num", backorder) values (208,1,1); "