Subject |
applylocate not working |
From |
Charlie <tm@tc,com> <Charlie <tm@tc,com>> |
Date |
Fri, 07 Jun 2024 10:43:35 -0400 |
Newsgroups |
dbase.getting-started |
I thought this would be easy since I have done this before but the apply locate is never found. tgrade is what i am trying to find. actually it represents a field in the table. so that isn't the problem (yet) because this never finds tid and cat which are also strings.
i have tried this looking for bith variables and only one which certainly should have been found, but for some reason the applylocate doesn't work.
Can anyone help?
function COMBOBOX4_onChange()
co = form.coins1.rowset
tgrade = trim(form.combobox4.value)
tid = trim(form.entryfield5.value)
tcat= trim(form.combobox2.value)
//co.applylocate("year= '" + tid + "'")// and category= '" + tcat + "'")
co.applylocate( "year= '" + 'tid' + "' and category= '" + tcat + "'")
form.entryfield1.value = val(co.fields["&tgrade."].value)
//if found()
msgbox( ""+found() )
|
|