Search For A Record With An Empty Field

[catacrack]

Hi all,

I've got a problem with a search query.I am trying to look in a table all the records that:

- have as record owner the current user

- they have a blank value in field Payment

I think the problem comes in the second set field instruction, my code looks like this

enter find mode[]

set field[database admin;get(accountname)]

set field[payment;""]

perform find

I'm getting all the records related to my user but not only the empty ones. Any thinkings?

thanks for your help!

[MetaSys Software]

Update search criteria of payment field to

set field[payment;"="]

[catacrack]

Many Thanks for the quick reply!!

And if I want to do it in the other way? say get all the non-empty fields for that user, how could I do that?

[Breezer]

set field[payment;"*"]