i am having some trouble creating a find scrpit that will find on my balance field, a set vaule. For example

i need ti find all records with a balance greater than zero.

i have tried this several ways i just can't seem to have it enter the ">0" symbol in this field automatically.

please Help

RET

a simple script would be.

enter find mode

insert >0 in your bal due field

perform find

be sure you deselect restore find requests.

I had the same, searching for all the clients that had the field borrowed_materials >0. Here is where the <show omitted> function comes handy. You find all the values that are zero, with <show omitted> you reverse the found set to the records with the field non-zero. Your code should be something like this:

enter find mode

setfield(yourfield,0)

perform find

enter browse mode

show omitted

harryk

I can think of a couple ways of doing this. First, the easiest:

Perform your find manually (Enter find mode, go to your balance field enter the > sign and enter a zero). Then go to ScriptMaker:

Perform Find [Restore]

It will remember what your last find request was.

Another way is to go like this:

Enter Find Mode [ ]

Set field [balanceField, "">0""] (make sure the calc has the "" marks

Perform Find [ ]

Ken

Set field [balanceField, "">0""] (make sure the calc has the "" marks

This is "great!" Didn't know that was "possible!"

Harryk