Ben,
Does the SELECT (without the DECLARE c1 CUR) work? (works for
me both ways, but I don't have an installation of 6.5+ anymore.)
Do you have any views in your database that have variable references
in them? predefine those variables, or drop those views and try it.
Try parentheses:
DECLARE c1 CURSOR 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
Bill
On Wed, 13 Mar 2002 13:49:30 -0000, Ben Petersen wrote:
>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
================================================
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/
