"SELECT FIRST 1 E.DATA, E.QTDSLDAT FROM FICHACI E WHERE E.CODPROD=" + XCODIGO ;
+ " AND E.DATA <=" + FB_DATA( XDATA ) + " ORDER BY E.DATA, E.FB CONTROL DESC"
O que tem em mx? Todos os produtos, ou somente uma seleção?

Moderador: Moderadores
"SELECT FIRST 1 E.DATA, E.QTDSLDAT FROM FICHACI E WHERE E.CODPROD=" + XCODIGO ;
+ " AND E.DATA <=" + FB_DATA( XDATA ) + " ORDER BY E.DATA, E.FB CONTROL DESC"
select
qcip, qcqtd, max( qcdatetime )
from JPCEPQTD
group by qcip
order by qcdatetime desc
WHERE CHAR_LENGTH ( Trim( historico ) ) = 0 OR historico IS NULL
str:=" select data , codproce from "+xarquivo+" where not isnull( historico ) and Length( Trim( historico ) ) = 0 ;"
Error HY000 - [ODBC Firebird Driver][Firebird]Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 68
and
str:="select data , codproce from "+xarquivo+" where trim(historico)='';"
str:=" select data , codproce from "+xarquivo+" where CHAR_LENGTH ( Trim( historico ) ) = 0 OR historico IS NULL ;"
-- considerando que o campo x seja do tipo alfanumérico
SELECT IsNull( x, 'Campo nulo' )
-- considerando que o campo x seja do tipo numérico
SELECT IsNull( x, 0 )
-- considerando que o campo x seja do tipo datetime
SELECT IsNull( x, '1900-01-01T00:00:00.000' )
-- considerando que o campo x seja do tipo alfanumérico
SELECT Coalesce( x, 'Campo nulo' )
SELECT COALESCE(NULL,NULL,1); -> retorna 1
SELECT COALESCE(NULL,NULL,NULL); -> retorna NULL
SELECT * FROM
(
SELECT DOCUM, STATUS FROM NOTAD WHERE STATUS = 1
UNION ALL
SELECT DOCUM, STATUS FROM NOTAD WHERE STATUS=2 ORDER BY DOCUM DESC LIMIT 10
) AS NOTAS
ORDER BY DOCUM
select
cnDatEmi DtEmissao, count(*) CtrcQtd, Sum(cnPeso) CtrcPeso, Sum(cnValor) CtrcValor, Sum(cnVlMerc) ValorMerc, 0 CFQtd, 0 CFValor, 0 ColetaQtd, 0 ColetaVlr, 0 ColVlMerc
into lixo
From gtconhe
group by DtEmissao
union all
select
cfDatEmi DtEmissao, 0 CtrcQtd, 0 CtrcPeso, 0 CtrcValor, 0 ValorMerc, count(*) CFQtd, Sum(CFValor) CfValor, 0 ColetaQtd, 0 ColetaVlr, 0 ColVlMerc
From gtcontr
group by DtEmissao
union all
Select
ceDatEmi DtEmissao, 0 CtrcQtd, 0 CtrcPeso, 0 CtrcValor, 0 ValorMerc, 0 CFQtd, 0 CFValor, Count(*) ColetaQtd, Sum(ceValFat) ColetaVlr, Sum(jpnftr1.ntValor) ColVlMerc
from jpordem
left join jpnftr1 on jpordem.ceNumLan = jpnftr1.ntColeta
group by DtEmissao
select * from
( select kkchave as x from jpnfekey limit 10 ) AS x1
union all
select * from
( select kkchave as x from jpnfekey limit 10 ) as x2
select * from
(
select * from
( select kkchave as x from jpnfekey limit 10 ) AS x1
union all
select * from
( select kkchave as x from jpnfekey limit 10 ) as x2
) AS x3
ORDER BY x
Usuários vendo este fórum: Nenhum usuário registrado online e 8 visitantes