Hi,
I'm trying to debug a concurrency issue I'm having with an application
of mine, connecting to Firebird 2.5.6, so I'm trying to understand the
various monitor tables. I have dozens of threads all making their own
connections to Firebird (superserver).
After running for a while my
>> It is my First question in this group.
>>
>> I would like to know if someone has accomplished a migration from
>>
>> Interbase 7.5 to Firebird 2.5.4
I did it years ago.
1. Extract metadata from Interbase
2. Create the database in firebird with the metadata extracted. You may have to
Hi,
We did it several times for our clients.
Not very difficult, but requires to detect and rewrite wrong SQL queries.
Regards,
Alexey Kovyazin
IBSurgeon
Hi ,
It is my First question in this group.
I would like to know if someone has accomplished a migration from
Interbase 7.5 to Firebird
Hi ,
It is my First question in this group. I would like to know if someone has
accomplished a migration from
Interbase 7.5 to Firebird 2.5.4
Olag,
> Before
> Record 1 prio 3
> Record 2 prio 10
> Record 3 prio 18
> Record 4 prio 20
> Record 5 prio 30
>
> The user set the record 4 to prio 15, I would like to do this:
>
> Record 1 from 3 to 10
> Record 2 from 10 to 20
> Record 3 from 20 (should 15, Destination between record 2 and
Hello @ll,
in a table there a many records with prioritys 1, 4, ..
Now the user can set one record to 5 and after this, I would set all other
records before in steps of 10 and after this again:
For Example:
Before
Record 1 prio 3
Record 2 prio 10
Record 3 prio 18
Record 4 prio
29.11.2016 13:45, 'Israel Pinheiro' wrote:
>
> Invalid Token. Dynamic SQL Error. Invalid Command Data Type unknown
Check datatypes of all union parts, i.e.
select A1, B1, C1
union
select A2, B2, C2
union
select A3, B3, C3
Data types for (A1, A2, A3) should match exactly. The same for B and C.
Don't know whether Firebird has internal functions for this or not and it
is likely that there are more elegant solutions available, but the below
queries should be ways to get what you ask (although I don't know whether
you want to return all values for mode and whether or not you want the