Jump to content

Find in multiple fields


This topic is 6513 days old. Please don't post here. Open a new topic instead.

Recommended Posts

This is driving me crazy.

I have a database with record with three fields : veld1; veld2 and veld3 (yes indeed i am dutch)

Now i want to perform a find script that finds records with

veld1 contains text to find

veld2 contains zero or more characters

veld3 contains nothing

How should i define the necessary fields steps

specifically how to set the field veld3 to nothing ?

Thanks

Jitse Schaafsma

Link to comment
Share on other sites

Use the following script

Find

Enter Find Mode

Set Field [ vel1 , "your text" ]

New Record/Request

Insert Calculated Result [ veld3 , "*" ]

Omit Record

Perform Find

Since veld 2 can be anything don't include it the find.

Link to comment
Share on other sites

Okay, i admit, i feel like an idot,

i can not get it two work.

Again, an example

this is my date

record number veld1 veld2 veld3

1 A

2 A A

3 A A A

4 AA A A

could someone please show me the script steps i need

to find only record number 1.

(*in brwoser/find mode i have know problem *)

I am very gratefull

Jitse

Link to comment
Share on other sites

There's a typo in Ralph's script: Insert Calculated Result [ veld3 , "*" ]

Should be: Insert Calculated Result [ veld3 , "=" ]

In Find mode, =Something searches for an exact match. = alone searches for empty fields. * alone is the opposite of = alone: it searches for any none-empty field.

Does this work now?

Link to comment
Share on other sites

This topic is 6513 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.