Hello Group,
I have a server running Firebird 2.5.0 in Classic mode on Windows.
There is a database that appears corrupted (internal Firebird consistency check
...).
I have got all users out and renamed the file and attempted:
gfix -v localhost:C:\data\corrupt.fdb -user sysdba -password
Ah, I did not know that Karol. I'll try this after the UDF problem has been
solved. Russell
09.03.2016 12:18, 'Checkmail' check_m...@satron.de [firebird-support] wrote:
> the trigger is required because the user can delete the one record, in this
> case the
> trigger deletes the referenced too. But if I delete the entire Order, the
> record will be
> delete twice. How can I solve this
One hint,
the trigger is required because the user can delete the one record, in this
case the trigger deletes the referenced too. But if I delete the entire
Order, the record will be delete twice. How can I solve this in fb 3?
Von: Checkmail [mailto:check_m...@satron.de]
Gesendet:
Hello again,
now I have in FB3 a problem. A stored Procedure should delete some records.
ID some fields ID_AUTOINSERT
123xxx null
234 xxx null
255 xxx 266
266 xxx null
Now there is a trigger after delete in this table
Hello,
your are right. But in FB 3, it will be handled different.
I need the left join tlager_sum, because I’d like to have all records too there
no records in tlager_sum. But in this case I get now in fb 3 the tteile.teilenr
clean without the amaount of tlager_sum (the a.minb is greater
>>However on this server I first installed FB3 RC2 (64) and saw my database
>>managers were 32 bit so I uninstalled FB3 (64)
Russell
___
Hi,
you can use Firebird 64 bit with 32 bit applications - only fbclient.dll must
be 32 bit then
regards,
Karol Bieniaszewski
Hallo,
Il 08/03/2016 20.36, setysvar setys...@gmail.com [firebird-support] ha
scritto:
> This will not work properly if more than one row of DC are joined to
> the same DT (but then your ORDER BY isn't 100% deterministic). If you
> change the ordering of your query, you also have to change the
Thank you Dimitry for the hint. Using DatabaseWorkbench I instruct the server
in which FB3 is installed to use fbclient.dll that comes with FB3. So I am
using the this fbClient.dll with all databases I am testing with FB3.
The freeUDFLib.dll file is working fine with FB2.5.x on another
Thanks for suggestions Karol.
I am using Win 10 (64) and FB3 (32).
All DLLs are 32 bit, assessed by looking in the DLL files.
Russell
,___
I know that this is not so helpfull - byt you do not need to use external
functions to extract year or others
it exists in firebird itself EXTRACT(YEAR FROM
10 matches
Mail list logo