As you suggested, setting the biz.AutoNames=False before the addField command allows this to work.
Larry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of johnf Sent: Wednesday, August 29, 2007 12:00 AM To: [email protected] Subject: [dabo-users] the SQL case statement 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 [excessive quoting removed by server] _______________________________________________ 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]
