Kbase P110243: How do you insert a value into a logical field in SQL-89?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/6/2005 |
|
Status: Unverified
GOAL:
How do you insert a value into a logical field in SQL-89?
FACT(s) (Environment):
Progress 9.x
FIX:
The SQL-89 interface uses TRUE, FALSE, YES and NO as the allowable values when inserting into a logical (boolean) field. See below for an example insert statement:
INSERT INTO SomeTable (Name, LogicalField) VALUES('Some Name', TRUE)