Bill,
Once again you came through. I am very unfamiliar with using the system tables so I was unsure of the syntax for the code. You seem to be able to explain it so I can understand it. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall Sent: Tuesday, June 01, 2010 2:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CHOOSE #TABLES Jim, TALLY sys_table_type FROM sys_tables and you will see that "VIEW" is one type of (virtual) table in that system table. Others are TABLE, SERVER, DBF (I think), and SYSTEM. You can add a condition for the table type. e.g. WHERE sys_table_type = 'table' to exclude all system tables and all views. Bill On Tue, Jun 1, 2010 at 3:07 PM, Jim Belisle <[email protected]> wrote: 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
