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
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?
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.
C
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.
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)