Kbase 17189: How to INSERT INTO a logical field in ESQL ( SQLBOOL )
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to INSERT INTO a logical field in ESQL ( SQLBOOL )
Here is an example of how to define an SQLBOOL field for inserting
into database field that is type 'logical':
EXEC SQL BEGIN DECLARE SECTION;
sqlbool lg = 0; /* 0= false and 1= true */
EXEC SQL END DECLARE SECTION;
EXEC SQL INSERT INTO junk (terryfld,logfld) VALUES ("newname",:lg);
EXEC SQL COMMIT WORK;
Progress Software Technical Support Note # 17189