Try using the column numbers instead of the column names. I think it is like: You will have to look at the tables to see what the col #s actually are. I am doing this on the fly and have to leave here in 2 minutes.
DECLARE c1 CUR FOR SELECT + #1, #2 + > FROM sys_columns t1, sys_tables t2 + > WHERE t1.#3 = 'date' and + > t2.#5e <> 'View' AND + > t1.#1 = t2.#1 + > ORDER BY #3 Troy ===== Original Message from [EMAIL PROTECTED] at 3/13/02 6:49 am >Hi all, > >The declare below works from RBW6.1a single user and runtime, >and works under 6.5+ single user, but not under 6.5+ runtime. Can >anyone suggest a work-a-round? > >DECLARE c1 CUR FOR SELECT + > sys_column_name, sys_table_name + > FROM sys_columns t1, sys_tables t2 + > WHERE t1.sys_type_name = 'date' and + > t2.Sys_Table_Type <> 'View' AND + > t1.sys_table_id = t2.sys_table_id + > ORDER BY sys_table_name > >Thanks, > >Ben Petersen > > >================================================ >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/ ================================================ 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/
