[RBASE-L] - up and down arrow movement

[jbainc]

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.

emmitt.d...@everpack.com

(203) 214-5683 m

(203) 643-8022 o

(203) 643-8086 f

emmitt.w.d...@comcast.net

 

From: rbase-l@rbase.com [mailto:rbas...@rbase.com] 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 <le...@sbcglobal.net>
To: rbase-l@rbase.com (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?
--
 

J Blaustein
12 Herrick Drive
Lawrence, NY 11559-1420
516-371-3445