First of all apologies for my ignorance
foxpro dos 2.6

we have a sales orders database, it's BIG 70K records 30MB

what i want to do is display all orders from customer 12345 (there is
an index file for this)
but then to display them in the browse window in CustomerOrderNumber
order (again there is an index for this)



seek REFVAR (customer number)
if found()
GET_ORD=.t.
skip 1
if REF(field f#holding customer number) = REFVAR
do while REF = REFVAR
skip
enddo
browse window OIBROW fields SURNAME:7,REF, etc noappend key
"&REFVAR"
<<

I have messed around with SET ORDER TO without luck

do I need to create a new index combining the two fields, or is there
a better way?

Thanks

Steve

On 7 Sep 2004 07:54:26 -0700, steveh (AT) outsidein (DOT) co.uk (Steve Hayes) wrote:

Have you thought about something more simple, like:

Select * ;
from orders ;
into cursor salesorders ;
where oisref = "12345" ;
order by oiscon

The browse then should be automatic.

Alan

My real address is alan at sprint dot ca
(with a 'p' on 'alan' making it 'alanp',
and no spaces). I'm sick of email spam.

On 7 Sep 2004 07:54:26 -0700, steveh (AT) outsidein (DOT) co.uk (Steve Hayes) wrote:

Sorry, my bad. When i Responded before, I typed too fast. Selecting into a
cursor will not automatically display a browse. You have to give it the
command. Selecting without 'into cursor ' will automatically browse.

Alan

My real address is alan at sprint dot ca
(with a 'p' on 'alan' making it 'alanp',
and no spaces). I'm sick of email spam.

On 7 Sep 2004 07:54:26 -0700, steveh (AT) outsidein (DOT) co.uk (Steve Hayes) wrote:
[ Courtesy cc'ed through e-mail to the quoted author ]

Steve,
the simplest would be
SET ORDER TO oiscon
BROWSE ... FOR <cust_number>=refvar

As you have indexes on both customer order number and customer number, it will
be fast, too.
--
[ When replying, remove *'s from address ]
Alexandre Peshansky, Systems Manager, RUH, NY