Another serverformulafill question

[Jeff Dean]

Hi Bill,

I don't know if you got an answer already.
I think the variable AudDate needs to be surrounded by chevrons.

 From the reference:
SELECTFORMULA - Selection formula (any variables must be surrounded by  
« and »)

FILLFORMULA - Fill formula (any variables must be surrounded by « and »)

Jeff
On Jan 26, 2008, at 10:03 PM, William Conable wrote:

> This version
>
> execute {serverformulafill Instrument Contains "voice" and «Audition
> Date»=}+constantvalue(AudDate)+{,flag=str(seq())}
>
> gives me "Operand expected but not found" (before even getting to the
> Fill formula part which I asked about in my previous query).
>
> So does this:
> execute {serverformulafill Instrument Contains "voice" and «Audition
> Date»=date(}+constantvalue(AudDate)+{),flag=str(seq())}
>
> and this version
>
> execute {serverformulafill Instrument Contains "voice" and («Audition
> Date»)=}+constantvalue(date(AudDate))+{,flag=str(seq())}
>
> gives me "Numeric argument used when text was expected". Well, I
> figured that out
> : I was intending + as a concatenate sign but since date gives a
> number, that doesn't make sense. But then the previous version should
> work because AudDate is a text variable. What Operand is missing?
> I tried surrounding the selection criteria with (), putting the )
> between the "{"and the "," in the second half of the execute formula,
> but that didn't make any difference.
>
> (The field «Audition Date» is a date field, the variable AudDate is
> text. Outside of an execute statement, «Audition Date»=date(AudDate)--
> e.g. Select «Audition Date»=date(AudDate)--gives me the result I
> expect.)
>
> Thanks,
>
> Bill Conable
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna