At 01:49 PM 3/13/2002 +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
Ben,
I tried the following sample code using The Glorious R:BASE 2000
(ver 6.5++) for Windows Runtime, Build:1.851xRT03 and there is
absolutely NO PROBLEM!
-- 6.5++ for Windows Runtime Test
CLS
SHOW VERSION
PAUSE FOR 2
CLS
CONN CONCOMP
SET VAR vMonth INTEGER = 2
SET ERROR MESSAGES 705 OFF
DROP CURSOR c1
CLS
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
CLS
PAUSE FOR 2
EXIT
Very Best Regards,
Razzak.
================================================
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/
