Re: [firebird-support] Scaling Firebird - Azure

2019-10-08 Thread Alex Castillo acr_k...@yahoo.com [firebird-support]
Using Azure is a little bit tricky with any database. Since FB doesn't have DBaaS support from any Cloud provider that I know you will need to go only for VM or containers for your deployment. If you google for "firebird performance tuning" you will find some interesting

[firebird-support] Off-Topic: Firebird future

2019-10-08 Thread Alex Castillo acr_k...@yahoo.com [firebird-support]
Hello everyone, I've been using FB since version 1 and I have only good comments about the database quality and performance. However, It's true that the development has evolved too slow and we had to wait almost 10 years since the first release to get a real SMP support (I know that's tricky

[firebird-support] libtommath.so.0 error for newbie

2019-10-08 Thread 'S. Sliackus' ssliac...@gmail.com [firebird-support]
Hello everyone, I need help installing/running Firebird on Manjaro. I am absolute newbie (have no idea what I am doing) in databases and want to learn SQL. I've chosen Firebird because it can be embedded into programs or used as server-client without changes to database itself (I'll figure out

[firebird-support] Help with splitting a string in Firebird SQL

2019-10-08 Thread Ron Pillar ron.pil...@in-synch.com [firebird-support]
Hello All, I could use some help/direction with splitting (or extracting data between certain characters in) an existing string. This is generally a simple task in code using IndexOf, LastIndexOf, etc. but I can't seem to figure out the syntax in Firebird SQL (and it has to be done in SQL

Re: [firebird-support] Firebird-net-provider

2019-10-08 Thread Clyde Eisenbeis cte...@gmail.com [firebird-support]
Good points. I'll re-word it. In addition, I've been spoiled by Stack Overflow => responses are often within minutes after posting the question.. Thanks! On Tue, Oct 8, 2019 at 1:36 PM Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 2019-10-08 14:18, Clyde Eisenbeis

Re: [firebird-support] Firebird-net-provider

2019-10-08 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2019-10-08 14:18, Clyde Eisenbeis cte...@gmail.com [firebird-support] wrote: > Everything worked up to the last step. After a variety of bounced > emails (some with the registration in the subject), I was > finally able to post a question on the website. As of today, there > are no

Re: [firebird-support] Firebird-net-provider

2019-10-08 Thread Clyde Eisenbeis cte...@gmail.com [firebird-support]
Hi Mark, Everything worked up to the last step. After a variety of bounced emails (some with the registration in the subject), I was finally able to post a question on the website. As of today, there are no responses. When I reviewed a variety of databases two years ago, I selected Firebird

[firebird-support] Re: Using params to choose the order by fields?

2019-10-08 Thread Norbert Saint Georges n...@tetrasys.eu [firebird-support]
> SELECT > MEMBERS.FIRST_NAME, > MEMBERS.SURNAME, > MEMBERS.MEMBERID > FROM > MEMBERS > WHERE > MEMBERS.CLUBID = :CID > ORDER BY > CASE :OBC > WHEN 1 THEN MEMBERS.SURNAME > WHEN 2 THEN MEMBERS.FIRST_NAME > END; > > > The above works, but if I put in 2 fields as below, I

[firebird-support] Using params to choose the order by fields?

2019-10-08 Thread p...@coshott.com [firebird-support]
Hi All, I want to give my users the choice of ordering their member list by FIRST_NAME, SURNAME or SURNAME, FIRST_NAME I managed to get it working using a case statement, but only with one field in Order By clause. If I put in the second field, it gives me an invalid token error on the comma.