Re: [Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Jorge Gonçalves
> > > Actually, it looks like you: > > - didn't bother reading the v3.0+ release notes and read about the new > Boolean datatype. > who reads ( sarcasm ) > > - make appropriate changes to your schema. Namely, to change your domain > names/references to be unique (so then never collide

[Firebird-devel] Fwd: CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-21 Thread Jorge Gonçalves
-- Forwarded message - From: Mark Rotteveel Date: Thu, May 21, 2020 at 8:25 AM Subject: Re: [Firebird-devel] CASE statement Error : Datatypes are not comparable in expression CASE To: Jorge Gonçalves This looks like a bug to me, could you report it on http

[Firebird-devel] CASE statement Error : Datatypes are not comparable in expression CASE

2020-05-20 Thread Jorge Gonçalves
Have the CASE rules changed in FB4? The next SQL stopped running on FB4 with error "Datatypes are not comparable in expression CASE". SQL> select CON> STORE.ID STORE_ID, STORE.CODE STORE_CODE, STORE.DESCRIPTION STORE_NAME, STORE.FISCALMODULE, CON> STORE.COMPANY_ID, CON> CON> case CON> when

Re: [Firebird-devel] Fwd: [firebird-support] Running FB4 and FB3 on same port

2020-05-15 Thread Jorge Gonçalves
> > > > Please retry with fresh engine12. > > Confirms. .. with fb 3.0.5 everything works fine. > > I do not know what does folder level mean here. Provider configuration > may be set in firebird.conf (default for all server) or for any database > in databases.conf (overrides server default).

[Firebird-devel] Fwd: [firebird-support] Running FB4 and FB3 on same port

2020-05-15 Thread Jorge Gonçalves
I already have to fb3 running alongside fb4 but with some strange problems .. some examples : isql from firebird 4 C:\Program Files\Firebird\Firebird_4_0>isql.exe fb3 -user SYSDBA -password masterkey Database: fb3, User: SYSDBA 1- SQL> select current_user from rdb$database;

[Firebird-devel] FB4 reserved word "LOCAL"

2019-02-02 Thread Jorge Gonçalves
Hi, the word LOCAL was promoted to reserved word ? I'm trying, for the first time, to run my company application on FB4 and the calls to the table "LOCAL" fails with "Token unknown ... LOCAL " . jGoncalves Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Time zone identifier to displacement convertion

2019-01-20 Thread Jorge Gonçalves
I'm using Firebird-4.0.0.1378-0_x64 and it seems that the timezone database is missing for example the statement "select rdb$time_zone_util.database_version() from rdb$database;" returns DATABASE_VERSION Statement failed, SQLSTATE = HY000 Error calling ICU's

[Firebird-devel] Time zone identifier to displacement convertion

2019-01-20 Thread Jorge Gonçalves
Hi, according to the time zone documentation the time_zone member in the ISC_TIME_TZ and ISC_TIMESTAMP_TZ structure returns the time zone identifier or displacement. There are any way to convert the time zone identifier to the displacement on the client side ? jGoncalves Firebird-Devel mailing

Re: [Firebird-devel] Android/iOS Embedded with Xamarin Forms

2018-04-30 Thread Jorge Gonçalves
On Mon, Apr 30, 2018 at 12:08 PM Luiz Alberto Tessarolli < tessaro...@gmail.com> wrote: > Hi Jorge, > > Config.AppDir points to Application Data > Folder: /data/user/0/com.companyname.TS/files/.config/ > Config.FirebirdServerLib points > to

Re: [Firebird-devel] Android/iOS Embedded with Xamarin Forms

2018-04-25 Thread Jorge Gonçalves
er, > AssetName))) > asset.CopyTo(dest); > } > } > catch (Exception) > { > } > > } > > > and Here i'm trying to create the database > > public static void CriarDatabase() > { &

Re: [Firebird-devel] Android/iOS Embedded with Xamarin Forms

2018-04-23 Thread Jorge Gonçalves
Hi, from my attempt to put FB running on Android The process is a little tricky. 1º You must put the files( libfbclient, libEngine12, .. ) on asset folder and then copy that to app/files folder. The folder structure must be kept in order to work. ex : .../app.com/files/fb/firebird.conf

Re: [Firebird-devel] Error compiling FB for android

2018-01-21 Thread Jorge Gonçalves
ail_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Thu, Jan 18, 2018 at 10:19 AM, Alex Peshkoff via Firebird-devel < firebird-devel@lists.sourceforge.net> wrote: > On 01/18/18 12:47, Jorge Gonçalves wrote: > >> Hi, >> I want to make some tests with F

[Firebird-devel] Error compiling FB for android

2018-01-18 Thread Jorge Gonçalves
Hi, I want to make some tests with FB embedded on android, and I'm getting the follow error compiling the source. /home/jgoncalves/dev/android/android-ndk-r16b/toolchains/ arm-linux-androideabi-4.9/prebuilt/linux-x86_64/bin/arm-linux-androideabi-gcc