Another serverformulafill question

[William Conable]

Thanks, Jeff,

Actually Jim and I had a long correspondence about this from  
1/27-1/31; the problem seems to be that when I surrounded a field  
name containing a space with chevrons, Panorama thought it was a  
variable.

I solved it by changing my field name from Audition Date to  
AuditionDate; then everything worked. And then I remembered the  
serverupdate "off" command which made it much easier and faster for  
me to do what I needed to do without even bothering with  
serverformulafill or execute.

Bill Conable

On Feb 8, 2008, at 9:02 PM, Jeff Dean wrote:

> 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
>
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080209/47ec1460/attachment-0001.html