[firebird-support] Re: Cross database update

2014-11-19 Thread masb...@za-management.com [firebird-support]
Hi All! Just to close this and perhaps some one is interested. I have now had several excellent feedbacks from the IBExpert Support forum which solved the problem. The relevant part has to be like this: select rdb$set_context('USER_TRANSACTION', 'bulkload', '1') from rdb$database into

[firebird-support] Left outer join with stored procedure

2014-11-19 Thread zilez2...@yahoo.com [firebird-support]
Hello All, I have a table regioni with 164 rows (r_id), and also stored procedure which returns some data like (r_id, value). When I try to use select regioni _ID, stored_procedure_value from regioni left outer join stored_procedure (:DATE1,:DATE2) I only get number 20 rows for the R_ID

[firebird-support] Stability on newer windows ...

2014-11-19 Thread Lester Caine les...@lsces.co.uk [firebird-support]
My systems have run for many years on XP and W2k without any problems, but now I'm being forced to upgrade systems on sites to a later version of windows, I'm hitting problems. I'm having to live with both Windows 7 and 8.1, fortunately 8 is black listed like vista. I've had problems with windows

Re: [firebird-support] Stability on newer windows ...

2014-11-19 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Currently, FB 2.1 is lo longer supported as older OSs. Maybe your problem was corrected in a newer FB version as FB 2.5.3 (that corrects a bug of caching on 64 bit Windows by example). IMHO, you need to switch to the lasted Firebird (2.5.3) and try again. On 19/11/2014 13:10, Lester Caine

Re: [firebird-support] Stability on newer windows ...

2014-11-19 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 19/11/14 17:15, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: Currently, FB 2.1 is lo longer supported as older OSs. Maybe your problem was corrected in a newer FB version as FB 2.5.3 (that corrects a bug of caching on 64 bit Windows by example).

Re: [firebird-support] Stability on newer windows ...

2014-11-19 Thread Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support]
Try using the 32 bit version of Firebird, maybe this can help you. On 19/11/2014 14:11, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 19/11/14 17:15, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: Currently, FB 2.1 is lo longer supported

[firebird-support] Selecting arbitrary records in an arbitrary order

2014-11-19 Thread Caroline Beltran caroline.d.belt...@gmail.com [firebird-support]
I hope that someone can advise how I can efficiently arbitrarily select data from a table. I am provided with a list of IDs to display, for example: Employee ID Numbers: 1032, 624, and 2841. This would be the output (in the same order as the list above): Employee ID FName LName

Re: [firebird-support] Firebird can't connect to host

2014-11-19 Thread Andromeda andromedar...@gmail.com [firebird-support]
Hi Marcus, I use Superclassic Firebird version and already configured the inetd conf. Thanks a lot for the response, Regards Andromeda

Re: [firebird-support] Firebird can't connect to host

2014-11-19 Thread Andromeda andromedar...@gmail.com [firebird-support]
Finally, my friend, Nigel Weeks (nigel.we...@gmail.com) help me to solve this problem. He can't post the replies directly into this topic because of some minor issue, so we did a private conversation by email account and here is the summary of our conversation by email. *The main issue is* : I

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

2014-11-19 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Hello All, I have a table regioni with 164 rows (r_id), and also stored procedure which returns some data like (r_id, value). When I try to use select regioni _ID, stored_procedure_value from regioni left outer join stored_procedure (:DATE1,:DATE2) I only get number 20 rows for the R_ID