Some help please with syntax of tbl.fetch_find(). I have a file named people (with 10 entries). It consists of 2 fields. 1 field=ID, the other field=Name. I would like to display the record with the Name = "John". As simply as possible how would I find it using fetch_find?
-
-
RE: fetch_find
dim tbl_people as P
dim indx_1 as P
tbl_people = table.open("people.dbf")
indx_1 = tbl_people.index_primary_put("name")
rec = tbl_people.fetch_find("John")
assuming you have an index on the name field in the people table, index tag named "name"There can be only one. -
RE: fetch_find
You should define an index "Name" on the Name field.
When you have done that, you can use a script such as
t=table.open("people")
t.index_primary_put("Name")
frec = t.fetch_find("John")
if frec " 0 then
ui_msg_box("","No John in the table.")
end
end if
t.close()
You can simplify this slightly by using
t=table.open("people")
t.order("Name")
frec = t.fetch_find("John")
if frec " 0 then
ui_msg_box("","No John in the table.")
end
end if
t.close()
which would work even if you did not have an index on the "Name" field.
If the code is being used in a form or set based on the table (as parent in a set) you don't need table.open, you can use
t=table.current()
t.order("Name")
frec = t.fetch_find("John")
if frec " 0 then
ui_msg_box("","No John in the table.")
end
end if
topparent.resynch()
which should then show the record found in the form.
FinianFinian
Comment
-
RE: fetch_find
Finian,
SHOW OFF!!
TomComment
-
RE: fetch_find
What can I say? When you've got it, flaunt it.
I should have figured that Stan was ready with a solution too. I think between us, all that can be said about fetch_find has been said.
F.Finian
Comment
-
RE: fetch_find
Except...
"tbl".fetch_find() works the same as the
"Find By Key" sequence in the menu of every Default Form.
This can be handy to use when troubleshooting fetch_finds that aren't working as you think they should.
-- tomComment
-
RE: fetch_find
Thanks for the help. Tried the code as suggested and I still have some problems. What I intend to do is:
(1) enter a variable field "m_ID"
(2) find the record by using "m_ID" to find "ID" (table index set to "ID")
(3) display the found record.
Originally using action scripting "On Arrive" I set the index of the table to "ID". "On Depart" I selected "Find by Key", "specify a variable", variable name = "m_ID". It would not consistently give me the desired results.
I then tried the xbasic code as suggested. It finds and displays the records as desired if I depart the field using the mouse. If I depart the field via the "Enter" key or "tab" key, the next sequential record is displayed. For example if I enter "12345" and depart via mouse, record 12345 is displayed, if I enter "12345" and depart via the enter or tab key, "12346" is displayed.
Now I will return to xbasic to test the mouse vs. tab vs. enter.
Why is there a difference and how can it be corrected?Comment
Comment