[firebird-support] Object in use

2012-06-29 Thread arda
I have web clients, desktop clients and some service applications connected to the database. And I'm not the only one writing applications on the database. I have great difficulty when I need to change a stored procedure or table structure. I receive object in use errors and can't do anything

[firebird-support] Re: Unexpected behaviour when using union

2012-06-29 Thread Svein Erling Tysvær
This puzzles me, although I'm uncertain whether I'm puzzled by upper(2) not working with UNION or puzzled by upper(2) working without UNION. That is to be expected. Ordering by UPPER(2) does not sort by the second column, but it will do the following: = Coerce 2 to 2, = Execute UPPER(2)

[firebird-support] Sequent read of data

2012-06-29 Thread majstor
Hi, I have tables in my Firebird database with over 10 records with out primary key (I have primary key made from 3 fields) and I can't read data between first and second key because it is a large amount of data. So is there any solution in firebird to read for example first 1000 rows, next

RE: [firebird-support] Sequent read of data

2012-06-29 Thread Svein Erling Tysvær
Hi, I have tables in my Firebird database with over 10 records with out primary key (I have primary key made from 3 fields) and I can't read data between first and second key because it is a large amount of data. So is there any solution in firebird to read for example first 1000 rows,

[firebird-support] Re: Sequent read of data

2012-06-29 Thread majstor
Thanks a lot Set... --- In firebird-support@yahoogroups.com, Svein Erling Tysvær svein.erling.tysvaer@... wrote: Hi, I have tables in my Firebird database with over 10 records with out primary key (I have primary key made from 3 fields) and I can't read data between first and

[firebird-support] Activity of the firebird-support group

2012-06-29 Thread arda
Hi, I've just looked at the message count over years (jan-june) 2004 : 9713 messages 2005 : 9695 messages 2007 : 4497 messages 2009 : 3778 messages 2012 : messages What do you think?

Re: [firebird-support] Activity of the firebird-support group

2012-06-29 Thread Thomas Steinmaurer
I've just looked at the message count over years (jan-june) 2004 : 9713 messages 2005 : 9695 messages 2007 : 4497 messages 2009 : 3778 messages 2012 : messages What do you think? You think, if Firebird is dead or alive? IMHO, it is a good sign: * Firebird is getting more stable

Re: [firebird-support] Activity of the firebird-support group

2012-06-29 Thread Venus Software Operations
The product has got better The people have gained experience On 29/06/2012 03:13 pm, arda wrote: Hi, I've just looked at the message count over years (jan-june) 2004 : 9713 messages 2005 : 9695 messages 2007 : 4497 messages 2009 : 3778 messages 2012 : messages What do you think?

[firebird-support] Re: Activity of the firebird-support group

2012-06-29 Thread arda
:) I agree. Just one more thing, fewer newcomers. --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: I've just looked at the message count over years (jan-june) 2004 : 9713 messages 2005 : 9695 messages 2007 : 4497 messages 2009 : 3778 messages 2012 :

Re: [firebird-support] Return key

2012-06-29 Thread Milan Babuskov
Mags Phangisa wrote: I have changed the field to a text blob but the hard return is still not being recognised. I use ibase_blob_echo($rec-FLDNM) to display the data. What could I be doing wrong? ibase_blob_echo() means you're probably using PHP, so you're probably using HTML as output. HTML

Re: [firebird-support] Object in use

2012-06-29 Thread Milan Babuskov
arda wrote: Maybe the database can store the versions of stored procedures transparently? AFAICT, this already works that way, at least with Firebird Classic 2.1 on Linux which I mainly use in production. Which version of Firebird are you using? -- Milan Babuskov

Re: [firebird-support] Object in use

2012-06-29 Thread Jesús García
Jesus A. García Zarco AFAICT, this already works that way, at least with Firebird Classic 2.1 on Linux which I mainly use in production I think classic and superclassic do not support meta data change while in use, only superserver support it. [Non-text portions of this message have

Re: [firebird-support] Activity of the firebird-support group

2012-06-29 Thread Milan Babuskov
arda wrote: I've just looked at the message count over years (jan-june) 2004 : 9713 messages 2005 : 9695 messages 2007 : 4497 messages 2009 : 3778 messages 2012 : messages What do you think? People are moving away from mailing lists, or, to be more precise, younger developers

Re: [firebird-support] Object in use

2012-06-29 Thread unordained
-- Original Message --- From: arda atuncce...@duzen.com.tr I have great difficulty when I need to change a stored procedure or table structure. I receive object in use errors and can't do anything at day time. I need to wait till about midnight and disconnect all clients.

Re: [firebird-support] Activity of the firebird-support group

2012-06-29 Thread Carlos H. Cantu
I can notice similar decrease of messages over the years at FireBase discussion list too. 10 years ago, there was so little technical information about IB/FB freely available that discussion lists/forums were the main resource for posting questions and getting some kind of support. Nowadays we

[firebird-support] RM Cobol support

2012-06-29 Thread lindhardtfree
I'm missing the libfbrmc.so shared lib and I can't find any makefile for it in the source tar.

[firebird-support] Re: Object in use

2012-06-29 Thread markopetejan
I think classic and superclassic do not support meta data change while in use, only superserver support it. You have to use script to change procedures. Clients will see/use the old version until reconnect. Not so easy with tables though.