| 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 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 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: http://www.goldenstag.net/dbase > The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp > dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm > dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm > dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm > dBASE DOS to Windows Tutorial: > http://www.goldenstag.net/dbase/DtoWTutorial/00_Menu.htm > | |