[firebird-support] Using FB another port than 3050

2012-01-25 Thread bennie_coetzer
Hi, I am still battling with FB on another port. I have changed the firebird.conf file to use port 3051. This seems to work as the port is actively monitored when FB runs and not when it is stopped.I then used FlameRobin and created a host (LocalFB) on port 3051. When trying to create a

[firebird-support] Temporary Table

2012-01-25 Thread Mahesh Pratihari
Hi, Could please guide me how to use temporary Table in firebird which we are used in SQL server 2008. Thanks, Mahesh Pratihari Please don't print this email unless you really need to. This will preserve trees on our planet. [Non-text portions of this message have been

Re: [firebird-support] Using FB another port than 3050

2012-01-25 Thread Nick Upson
firebird also uses port 3051 for events by default, so you may be running into a conflict, I suggest changing the port to something much higher, say 43050 43051 Nick Upson On 25 January 2012 11:17, bennie_coetzer bennie_coet...@yahoo.com wrote: ** Hi, I am still battling with FB on

Re: [firebird-support] Temporary Table

2012-01-25 Thread Mark Rotteveel
On Wed, 25 Jan 2012 17:06:26 +0530, Mahesh Pratihari mahesh.pratih...@sonata-software.com wrote: Could please guide me how to use temporary Table in firebird which we are used in SQL server 2008. Do you have specific questions or problems? Otherwise, first consult the language reference

Re: [firebird-support] Using FB another port than 3050

2012-01-25 Thread Josef Kokeš
Dne 25.1.2012 12:17, bennie_coetzer napsal(a): Hi, I am still battling with FB on another port. I have changed the firebird.conf file to use port 3051. This seems to work as the port is actively monitored when FB runs and not when it is stopped.I then used FlameRobin and created a host

Re: [firebird-support] using a param on a join part of a query

2012-01-25 Thread Mark Rotteveel
On Wed, 25 Jan 2012 11:21:42 -0300, Sergio H. Gonzalez shg_siste...@yahoo.com.ar wrote: Hello! This may be a silly question, but just in case I ask it anyway... Is there any problem in doing something like this? select d.descripcion, d.cantidad, p.id as id_plan_ctas,

[firebird-support] broken - pipe

2012-01-25 Thread pluto.pippo66
Hello I wrote an application in C + + slackware distro of Linux system, valid if the select is about 170,000, shame about half goes to error. Unable to complete network request to host localhost. -Error writing data to the connection. -Broken pipe Firebird used libfbclient verion 2.5. Thanks

[firebird-support] parrallel update

2012-01-25 Thread Vander Clock Stephane
Hello, I want to do simultaneous these update : Update table1 ... Update table2 ... etc... Update tablen ... the table1, table2, ... tableN are not connected in any way now i can do these update in parallel using n connections, but i would to avoid using n connection (mean start n transaction,

Re: [firebird-support] Using FB another port than 3050

2012-01-25 Thread Helen Borrie
At 12:39 AM 26/01/2012, Nick Upson wrote: firebird also uses port 3051 for events by default, That is not correct. Firebird uses any available port for events, unless the server is configured to use a specific port, via RemoteAuxPort. If events are being used and there are no available

Re: [firebird-support] parrallel update

2012-01-25 Thread Ann Harrison
Stephane, I want to do simultaneous these update : Update table1 ... Update table2 ... etc... Update tablen ... the table1, table2, ... tableN are not connected in any way now i can do these update in parallel using n connections, but i would to avoid using n connection (mean start n

Re: [firebird-support] Create Log for tables change, which one is better via app or via firebird?

2012-01-25 Thread Norman Dunbar
Morning Sugiarto, I want to record all changes in tables (insert/update/delete). I can do this by creating triggers for each tables, triggers ex : ... Or, I can record changes via my app, which one do you thing is better, regarding database performance and size? Always, always always

Re: [firebird-support] Create Log for tables change, which one is better via app or via firebird?

2012-01-25 Thread Martijn Tonies
Hi, Do it on the database - you won't make mistakes. I suggest you take a look at our product IB LogManager that can do the hard work for you - see www.upscene.com With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server,