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
