[firebird-support] Firebird c++ API connect encoding

2014-11-21 Thread hugo.lar...@yahoo.com [firebird-support]
Hello, Can someone advice on how to set the encoding of the connection with Firebird C++ API isc_attach_database call. I want to set it to ISO8859_1 but cant find an example. Thanks, Hugo

[firebird-support] FB 2.5 and lock

2014-11-21 Thread John vd Waeter j.v.d.wae...@kpnplanet.nl [firebird-support]
Hi All, I have a debian64 running FB 2.5. It serves 19 databases. Several clients connect to this server, amongst them Lazarus services, PHP and remote Delphi connections. About once a week, the system locks up. Not just connections to one database, *all* connections to any database freeze.

Re: [firebird-support] Firebird c++ API connect encoding

2014-11-21 Thread Scott Morgan bl...@blueyonder.co.uk [firebird-support]
On 21/11/14 11:21, hugo.lar...@yahoo.com [firebird-support] wrote: Can someone advice on how to set the encoding of the connection with Firebird C++ API isc_attach_database call. I want to set it to ISO8859_1 but cant find an example. Firebird doesn't have a C++ API, it has a C API and there

RE: [firebird-support] Left outer join with stored procedure

2014-11-21 Thread t...@camalot.ca [firebird-support]
You need to make sure your stored procedure returns the variable that you are going to join with. Here is an example: SELECT a.propid, b.EconomicZone_Code, a.MTQUST_Combo, a.Model_Code, a.Quality_Code, a.Structure_Code FROM Table1 a LEFT OUTER JOIN Procedure1(a.propid) b on