Product Documentation

FairCom RTG V3 Update Guide

Previous Topic

Next Topic

Insert Statements with Scalar Values and Subqueries Now Supported

FairCom DB SQL has been enhanced to handle mixing scalar values and a subquery in an INSERT INTO statement. A script similar to the following now succeeds:

create table source (f1 char(10));

insert into source values ('aaa');

create table dest (f1 integer, f2 char(10));

insert into dest values(1, (select f1 from source));

TOCIndex