Serverformulafill question

[William Conable]

On Jan 27, 2008, at 12:42 PM, James Rea wrote:

>> execute {serverformulafill Instrument Contains "voice" and «Audition
>> Date»=date("1/16/08"),flag=str(seq())}
>>
>> I get the error message "Fill formula result must be text, not
> integer."
>>
>> I thought str(seq()) was a text result. What don't I get?
>
> Yes, it is, but that is not the result of your formula. The result of
> your formula is the result of the = comparison between flag and
> str(seq()), which is going to be either 0 or -1.

OK, I understand this; I tentatively fixed it by clicking the flag  
field in advance and then just putting str(seq()) for the fill part  
of the statement, but I haven't managed to get there yet...
>
>> execute {serverformulafill Instrument Contains "voice" and «Audition
>> Date»=}+constantvalue(AudDate)+{,flag=str(seq())}
>>
>> gives me "Operand expected but not found"
>
> I think this should be
>
> execute {serverformulafill Instrument Contains "voice" and «Audition
> Date»=}+constantvalue("AudDate")+{,flag=str(seq())}

This doesn't work because AudDate is text and «Audition Date» is a  
date so you get a text/numeric type mismatch. However if I stick in  
date("AudDate") it tells me I can't use a variable in the selection  
part of the statement!

I get the same error message in this one:

execute {serverformulafill Instrument contains "voice" and «Audition  
Date»=date("1/18/08"),str(seq())}

Where is the variable in that? Does it think "voice" is a variable?  
or "1/18/08"? voice is a field value and "1/18/08" is a string  
constant! (of course it didn't make any difference when I changed  
contains to =.)
>
> When using the constantvalue( function you are specifying the NAME  
> of a
> field or variable, not the VALUE of the field or variable, so the  
> field
> or variable name needs to be quoted.

This finally makes sense to me, but so far no joy.

Thanks for hanging in with me...

Bill Conable