Subject Re: applylocate not working (success)
From Charlie <tm@tc,com> <Charlie <tm@tc,com>>
Date Sat, 08 Jun 2024 10:59:31 -0400
Newsgroups dbase.getting-started

Thanks so much for everyones help.  I think the problem was having single parenthesis around tid.  Here is the solution:function

           co = form.coins1.rowset
                co.locateoptions := 3
           tgrade = trim(form.combobox4.value)
                tid = trim(form.entryfield5.value)
                tcat= trim(form.combobox2.value)
                co.applylocate( "year= '" + tid + "' and category= '" + tcat + "'")
                form.entryfield1.value = val(co.fields["&tgrade."].value)

Ken Mayer Wrote:

> On 6/7/2024 1:32 PM, Charlie wrote:
> > Hi Ken...  Thanks.  I tried that but it still is not found.  It is almost apply locate has stopped working, although it still works in other programs i've written..
> >
> > I have tried using a xdml function using locate which actually finds the row but i am having problems returning something to the form because the field for grade is selected by the user and there are 11 different fields for grade in the table.  I am not sure how to handle that.  I have tried macros, etc,   And although it seems to find the row, it doesn't seem to remember the row when I try to return it to the form.  It sees row 1 only.
> >
> > This is a mess.  Possibly there is something screwy with my computer.  I hope not.
> >
> It's probably not your computer. Break it down. Do an applyLocate one
> one part. If that works, then try another ... and so on. Work it through
> logically ... one step at a time.
> Ken
> --
> *Ken Mayer*
> Ken's dBASE Page:
> The dUFLP:
> dBASE Books:
> dBASE Tutorial:
> dBASE Web Tutorial:
> dBASE DOS to Windows Tutorial:

Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0

Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0