Bill got me almost to where I want to be. When using your code, Bill, can I exclude my views from the choose command?
What I am trying to accomplish is this; I create tables that duplicate our present products, make minor changes that make a new product. Most of the time I immediately insert this new product into another table. Sometime however my changes are more in detail and I have to hold off. That is when I want to choose from certain tables (but not views). Your code, Bill, works but I want to keep the views out of the choices so the user (or myself) does not accidentally choose them. Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Tuesday, June 01, 2010 2:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHOOSE #TABLES You want to choose from the system tables or exclude them? Choose From CHOOSE vcho FROM #VALUES FOR sys_table_name FROM sys_tables WHERE (SGET(sys_table_name,3,1)) = 'sys' ORDER BY sys_table_name Exclude From CHOOSE vcho FROM #VALUES FOR sys_table_name FROM sys_tables WHERE (SGET(sys_table_name,3,1)) <> 'sys' ORDER BY sys_table_name ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, June 01, 2010 2:29 PM Subject: [RBASE-L] - CHOOSE #TABLES I AM ABLE TO BRING UP THE LIST OF TABLES WITH THE CHOOSE COMMAND WITH NO PROBLEM. CHOOSE vTbledit FROM #TABLES LINES 40 FORMATTED I am not familiar with how to use the system tables so I how do I limit the choice to tables that begin with specific letters? Jim
