How can I use the indexed file in a search

[Atta]

I have designed a button, when I click on it I want it to use an index file. At this time it keeps using the normal file not the index file. So to search thru the file (750000 records) takes longer. The index files is indexed on the memo field.
This is what I am using at this point created it with the genie

'Date Created: 17-Oct-2008 07:23:33 AM
'Last Updated: 17-Oct-2008 07:23:33 AM
dim filter as c
dim order as c
dim options as c
dim description as c
dim show_all_flag as L
dim layout_name as c
dim layout_type as c
filter = "(left(Machinename,len(var->AskC_Please_give_machine_name)) = var->AskC_Please_give_machine_name ) .or. (containsi(Explanation,var->AskC_Explanation_machine_name) )"
order = "Reqkey"
options = ""
description = "Saved Query: Look for name in help"
show_all_flag = .f. 'user cannot turn off the query
layout_type = "browse" 'to open a form, set this to "form"
layout_name = "" 'This will open the default layout. You can also specify a named layout here
dim args as sql::arguments
if eval_valid("arguments") then
if typeof(arguments) = "P" then
args = arguments
end if
end if
a5_open_layout(layout_type,layout_name,"help",filter,order,description,options,show_all_flag,args)

[Stan Mathews]

Re: How can I use the indexed file in a search

I an unfamiliar with a5_open_layout() but any layout must be based on a table or set. You can't choose which "file" to attach the layout to.

If you are asking how to make your code use an index which you have created for the table upon which you layout is based, take a look at LQO.

If your filter meets the qualifications there, do you have the table indexed on Machine_name and Explanation?

[Tom Cone Jr]

Re: How can I use the indexed file in a search

Is this a web server application or a desktop application?

[Atta]

Re: How can I use the indexed file in a search

What I am trying to do is to search through all of the records on the machine name field and the explanation field. Machine name is a character field, explanation field is a memo field.

I have a browse with all of the computer names in it, I have a button on that browse. I would like to be able when I have clicked on a computer name in the browse and then click on the button that it goes thru the entire table to find that name in the machine field AND/OR the explanation field. Then a browse opens up with all of the found records.
At this point when I click on the button it asks me to enter the name of the computer that I am looking for. I want it to use the name of the computer that is clicked on. I hope this makes sense.

Thanks

[Tom Cone Jr]

Re: How can I use the indexed file in a search

You are being prompted for the machine name because you are using an "Ask" variable, "AskC_Please_give_machine_name ". Change your script so that the variable you want to use in your filter expression is populated from the machine name column in the selected row. You can do this with Action Scripting. Use the "Variables" cateogry, then choose the "Set variable(s) to object text property" action.

[Atta]

Re: How can I use the indexed file in a search

Tom can you give me a little more advice, I am all new at this scripting thing. If you could maybe tell me where I would enter/change those settings that you mention in your response

[Peter.Wayne]

Re: How can I use the indexed file in a search

You can't use an index to answer the query:

filter = "(left(Machinename,len(var->AskC_Please_give_machine_name)) = var->AskC_Please_give_machine_name ) .or. (containsi(Explanation,var->AskC_Explanation_machine_name) )"

You are asking to select any memo field that contains the machine name. An index won't help. Every record has to be searched. For example, suppose you have records like:

MachineName Explanation
George This is a very fine machine that Jorge bought.

Lisa Mary had a little lamb and also a computer.

Rodney Does anyone besides Jorge like Rodney?

The index on "explanation" will begin with the words "This", "Mary", and "Does". If you want to search for "Jorge" in the "explanation", then all the records have to be searched and each memo has to be exhaustively searched. Even if you search for "Rodney", who is indexed in the MachineName field, you still have to search every other record in the Explanation field.