Omnis Mysql defined list

Doug Easterbrook doug at artsman.com
Sat Dec 17 10:30:23 EST 2016


hi Phil:

without me going to try it… do you know if you can put substitution variables in the query class

as in things like the following    (although I suspect if you could, it would have to be a variable of global scope)

 C_DATE_UPDATED at time zone [tzvar]


this is interesting stuff — and a feature I never knew about.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On Dec 16, 2016, at 3:58 PM, Phil (OmnisList) <phil at pgpotter.co.uk> wrote:
> 
> Most of what you have can be put into a query class... in the column name column, the alias is effectively the 'AS' part of a select, "(select ...) as aliasname"
> 
> There used to be a limit of, I think it was 256 chars, in the 'column name' column, which limited the case statement for example...
> I hit against that one on a few occasions, and asked for TL to extend it.
> 
> I think in the latest O$8 it is bigger, I just tried and it seems to be 5390 char long.. so maybe that is no longer an issue these days.
> 
> I get the table superclass idea though, where the code is in one place.
> 
> Interesting stuff.
> and for sure I agree, make the SQL server do most of the work, if it can.
> 
> I don't know if the time zone stuff works in a query, never tried it...
> suspect it would just work the same though
> maybe:
> Column name = F_CLIENT.C_DATE_UPDATED at time zone 'Canada/Mountain’
> Alias = C_DATE_UPDATED
> 
> Thanks for your detailed description.



More information about the omnisdev-en mailing list