Yes I thought that might work but I realized that the quotes are there to
provide a means to pass case sensitive strings. So a better solution should
be provided.
On Tuesday 28 August 2007 22:06, [EMAIL PROTECTED] wrote:
> As you suggested, setting the biz.AutoNames=False before the addField
> command allows this to work.
>
> Larry
> How can I setup a SQL case statement for a field?: Currently the autoquote
> will quote the case statement (which is wrong).
> addField("case when something=something then 'string1' else 'string2' end
> as myfield")
> --
> John Fabiani
>
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
