Place this in your form ON BEFORE START eep SET KEYMAP [PGUP] = [F7] SET KEYMAP [PGDN] = [F8] SET KEYMAP [UP] = [F7] SET KEYMAP [DOWN] = [F8] SET KEYMAP [F9] = [F10]
In you ON CLOSE eep SET KEYMAP ALL OFF Jan -----Original Message----- From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: Tue, 19 Oct 2010 15:51:19 -0400 (GMT-04:00) Subject: [RBASE-L] - up and down arrow movement is there a setting switch to allow the operator to either go up or down - at the end of the list the down arrow will take you to the first item on the list or when on the first item, the up arrow will take you to the last item? thank for you help j -----Original Message----- From: Emmitt Dove Sent: Oct 19, 2010 3:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Changing a column width in many tables ALTER TABLE Table2 ALTER COLUMN CompName2 TO CompanyName TEXT (50) NOCHECK Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Tuesday, October 19, 2010 15:23 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Changing a column width in many tables Les, Assume you wish you change the column CompanyName from 40 to 50 and it exists in 4 tables. RENAME CompanyName TO CompName2 IN Table2 NOCHECK RENAME CompanyName TO CompName3 IN Table3 NOCHECK RENAME CompanyName TO CompName4 IN Table4 NOCHECK ALTER TABLE Table1 ALTER CompanyName TEXT 50 NOCHECK ALTER TABLE Table2 ALTER CompName2 TEXT 50 NOCHECK ALTER TABLE Table3 ALTER CompName3 TEXT 50 NOCHECK ALTER TABLE Table4 ALTER CompName4 TEXT 50 NOCHECK RENAME CompName2 TO CompanyName IN Table2 NOCHECK RENAME CompName3 TO CompanyName IN Table3 NOCHECK RENAME CompName4 TO CompanyName IN Table4 NOCHECK I think there is a way to combine the ALTER and NAME at the same time but can't think of the syntax. Hope this helps. Jan -----Original Message----- From: Les Stark <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 19 Oct 2010 14:02:13 -0500 Subject: [RBASE-L] - Changing a column width in many tables Is there a simple way to change the width of a column that appears in many tables without renaming each column in each table? Perhaps using the sys tables? --
