Subject Re: applylocate not working (success)
From Mervyn Bick <invalid@invalid.invalid>
Date Sat, 8 Jun 2024 17:43:54 +0200
Newsgroups dbase.getting-started

On 2024/06/08 16:59, Charlie wrote:
> Thanks so much for everyones help.  I think the problem was having single parenthesis around tid.  Here is the solution:function
>   COMBOBOX4_onChange()
>            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)
>                 return

One of our local TV channels is rerunning a 30yr old series called "The
A Team".  (They're too broke to buy new material but how that came about
is material for a whole new series in it's own right. :-) )  The main
character's favourite saying is "I love it when a plan comes together."
That seems to be appropriate now.

As it stands, if a record isn't found, the value for the last record in
the table will be shown in entryfield with no indication that this isn't
from the correct record. It is perhaps a good idea to let the user (you
:-) ) know that the search was not successful.

    co = form.coins1.rowset
    co.locateoptions := 3
    tgrade = trim(form.combobox4.value)
    tid = trim(form.entryfield5.value)
    tcat= trim(form.combobox2.value)
    bFound = co.applylocate( "year= '" + tid + "' and category= '" +
tcat + "'")
    if bFOund = true
       form.entryfield1.value = val(co.fields["&tgrade."].value)
       form.entryfield1.value  = ''
       //make the entryfield blank other wise it will show
       //the value for the last record
       mssgbox('Record for year '+tid+ ' and category '+tcat+' not


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