[firebird-support] DB upgrade questions

2012-12-02 Thread Robert martin
Hi We are looking to migrate our users from super server 2.0 to super classic 2.5.2. We have been waiting for FB 3 but can't hold off any later. I have a couple of questions... 1) Is SuperClassic the best be, we want to improve multi user performance? 2) Can 32bit ODBC connect to 64bit ins

Re: [firebird-support] Where condition by column number

2012-12-02 Thread Thomas Steinmaurer
>>> >> On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé >>> <[1][1]l.r...@griensu.com> >>> >> wrote: >>> >> >>> >> > Hi, I'm wondering if there's a way to refer columns by number in >>> WHERE >>> >> > conditions. >>> >> > >>> >> > I need this because I'm

Re: [firebird-support] Where condition by column number

2012-12-02 Thread Thomas Steinmaurer
>> >> On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé >> <[1][1]l.r...@griensu.com> >> >> wrote: >> >> >> >> > Hi, I'm wondering if there's a way to refer columns by number in >> WHERE >> >> > conditions. >> >> > >> >> > I need this because I'm creating a generi

Re: [firebird-support] Where condition by column number

2012-12-02 Thread Leonardo M . Ramé
On 2012-12-02 16:59:24 +0100, Thomas Steinmaurer wrote: >  > >>> On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé ><[1][1]l.r...@griensu.com> >>> wrote: >>> >>> > Hi, I'm wondering if there's a way to refer columns by number in >WHERE >>> > conditions. >>> > >

Re: [firebird-support] Where condition by column number

2012-12-02 Thread Thomas Steinmaurer
>> On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé <[1]l.r...@griensu.com> >> wrote: >> >> > Hi, I'm wondering if there's a way to refer columns by number in WHERE >> > conditions. >> > >> > I need this because I'm creating a generic method to create where >> > clauses

Re: [firebird-support] Where condition by column number

2012-12-02 Thread Leonardo M . Ramé
On 2012-12-01 14:14:50 -0500, Ann Harrison wrote: >  > >On Sat, Dec 1, 2012 at 8:09 AM, Leonardo M. Ramé <[1]l.r...@griensu.com> >wrote: > >> Hi, I'm wondering if there's a way to refer columns by number in WHERE >> conditions. >> >> I need this because I'm creating a

Re: [firebird-support] Authentication = Trusted, where to learn more

2012-12-02 Thread Thomas Steinmaurer
Brian, > Where can I learn about using trusted authentication? Frank gave you already the link to the documentation. When using Windows trusted authentication, keep in mind that Windows domain users play under same Firebird naming convention rules like any other database objects in respect to

Re: [firebird-support] Recording Error Trapped in Stored Procedure

2012-12-02 Thread Thomas Steinmaurer
Marius, > I have used SQLSTATE to record the error state. I will then just go find > the message for the SQLState on the internet. If you want to be sure that your log entry gets inserted, even in case your client transaction gets rolled back, you have to look into wrapping the INSERT INTO sta

RE: [firebird-support] Recording Error Trapped in Stored Procedure

2012-12-02 Thread Marius Labuschagne
Hi, I have used SQLSTATE to record the error state. I will then just go find the message for the SQLState on the internet. Regards Marius

[firebird-support] Recording Error Trapped in Stored Procedure

2012-12-02 Thread Marius Labuschagne
Hi, I am making using of the WHEN clause to trap any exceptions that are produced during the execution of my stored procedure (non selectable). ... WHEN ANY DO BEGIN INSERT INTO SP_ERRORS (ROWNO, EXCEPT_MESSAGE) VALUES (:vIRN, ); END ... How can I store the value (text) of the e

Re: [firebird-support] Authentication = Trusted, where to learn more

2012-12-02 Thread Frank Schlottmann-Gödde
On 11/30/2012 10:47 AM, Brian Dunstan wrote: > Hi, > > Where can I learn about using trusted authentication? > > Thanks in advance, > Brian Firebird release notes: http://firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-wintrusted hth Frank -- "Fascinating creatures, phoenixes, they can carry