[ql-users] Archive - ALTER command

2005-05-14 Thread John Gilpin
I seem to remember, a long time ago, using the Archive ALTER command with a
list of field names so that although you have (say) all the fields of a
database visible on the monitor screen, by putting only some of them into
the list, you only ALTER those fields listed, ignoring those which are not
listed.

I now cannot find any reference to the above in any Archive book or manual
and I can't remember the syntax for the list.

Can anyone out there help me please :-) or tell me I'm mistaken in the first
case?:-(

Thanks

John Gilpin.


___
QL-Users Mailing List
http://www.q-v-d.demon.co.uk/smsqe.htm


Re: [ql-users] Archive - ALTER command

2005-05-14 Thread John Southern
On Saturday 14 May 2005 15:10, John Gilpin wrote:
 I seem to remember, a long time ago, using the Archive ALTER command with a
 list of field names so that although you have (say) all the fields of a
 database visible on the monitor screen, by putting only some of them into
 the list, you only ALTER those fields listed, ignoring those which are not
 listed.

 I now cannot find any reference to the above in any Archive book or manual
 and I can't remember the syntax for the list.

 Can anyone out there help me please :-) or tell me I'm mistaken in the
 first case?:-(

That would be the SInclair QL Manual Archive Reference section Chapter 12 
pages 41 and 42 :-)

This says:-

ALTER
Alters the current screen layout to display the current values of the 
variables.

Syntax alter

You can change the contents of any one or more fields of the current file 
whose values are shown in the screen layout. Note that it is not necessary 
for all the field variables to be shown. You can not change a field that is 
not shown. If none of the field variables appear on screen, Archive forces a 
display of the file.

First select the field to change by pressing TABULATE or ENTER until the 
cursor is at the correct filed (variables that are not fields of the file are 
skipped). You can then type a new value or use the line editor to modify the 
existing value. Press TABULATE or ENTER to move to the next field. (Pressing 
SHIFT and TABULATE together moves back to the previous filed).

When you have made all the changes you want, press F5 to replace the old 
record with the new one. The record is replaced automatically if you press 
ENTER. If the file is ordered the new version of the record is inserted in 
sequence.

John S
___
QL-Users Mailing List
http://www.q-v-d.demon.co.uk/smsqe.htm