Searches

I’m pretty sure that you have to start at the beginning of the index in your find options.

long time since I’ve used DML … but if you didn’t find the first record using index with search.. you get where ever it was in the index…

and thats because there is a NEXT using the index.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug@artsman.com
www.artsman.com
Phone (403) 650-1978

see you at the third annual users conference
tickets.proctors.org/TheatreManager/95/online?performance=29086 <tickets.proctors.org/TheatreManager/95/online?performance=29086>

> On Jan 25, 2018, at 9:06 AM, Martin Luce via omnisdev-en <omnisdev-en@lists.omnis-dev.com> wrote:
>
> Hi
>
> Just wondered if I am the only person with this problem. I have been doing some heavy recalculations which take several minutes on a new 27 ins Mac running 10.13.2 using 8.1.3
>
> I am finding that many ‘finds’ in the part of the method below are missed which has taken a lot of sorting out. I have just rerun the method and of 33566 ‘finds’, 15332 were missed the first time but found on the second. The method which is recalculating a large number of records, includes
>
> Calculate L_Searches as L_Searches+1
> Set search as calculation {(F_StockPriceShort.SPS_StkNum=L_StkNum)&(F_StockPriceShort.SPS_Date>=Mem.M_DateSt)}
> Set main file {F_StockPriceShort}
> Find on F_StockPriceShort.SPS_StkNum (Use search)
> If flag false
> Calculate L_Searches2 as L_Searches2+1
> Set search as calculation {(F_StockPriceShort.SPS_StkNum=L_StkNum)&(F_StockPriceShort.SPS_Date>=Mem.M_DateSt)}
> Set main file {F_StockPriceShort}
> Find on F_StockPriceShort.SPS_StkNum (Use search)
> End If
> If flag false
> Calculate L_Searches3 as L_Searches3+1
> Set search as calculation {(F_StockPriceShort.SPS_StkNum=L_StkNum)}
> Find last (Use search)
> End If
> If flag false
> Breakpoint
> Else
>
> The breakpoint is not reached. It almost seems as if the machine is going too fast for itself or am I doing something wrong?
>
> Interestingly I can get the same problem when I have just made a pdf file of an invoice and immediately want to attach it to an email. I have to ReadBinFile twice sometimes to pick it up
>
> Martin
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com