>Hi,
>
>>>That removes the former and then rewrites it. Try doing that and see the size of your cdx get smaller?
>
>I'll try something on Monday or Tuesday evening.
>
>That "second" is just what we get from using a seek. Do you do some like :
>
>Open view with no data.
>
>set the variable to mycustno
>
>requery()
>
>And it reurns in a second?????
>
>John
My lv_cust returns 1 customer in less than a second.
CREATE SQL VIEW "LV_CUST" ;
AS SELECT * FROM f:\pro30\ardata\arcust01 ;
where arcust01.custno= ?vp_custno
This will give me some editing data on a page 2 in a page form. Page 1 has just the Cust # and Company fields in a grid view name lv_cust_brow.
Page2 Activate code:
vp_custno = v_cust_brow.custno
if ! USED('V_CUST')
use lv_cust in 0 alias v_cust nodata
endif
sele v_cust
requery()
I have around 3,000 customers in arcust01
If I copy that file into itself a bunch of times and I now have 68,640 customers. All custno's have been re-# 'ed 1 to 68640
The above code is not really changing the speed. Still less than one second. If your speed is greater, than you have to check your indexes.