Re: Bug In DB-Access with IUS
Avi Abrami schrieb:
[snip]
> CREATE TABLE manager (
> mgr_name VARCHAR(30),
> department VARCHAR(12),
> direct_reports SET(VARCHAR(30) NOT NULL),
> projects LIST(ROW(pro_name VARCHAR(30),
> pro_members SET(VARCHAR(20) NOT
> NULL)) NOT NULL)
> );>
> The "insert" statement I tried was:
>
> INSERT INTO manager (
> mgr_name,
> department,
> direct_reports,
> projects)
> VALUES (
> 'Sayles','marketing',
> "SET{'Simonian','Waters','Adams','Davis','Jones'}",
> "LIST{
> ROW('voyager_project',
> SET{'Simonian','Waters','Adams','Davis'}),
> ROW('horizon_project',
> SET{'Freeman','Jacobs','Walker','Smith','Cannan'}),
> ROW('saphire_project',
> SET{'Villers','Reeves','Doyle','Strongin'})
> }"
> );[snip]
Hi Avi,
you have to double the opaque quotes inside a opaque datatype for every
level, your own example given, the following does work:
INSERT INTO manager (
mgr_name,
department,
direct_reports,
projects)
VALUES (
'Sayles','marketing',
"SET{'Simonian','Waters','Adams','Davis','Jones'}",
"LIST{
""ROW('voyager_project',
""""SET{'Simonian','Waters','Adams','Davis'}"""")"",
""ROW('horizon_project',
""""SET{'Freeman','Jacobs','Walker','Smith','Cannan'}"""")"",
""ROW('saphire_project',""""SET{'Villers','Reeves','Doyle','Strongin'}"""")""
}"
);
IMHO an awful syntax!
If you are using Sql-Editor you have to put your "list of rows of sets"
into one line additionally,
dbaccess should work without changes.
hth
martin