Hello
I need to sort columns (xbrowse) for a scoped dbf
Is there a way of creating temporary index ? or should i copy the records to an array and browse the array ?
Thanks for the help
Richard
Scope and temporary index
- Richard Chidiak
- Posts: 946
- Joined: Thu Oct 06, 2005 7:05 pm
- Location: France
- Contact:
- James Bott
- Posts: 4654
- Joined: Fri Nov 18, 2005 4:52 pm
- Location: San Diego, California, USA
- Contact:
Re: Scope and temporary index
Richard,
All you have to do is supply xBrowse with an array of record numbers. For details see this thread:
http://forums.fivetechsupport.com/viewt ... =3&t=19495
Regards,
James
All you have to do is supply xBrowse with an array of record numbers. For details see this thread:
http://forums.fivetechsupport.com/viewt ... =3&t=19495
Regards,
James
-
- Posts: 167
- Joined: Thu Mar 22, 2007 11:24 am
Re: Scope and temporary index
Richard
From the Ng , Index command
WHILE <lCondition> specifies another condition that must be met by
each record as it is processed. As soon as a record is encountered that
causes the condition to fail, the INDEX command terminates. If a WHILE
clause is specified, the data is processed in the controlling order.
The WHILE condition is transient (i.e., it is not stored in the file and
not used for index updates and REINDEXing purposes). The WHILE clause
creates temporary orders, but these orders are not updated.
Frank
From the Ng , Index command
WHILE <lCondition> specifies another condition that must be met by
each record as it is processed. As soon as a record is encountered that
causes the condition to fail, the INDEX command terminates. If a WHILE
clause is specified, the data is processed in the controlling order.
The WHILE condition is transient (i.e., it is not stored in the file and
not used for index updates and REINDEXing purposes). The WHILE clause
creates temporary orders, but these orders are not updated.
Frank