Hi all,
RBW versions older than 6.5++ had some problems when accessing to system
tables (with SELECT, CHOOSE ...).
Some problems are supposed to be fixed in 6.5++
But one (at least) is still there ....
This view is used to collect columns in tables COMMANDE and LIGNE that have
a comment associated :
CREATE VIEW vtstat AS SELECT +
T1.Sys_Table_Name, +
T2.Sys_Column_Name, +
T2.Sys_Comment +
FROM Sys_Tables T1, Sys_Columns T2 +
WHERE (T1.Sys_Table_ID = T2.Sys_Table_ID) AND +
T1.Sys_Table_Name IN ('commande','ligne') AND +
T2.Sys_Comment IS NOT NULL
No problem to build the view or to read it :
SELECT all FROM vtstat
works OK
But problem to know how many records the view contains :
SELECT COUNT(*) FROM vtstat
works at R>
works also if on the last line of a CMD file,
but fail when enclosed in a CMD file if followed by any other command :
'Error - Column or variable vnumcde not found (2515)'
Example :
R>SELECT COUNT(*) FROM vtstat ; show var vINT
works OK
but
SELECT COUNT(*) FROM vtstat ; show var
don't works in a CMD file ...
Strange, is not it ???
vnumcde is a variable used to define other dynamic views, such as :
CREATE VIEW vligne (vnbligne, vmtfact) AS SELECT COUNT(numcde), SUM(mtfact)
FROM ligne +
WHERE (numcde = .vnumcde)
If I want
SELECT COUNT(*) FROM vtstat
to work, I have to define all dynamic variables used in all views prior to
this command ....
Did anybody noticed this problem before ?
Is it reported to RDCC ?
TIA and Best regards,
J.M. GRATIAS, Logimatique, France
