Serverformulafill error

[Josh Davenport]

Here are the instructions from Panorama Enterprise.pdf

field PrintDate
serverformulafill «Ready» match "yes",today()
print dialog


So I created a new database.

TestServerFormulaFill

With 2 fields

Ready
PrintDate

Ready is a text field
PrintDate is a date field

I added 10 records, and in the first five records placed the text  
"Yes", without the quotes, into the field Ready

I added one procedure, named foo:

The text of the procedure is as follows:

field PrintDate
serverformulafill «Ready» match "yes",today()

I tested the procedure in single user, where it failed
I shared the database and test again, and it also failed

Error message:

Error: Fill Formula result must be Date, not Integer.

I unshared, added two more fields and reshared

field ATextField
field ANumericField

I changed procedure foo to this:

field ATextField
serverformulafill «Ready» match "yes","SomeText"
field ANumericField
serverformulafill «Ready» match "",seq()

I ran this with the database unshared, and it worked perfectly
I shared the database and ran it, and it worked perfectly

I changed the procedure to this:

field ATextField
serverformulafill «Ready» match "yes","SomeText"
field ANumericField
serverformulafill «Ready» match "",seq()
field PrintDate
serverformulafill «Ready» match "yes",today()

The first two fills worked correctly, then I got the same error as  
before.


Version 5.5 build 69204



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080328/4ef85e05/attachment.html