Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Sunday, August 14, 2022 
 
View User Profile  

 User Profile - Enrico Chiesa  
Enrico Chiesa
(SalesLogix Business Partner)
Ascent srl

fiogf49gjkf0d


Log in to send this member a message!
 


 Enrico Chiesa's Contributions
Enrico Chiesa has contributed 1 comments and 0 articles.
 
Select to view:    
Comment: SLX 6.1
fiogf49gjkf0d
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 © 2022 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 8/14/2022 10:53:44 AM