Re: [firebird-support] Is there an easy way for input rows from a script file?

> On Feb 15, 2017, at 6:31 PM, setysvar setys...@gmail.com [firebird-support] > wrote: > > > > Den 15.02.2017 17:07, skrev 'Walter R. Ojeda Valiente' > sistemas2000profesio...@gmail.com [firebird-support]: >> Hello everybody >> >> If I connect to a

Re: [firebird-support] Re: Firebird 3 execution plan

Hi Dmitry,   current snapshot: WI-V3.0.2.32691 Firebird 3.0   CREATE UNIQUE DESCENDING INDEX IXDU_SENSOR_DATA__ID ON SENSOR_DATA (ID);   ID bigint   selectivity PK_SENSOR ASC ID 0.25   UK_SENSOR__SENSOR_UID ASC SENSOR_UID 0.25 FK_SENSOR_DATA__SENSOR ASC ID_SENSOR 0.25 

[firebird-support] Re: Firebird 3 execution plan

16.02.2017 21:20, liviuslivius wrote: > > Firebird3 There's no such a version. > plan is "expected" > PLAN JOIN (SD ORDER IXDU_SENSOR_DATA__ID, S INDEX (PK_SENSOR)) What's definition of IXDU_SENSOR_DATA__ID? Dmitry

[firebird-support] Firebird 3 execution plan

Hi,   Firebird3    SELECT FIRST 1 S.SENSOR_UID, S.NAZWA, SD.ID, SD.ID_SENSOR, SD.DT, SD.WARTOSC, SD.FLAGS FROM SENSOR_DATA SD INNER JOIN SENSOR S ON S.ID=SD.ID_SENSOR WHERE S.ID=1 ORDER BY SD.ID DESC   plan is "wrong" PLAN SORT (JOIN (S INDEX (PK_SENSOR), SD INDEX (FK_SENSOR_DATA__SENSOR)))

[firebird-support] Re: FB3 No permission for usage access to exception

Problem, solved. This was my error from an incorrect role name used in the connection string.

[firebird-support] FB3 No permission for usage access to exception

I'm confused about an error when accessing an FB3 database - "No permission for USAGE access to Exception E_Exception". When I run a program while logged into database as SYSDBA I do not get this error. I ran "grant usage on exception e_exception to user NICOLED" and "grant usage on

Re: [firebird-support] Is there an easy way for input rows from a script file?

Thank you Set, now I know the meaning of HTH. Greetings. Walter. On Thu, Feb 16, 2017 at 4:09 AM, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > > > HTH = Hope this (alternatively: that) helps > > 2017-02-16 3:06 GMT+01:00 'Walter R.

Re: [firebird-support] Re: Is there an easy way for input rows from a script file?

Thank you Vlad, but is not for me, is for an article of my blog, I am showing the alternatives for exporting data. firebird21.wordpress.com Greetings. Walter. On Thu, Feb 16, 2017 at 3:44 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In

Re: [firebird-support] Is there an easy way for input rows from a script file?

HTH = Hope this (alternatively: that) helps 2017-02-16 3:06 GMT+01:00 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] < firebird-support@yahoogroups.com>: > > > Thank you very much Set, I will try your advice. > > Off topic: can you say me what the letters HTH