I am having an issue with @IsUnique, and I don't know where I am going wrong.  I have a "Work Order No" field named "WO_No ".  This is a text field that I am trying to see if a new entry will not flag someone that the entry could be a duplicate number.  Here is my programming.

var vwo as string
var vunique as int

vwo = WO_No
vunique = @IsUnique(WO_No, vwo)

writeln(vwo)
writeln(vunique)

If vunique = 0
{
        @MsgBox("This work order number already exits, please insure this number is correct", "", "")
}

Then I go and test the syntax, nothing comes up.  So I Preview the application.  I have a few work order numbers as "1111". "1234" and  "4321".  So I enter a new record, enter "1111" in the "WO_No" field and a writeln window pops up and says:

1111
1

A "1" keeps popping up no matter what number is already in there.    Am I doing this correctly? :'(

I added those work order numbers in preview.  Everytime I went to preview, it had those work order numbers in that field.