Thanks, Sami - Yeah, I built a similar work around with select statement, like yours better - so thanks again!
Wondering... as I've never needed to provide this info programmatically, is this List Rules For tablename a 'bug'? -Brad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Friday, March 11, 2005 9:30 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Listing sys_rules data for a specified table Brad - You could also do something like this: SELECT sys_message=50,sys_where=30 FROM sys_rules + WHERE sys_table_id = (SELECT sys_table_id FROM sys_tables + WHERE sys_table_name = 'yourtablename') Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Davidson Sent: Friday, March 11, 2005 11:14 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Listing sys_rules data for a specified table Can anyone else duplicate my findings, per below (must have more than 1 rule in DB): List Rules For tablename. I get ALL DB rules for ALL Tables... Thanks for any feedback on this. -Brad -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Brad Davidson Sent: Friday, March 11, 2005 7:52 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Listing sys_rules data for a specified table >Is there a way to see user friendly 'readable' data similar >to 'list rules' for only one table? Brad, Use "FOR" option of the LIST command. Here's how: LIST RULES FOR tablename LIST FORMS FOR tableviewname LIST REPORTS FOR tableviewname .................................... The List Rules For tablename gives me ALL table rules, not just the specified. However, List Reports/Forms/etc... for tablename returns a list specific to tablename as expected. I've tried this against Concomp, but only 1 rule on my sample database... Am I missing something here? Thanks, Brad LIST LABELS FOR tableviewname Hope that helps! Very Best R:egards, Razzak.
