Product Documentation

c-treeACE V10.0 Release Notes

Previous Topic

Next Topic

Improved LONG Column Support

An insert into a LONG column from a SELECT clause failed to update the value.

INSERT INTO IN_SCRIPT_TEMPTBL (SCRIPT_ID,SCRIPT_TYPE,SCRIPT_NAME,SCRIPT_DESC,SCRIPT_LANGUAGE,CREATION_USR_ID,CREATION_TIME,MOD_USR_ID,MOD_TIME,DATA)
SELECT SCRIPT_ID,SCRIPT_TYPE,SCRIPT_NAME,SCRIPT_DESC,SCRIPT_LANGUAGE,CREATION_USR_ID,CREATION_TIME,MOD_USR_ID,MOD_TIME,DATA FROM IN_SCRIPT;

LONG column handling has been reviewed, and several modifications were made to allow updates to these columns.

TOCIndex