Subject Re: ApplyLocate error
From Ken Mayer <>
Date Tue, 16 Jul 2019 22:02:25 -0700
Newsgroups dbase.getting-started

On 7/16/2019 5:23 PM, Ruth Bromer wrote:
> I have a program to create a table to be used to create a report for the
> shirt screener. (Mervyn wrote the original program with some
> modifications from me.)
> Since I have to add a few shirt orders that aren't coming from my input
> csv file, I am adding them to the input file and then resorting the
> output table (TShirtSorted.dbf).
> The original Screener.prg uses the table, Packet.dbf as input.  I want
> to use the TShirtSorted.dbf as input.  They both have the same relevant
> fields, shirt size and shirt color.  Most of the code is the same.
> The error message is:
> Database Engine Error: Operation not appicable.
> FIle:  Screener.prg
> Routine: SCREENER
> Line:   70
> Where the program crashes is with the ApplyLocate command (line 70).
> if not  t_orders1.rowset.applyLocate( "t_size = '" + cSize+ "' and
> t_color = '" + cColor +"'"  )
> The fields cSize and cColor both have valid data.

As a follow up on previous post (hit send to soon): do this IN the
program, probably before the if statement shown above, so that you can
see it with the results from your variables and so on.


*Ken Mayer*
Ken's dBASE Page:
The dUFLP:
dBASE Books:
dBASE Tutorial: