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

2019-10-10 Thread p...@coshott.com [firebird-support]
Hi Norbert, Thanks for the answer. Just one little thing in case anyone else needs to do this. The ; after the "END" in the first case statement should not be there. But otherwise works perfect. Cheers, Paul

Re: [firebird-support] Re: Off-Topic: Firebird future

2019-10-10 Thread Daniel Miller dmil...@amfes.com [firebird-support]
On 10/9/2019 9:08 AM, pablo sanchez pab...@adinet.com.uy [firebird-support] wrote: > I use Firebird since 0.x version (open interbase?) . > > It's the most versatile db I've found so far : embedded and full server, > linux(99%) and windows, odbc or jaybird. > > Installs in 5 minutes with db

Re: [firebird-support] Scaling Firebird - Azure

2019-10-10 Thread Daniel Miller dmil...@amfes.com [firebird-support]
On 10/6/2019 9:49 AM, Rune Horneland rune.hornel...@kravia.net [firebird-support] wrote: > > > Hi, > We are running Firebird 2 in an Azure VM. It can only take so much in > terms of concurrent connections. > What top-level advice would you give to scale this? > > We are connecting to it from

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

2019-10-10 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
Simple, replace(reverse(substring(reverse(i.location) from position(' ', reverse(i.location, ' / - ', ' AT ' ) Though splitting on the last space would be a problem with cities having spaces in their names, e.g. New York (USA) or St Albans (England). HTH, Set ons. 9. okt. 2019 kl. 00:14