How to make this code work?

[Zeljko]

I don't know what am I doing wrong.
I attached this code to the button 'ONCHANGE' event:
tbl=table.open("names")
tbl.index_primary_put("name")
tbl.fetch_find(var->namevar)
var->foundname=tbl.Name
tbl.close()

and it is working, but not on the way I wanted.
Well, I want as soon as I push the button (for example letter 'a') that above code to be activated so I find the first name in tbl names which begin with letter a.
I tried to put this code in a form event 'ONKEY' but it doesn't work there (for some reason).
Any suggestions? Thanks.

[dik_coleman]

Re: How to make this code work?

I don't think that 'buttons' have an OnChange Event.....

Double check, and try to be more specific about exactly what you are doing and what is being displayed.....

If you can, try to zip up a copy of the database and put it on the board so someone can help you.

D

[Peter.Greulich]

Re: How to make this code work?

Your code looks ok to me. Put it in the button's OnPush event.

[G Gabriel]

Re: How to make this code work?

Change to:
tbl=table.open("names")
tbl.index_primary_put("name")
tbl.fetch_find(left(var->namevar,1)
foundname=tbl.Name
tbl.close()

[Tom Cone Jr]

Re: How to make this code work?

If the letter 'a' is a "button" perhaps Zeljko is trying to build a progressive lookup? While calling a keystroke a button is odd perhaps there's a language barrier at work here.

Another guess would be maybe he's trying to define a multi-state button and the button happens to be labelled "a".

Hopefully he'll explain further.

[G Gabriel]

Re: How to make this code work?

Tom:

If the letter 'a' is a "button" perhaps Zeljko is trying to build a progressive lookup?

That question came to mind on first reading this thread, and I assumed that he has 28 buttons each with a letter from a to z but I dismissed it as a means for progressive lookup because tbl.fetch_find() will only bring the FIRST matching record.

I agree, further clarification is in order.

[Zeljko]

Re: How to make this code work?

Thanks for reply guys.
Actually, I've been trying to make following:
- I have names stored in a table called 'names'.
- On a form I have a field1 where I'm searching by the code number of a name and field2 where I can search by name
- The code numbers goes like 1, 2, 3, 4......
- I have attached the mentioned code on the field event 'OnChange', so when I enter 1 and press enter, in the field2 name1 appears.
I was thinking to make as soon as I press 1 that name1 appear in the field2 without pressing enter.
If I have code number(or names ID) 5 digits long, then it would be nice if I can make pointer to point to the first closest match.
Hope its clear now.
Thanks in advance for help.