Como fazer para gerar 'cast' de campos?
Data de postagem: May 18, 2010 9:13:45 PM
includeOnce -1897036629 /* /products/INTEQerp infrastructure/library/iQuery/IQuery.ijs */
IQuery.from( -2008889000 /* Títulos */ )
.column({ field: "VALOR", cast: "number", alias: "VALOR_CONVERTIDO" })
.toSql()
SQL Gerado:
select cast(TITULO20.VALOR as number) as VALOR_CONVERTIDO
from TITULO TITULO20
where (
TITULO20.CLASSE in (-2008889000,-2008888890,-2008888790,-1899998525,-1899998524,-1899998370,
-1899998369,-1899998367,-1899933806,51518,51519,35337524,35337539,35337623,35337638))