Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

2017-04-26 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
"firebird-support@yahoogroups.com" >>> DSsicfs> 26.04.2017 14:51, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: >> What else can I check? DSsicfs>Network cards, cable, commutators and firewall/antivirus between this server and DSsicfs> 192.168.0.22

Re: [firebird-support] Error writing data to the connection OR Error reading data from the connection

2017-04-26 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
[firebird-support] "firebird-support@yahoogroups.com" >>> DSsicfs> 26.04.2017 13:42, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: >> Firebird.log file shows only lines with 10054 and nothing else. DSsicfs>Is it server log or client log? >> How can

[firebird-support] Error writing data to the connection OR Error reading data from the connection

2017-04-26 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello FireBird Support! Some customers are having troubles which causes %subject% error messages. I think it can be a problem with UDF, but I cannot prove if it is right. Firebird.log file shows only lines with 10054 and nothing else. How can I find out the reason why a

[firebird-support] internal Firebird consistency check (applied differences will not fit in record (177), file: sqz.cpp line: 127)

2017-02-20 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello firebird-support@yahoogroups.com! I am migrating data and changing many and many records in one transactions. I have not made anything strange just SQL editor and some SQL commands which forced this database corruption: DEVELOP Mon Feb 20 16:17:54 2017 Database:

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-28 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
<<< 22.12.2016 7:20 - Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] "firebird-support@yahoogroups.com" >>> DYdusnfs> 21.12.2016 12:39, Roland Turcan wrote: >> >> But still, why this problem occurred? Why didn't some generators have >> it =1? DYdusnfs> Could that database be

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-21 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
<<< 21.12.2016 9:34 - Helen Borrie hele...@iinet.net.au [firebird-support] "firebird-support@yahoogroups.com" >>> HBhinafs> Hello Roland, HBhinafs> HBhinafs> Wednesday, December 21, 2016, 9:11:36 PM, Roland Turcan wrote: HBhinafs> >> But I cannot call this: HBhinafs> >> update

Re: [firebird-support] Re: NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-21 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello Dmitry, Thanks for response, but I have found that he has only few generators with value 1. But I cannot call this: update RDB$GENERATORS set rdb$generator_increment = 1 where rdb$generator_name not starting 'RDB$'; how can I set the value to 1? Thanks. RT; <<< 6.12.2016 9:23 -

[firebird-support] NEXT VALUE FOR on Firebird 3.0.1 32bit Windows 7 32bit

2016-12-06 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello firebird-support@yahoogroups.com! I have installed new clean database to new customer having FB3.0.1 32bit running on Windows7Pro 32bit. He was complaining that he is not able to add new record into some parts of our software. I have connected to his computer and made

Re: [firebird-support] Re: Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).

2016-06-17 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
<<< 17.06.2016 13:20 - Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] "firebird-support@yahoogroups.com" >>> DSsicfs> 17.06.2016 13:17, Roland Turcan k...@rotursoft.sk [firebird-support] wrote: >> I don't want to post this issue into DEVEL

Re: [firebird-support] Re: Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).

2016-06-17 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello Norbert, Thanks for your confimation, that I am not alone on this planet having this problem. I can't say if customers had it during concurrent access to the same record, but in my case it was definitely not caused by concurrent access, because I have got it on my developer test

Re: [firebird-support] Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).

2016-06-17 Thread Roland Turcan k...@rotursoft.sk [firebird-support]

[firebird-support] Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).

2016-06-16 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello firebird-support@yahoogroups.com! I am trying to deploy Firebird 3.0 to our customers. Only three small customers are running on FB3, but all of them have the same problem: invalid transaction handle (expecting explicit transaction start). This exception happens on different places which

[firebird-support] How to replace NOT IN with JOINs

2015-10-21 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello firebird-support@yahoogroups.com! CREATE TABLE AAA_TABLE_A (ID D_INTEGER); CREATE TABLE AAA_TABLE_B (ID D_INTEGER, AAA_TABLE_A D_INTEGER, MY_VALUE D_INTEGER, MY_VALUE2 D_INTEGER); DELETE FROM AAA_TABLE_A; INSERT INTO AAA_TABLE_A (ID) VALUES (1); INSERT INTO AAA_TABLE_A (ID) VALUES (2);

[firebird-support] How to show all relations for table.column over foreign key

2015-05-27 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello All, How to build up SQL query over system tables to find out which tables are depending to exact table and column I am searching for. Thanks in advance. -- Best regards, TRoland http://www.rotursoft.sk http://exekutor.rotursoft.sk

Re: [firebird-support] UDF for linux 64 bit compiled with Freepascal 2.6.4

2014-12-19 Thread Roland Turcan k...@rotursoft.sk [firebird-support]

[firebird-support] UDF for linux 64 bit compiled with Freepascal 2.6.4

2014-12-15 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello firebird-support@yahoogroups.com! I am migrating my UDF from windows to linux, but all functions using string as output when they are used crashes the server. I suppose it must be related to libib_util.so and its function ib_util_malloc. My declaration is the following: {$IFDEF

[firebird-support] How to rebuild all stored procedures / triggers

2014-11-05 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello guys, How can I rebuild all my SP or triggers after altering of one which has many depended callings. How can I assure that my altered SP will be used in all objects depending on it instead of old BLR of it. Should I call alter procedure and alter trigger on all SP or TR. If yes,

Re: [firebird-support] Re: How to rebuild all stored procedures / triggers

2014-11-05 Thread Roland Turcan k...@rotursoft.sk [firebird-support]

[firebird-support] How to change table to global temporary table

2014-10-29 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello All, I have few tables which are used for many years as temporary table, but that time was not possible to create them in Firebird. Do you know any hack over system tables which would allow to change normal table to global temporary and it will not cause some problems? It would be

Re: [firebird-support] no permission for read-write access to database

2014-10-28 Thread Roland Turcan k...@rotursoft.sk [firebird-support]

[firebird-support] no permission for read-write access to database

2014-10-27 Thread Roland Turcan k...@rotursoft.sk [firebird-support]
Hello firebird-support@yahoogroups.com! I have one customer having this error message very often when he starts software after he boots up his computer which is as server as well no permission for read-write accesstodatabase C:\DATA\CUSTOMERS.FDB He runs the