In previous post please make the following change in ORDER
BY clause:
ORDER BY T2.SYS_TABLE_NAME ASC, SYS_COLUMN_ID ASC
Sorry about that. I did a cut and paste from experimental
work and missed the problem with the order by clause.
--
Jim Bentley
American Celiac Society
[EMAIL PROTECTED] - email
(973) 325-8837 voice
(973) 669-8808 Fax
---- "James (Jim) Bentley" <[EMAIL PROTECTED]> wrote:
> Larry and the List,
> Please excuese tardy reply. Larry you state "The reason,
> I assume, is that the columns in
> > the views never get added to R:Base's internal column
> > list (what we see exposed as SYS_COLUMNS) and
> > therefore the checking never occurs. The columns are
> > generated on-the-fly when you use the view."
>
> I respectfully disagree. Try the following code.
>
> BROWSE SYS_COLUMN_ID=6,SYS_COLUMN_NAME=18, +
> (SYS_TYPE_NAME & (IFEQ (T1.SYS_DATA_TYPE,3,('('+ +
> CTXT(T1.SYS_LENGTH)+')'), (IFEQ(T1.SYS_DATA_TYPE,9,('('+
> +
> CTXT(T1.SYS_LENGTH)+','+ CTXT(T1.SYS_SCALE)+')'),(IFEQ(T1.SYS_DATA_TYPE,12,+
> ('('+ CTXT(T1.SYS_LENGTH)+')'),' ')))))))=12,SYS_TABLE_ID=6,+
> SYS_TABLE_NAME, SYS_PRECISION=5, SYS_LENGTH=4 FROM SYS_COLUMNS
> T1 RIGHT +
> OUTER JOIN SYS_TABLES T2 ON T2.SYS_TABLE_ID = T1.SYS_TABLE_ID
> +
> WHERE T2.SYS_TABLE_TYPE='VIEW' +
> ORDER BY T2.SYS_TABLE_NAME ASC, SYS_COLUMN_ID DESC
> --
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
