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/

Reply via email to