acgomes2...@yahoo.com.br wrote:
> select
> A.Codigo
> 'DINHEIRO' FORMA_PAGTO
> FROM NF A
> where A.dataEmissao between '01.01.2018' and '31.01.2018'
> and A.Modelo = '55'
This should work fine if you place a comma after A.Codigo. It does
not make any sense to ORDER BY 2 (nor ORDER BY 1,2)
hi:
select
A.Codigo
'DINHEIRO' FORMA_PAGTO
FROM NF A
where A.dataEmissao between '01.01.2018' and '31.01.2018'
and A.Modelo = '55'
order by 1, 2
using, "order by 2", return a error but, if i use: cast('DINHEIRO' as
varchar(10)) FORMA_PAGTO does not ocorrur.
10.04.2018 22:16, j...@firstduews.com [firebird-support] wrote:
> I am trying to migrate my IB database to FB. When I do the backup/restore
> process It
> errors on on a table.
You cannot migrate database between Interbase and Firebird using
backup-restore. They
are different DBMS now.
I am trying to migrate my IB database to FB. When I do the backup/restore
process It errors on on a table. I have gone through for reserved keywords and
made sure that wasn't an issue. Is there any way to see why exactly it might be
erroring in the restore?
Greetings
Since yesterday i've got a "weird" error
i have a cursor and after i open it, i try to check record count and i get the
following error
"attempt to fetch past the last record in a record stream."
i've managed to overcome by validating when eof or
QProducoesActivas.CursorRowNum > 0