|Can anyone suggest a work-a-round?
==========================================
Ben,
Assuming the problem has to do with declaring a cursor on system tables, I
would try creating two temporary tables that mimic sys_columns and
sys_tables. Then use the temporary tables instead of the original system
tables.
---------------------------------------------------------------------------
Eric M. Bienstock, Ph.D.
Database Development, etc.
Authorized R:BASE Developer
Eric M. Bienstock & Associates, Inc.
day: 212-978-7948 eve: 973-763-8650(8)
FAX: 775-254-2109 [EMAIL PROTECTED]
http://mywebpages.comcast.net/ericmb/
---------------------------------------------------------------------------
----- Original Message -----
From: "Ben Petersen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 13, 2002 8:49 AM
Subject: Declare against sys tables from runtime
| 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/
