Searching across fields

[Dirk]

Hi there,

I'm back with yet another question

How can I search across the whole database and not just within the field I entered the query in? After that all matching entries should show up and not only the first one found, maybe in a list...

Any suggestions?

Greetings

Dirk

[Razumovsky]

Hi there,

This should probably be posted under the "Finding and searching" topic.

One method is to use a global field to enter your query, and then script-

enter find mode (no restore)

set field (Field1, Global)

newrecord/request

set field (Field2, Global)

newrecord/request

set field (Field3, Global)

newrecord/request...(untill all fields you want searched are set)

perform find (no restore)

go to layout(YourListLayout)

HTH

-Raz

[Lee Smith]

Or purchase FM v6 and use the new Find and Replace.

You type what you want to find and select the option all fields.

HTH

Lee

[Razumovsky]

Pretty slick. Will have to check out what new goodies are available in FM6!

-Raz

[ryanzon]

How about making a calc field containing the list of all your fields:

Example:

a calc field named c_finder contains field1 & " " & field2 &" " & field3 ...

Search through that field

[Dirk]

Lots of suggestions

I tried the search/replace function and it works so far. Since it can search all fields available in the db I need to figure out a way to get all the found record sets to be displayed somehow.

Its somewhat difficult for me to give you the appropriate names of all functions cause I'm using the german version of FM6 (wonder why the translated the script commands at all?!)

What I am using in my other found object lists ist a data field in the layout in which I put the relevant fields... works great. But here I can't place all fields in there its just too many of them.

Is there another way you can tell FM to display found datasets ? I get only the first found set.

Dirk

Sorry for being slightly OT