[firebird-support] Re: Firebird server maximum number of simultaneous connections

2013-04-09 Thread mariuz
--- In firebird-support@yahoogroups.com, "frodrigues_fcprd" wrote: > > Hi, > > We are using a set of 20 databases that are accessed simultaneously by 20 (or > more) applications (each one with multiple threads). These applications > (written in c# and using the FirebirdSql.Data.FirebirdClien

[firebird-support] Re: Restart and stop Firebird 2.5.2 on Linux

2013-04-09 Thread jorgebj
Hello Konstantin: Yes, I saw your post earlier but I was unable to find those files scripts. I am new in Linux and the Linux installation on the server was made by a supplier. I think the installation was not normal because there are some files and folders that are not in the normal installatio

[firebird-support] Re: Restart and stop Firebird 2.5.2 on Linux

2013-04-09 Thread jorgebj
Hola Maximiliano: Efectivamente tenemos Ubuntu 10.4 Muchas gracias por la ayuda. Lo llevaré a cabo y espero que ya no tenga más preguntas respecto a esto. Saludos! Atte: Jorge Botello --- In firebird-support@yahoogroups.com, Maximiliano Robaina wrote: > > De: jorgebj > Para: firebird-supp

RE: [firebird-support] Database version

2013-04-09 Thread Leyne, Sean
> what is the best approach to assign a version to the database. > Let's say it's starts with 1.0.1.1 then 1.0.1.2.. etc,, I'm looking at > storing it with > the DB itself. Is there a way to store it and read it from system variables?.. > I wanted to use a DB field but it sounds too much for wha

[firebird-support] Database version

2013-04-09 Thread halim1973
Hello, what is the best approach to assign a version to the database. Let's say it's starts with 1.0.1.1 then 1.0.1.2.. etc,, I'm looking at storing it with the DB itself. Is there a way to store it and read it from system variables?.. I wanted to use a DB field but it sounds too much for what I w

Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?

2013-04-09 Thread Norman Dunbar
On 09/04/13 14:50, Norman Dunbar wrote: > PS. I'll update the docs to clarify this. I've updated the docs for gfix to reflect the fact that prior to 2.1RC1 error exits were zero, regardless, but since 2.1RC1, success returns zero while errors return 1. A new pdf is available at http://www.fir

Re: [firebird-support] Computed field Dependencies

2013-04-09 Thread Mark Rotteveel
On Tue, 09 Apr 2013 10:51:43 -0300, Gugui wrote: > hi Marijn, > > i´m using firebird-server-classic-2.1.3.18185.0-5mdv2010.0 Alter table for computed fields was added in Firebird 2.5: http://www.firebirdsql.org/file/documentation/reference_manuals/reference_material/html/langrefupd25-ddl-table.h

Re: [firebird-support] Computed field Dependencies

2013-04-09 Thread Martijn Tonies
Hi, > i´m using firebird-server-classic-2.1.3.18185.0-5mdv2010.0 In that case, here's how DBW does it for you: // delete field dependencies for field "MYTESTFIELD" delete from rdb$dependencies where rdb$dependent_name = (select f.rdb$field_name from rdb$fields f join rdb$relation_fields rf on rf

Re: [firebird-support] Computed field Dependencies

2013-04-09 Thread Gugui
hi Marijn, i´m using firebird-server-classic-2.1.3.18185.0-5mdv2010.0 Em 09-04-2013 10:31, Martijn Tonies escreveu: > Hi, > >> Hi Martijn, i did what u said, but when i try to alter the field in >> Database Workbenc it shows me the same thing: >> >> Column RAZAO_SOCIAL from table CLIENTE is

Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?

2013-04-09 Thread Norman Dunbar
On 09/04/13 14:35, Norman Dunbar wrote: > I'll check and get back tou you to see if there's anything in the > release notes from 2.0 onwards that may have changed this. I've checked all the release notes and it seems the error reporting problem was raised as CORE-1548 on tracker, and was fixed i

Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?

2013-04-09 Thread Norman Dunbar
> Could anyone provide me with this information? http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/gfix-caveats.html#d0e30504 Sadly, that's not much use. It's the part of the gfix manual that says "almost all exit codes from gfix, even up to version 2, are zero".

Re: [firebird-support] Computed field Dependencies

2013-04-09 Thread Martijn Tonies
Hi, > Hi Martijn, i did what u said, but when i try to alter the field in > Database Workbenc it shows me the same thing: > > Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536 > > i cant find this dependencie, i´m so disappointed with Firebird :-( > > could u explain me in detail h

Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?

2013-04-09 Thread Marcus Bajohr
Hej, AFAIK there are no dedicated return codes for gfix. So you'll get a non-zero return code if there is a problem while executing gfix, but not from gfix when there are any problems with a database. cheers, Marcus un_spoken schrieb: > Hi guys. > > My application needs to call gfix every day t

Re: [firebird-support] Computed field Dependencies

2013-04-09 Thread Gugui
Hi Martijn, i did what u said, but when i try to alter the field in Database Workbenc it shows me the same thing: Column RAZAO_SOCIAL from table CLIENTE is referenced in RDB$1536 i cant find this dependencie, i´m so disappointed with Firebird :-( could u explain me in detail how to do that ? t

[firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?

2013-04-09 Thread un_spoken
Hi guys. My application needs to call gfix every day to check our clients databases. How can I know the result of gfix execution? I would not like to parse the output messages from the console. I would like to know the ExitCode returned by the gfix executable but I can not find description for

[firebird-support] Unsubscribe

2013-04-09 Thread Liedtke, Lars (SCC)
[Non-text portions of this message have been removed]