View User Profile

Comment: SLX 6.1
Remember that in SLX 6.1 they use the view OA_TABLES to list the tables, so if you modify this view adding

when 'VIEW' THEN 'TABLE'

all work rights.

-Enrico
Here the complete alter view.

ALTER VIEW OA_TABLES AS
select CAST(TABLE_CATALOG as VARCHAR) TABLE_QUALIFIER, CAST( TABLE_SCHEMA as varchar) TABLE_OWNER, CAST( TABLE_NAME as VARCHAR) TABLE_NAME,
case TABLE_TYPE
when 'BASE TABLE' THEN 'TABLE'
when 'VIEW' THEN 'TABLE'
else TABLE_TYPE
end TABLE_TYPE
, '' TABLE_STRUCT,
'' TABLE_PATH, '' OA_USERDATA, '' OA_SUPPORT, '' REMARKS
from INFORMATION_SCHEMA.TABLES

Author: Enrico Chiesa - 7/28/2003

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 4/25/2024 6:30:14 PM