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 > > >
