[firebird-support] Re: Firebird vs Intebase

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Mark Rotteveel m...@lawinegevaar.nl [firebird-support] a écrit :
> On 26-03-2020 11:37, Dimitry Sibiryakov s...@ibphoenix.com 
> [firebird-support] wrote:
>> 26.03.2020 11:35, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support] 
>> wrote:
>>> Form Embarcadero marketing matriel
>> 
>> Already was discussed here a couple of months ago. Look into archives.
>
> Which archives?

news (port:119)
news.gmane.io/gmane.comp.db.firebird.user

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> SET BIND OF  TIME ZONE  TO  LEGACY ;

for more complete information on "bind", the documentation is here

https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.set_bind.md

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> But the new field typ Timestamp_tz are a bigger problem. So i think, we 
> running into a compatibility problem with older developer systems. I use 
> Delphi Rio 10.3.3 with FireDAC, but its not possible for me to compile a 
> running program right now?!

but if, of course, the development team has everything planned :-)

SET BIND OF  TIME ZONE  TO  LEGACY ;

SQL_TIMESTAMP_TZ ->SQL_TIMESTAMP

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the fbclient.dll 
> (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also 
> when i use the 32bit version with my 32bit program. I used the dll from 
> "C:\Program Files\Firebird\Firebird_4_0"
>
> 2. When i try to execute a SQL-Statement like "select * from mon$database" if 
> got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754).
>
> And my program catches a exception with eurekalog like the follow
>   2.5 Type  : EIBNativeException
>   2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA 
> structure.
>
> Has somebody a tip? Thanks
>
> Gregor

after a test with the compiled version of the day, indeed, there is the 
following error if we do not use the 1815 version of fbclient

"Unsuccessful execution caused by system error that does not preclude 
successful execution of subsequent statements.
Invalid clumplet buffer structure: path length doesn't match with 
clumplet."

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Newest version of what? EMS? FDAC?  Or FB4?

sources of FB4 :-)

as a working client with FB4 currently, there is RedDatabase from 
RedSoft (https://reddatabase.ru/downloads/redexpert/)

or IBExpert (https://www.ibexpert.net/downloadcenter/)
all other utilities tested to date generate compatibility errors.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird 4.0.0-1436 beta 1

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Gregor Kobler gregorkob...@yahoo.com [firebird-support] a écrit :
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the fbclient.dll 
> (64Bit) my program crashes! when i use the 64bit dll from FB3 it works, also 
> when i use the 32bit version with my 32bit program. I used the dll from 
> "C:\Program Files\Firebird\Firebird_4_0"
>
> 2. When i try to execute a SQL-Statement like "select * from mon$database" if 
> got the follow error with EMS-Firebird Manager Unknown SQL Data type (32754).
>
> And my program catches a exception with eurekalog like the follow
>   2.5 Type  : EIBNativeException
>   2.6 Message   : [FireDAC][Phys][FB]Incorrect values within SQLDA 
> structure.
>
> Has somebody a tip? Thanks
>
> Gregor

32754 = SQL_TIMESTAMP_TZ and EMS and FireDAC does not recognize it yet.
You are interested in doing the test with a version compiled with the 
latest sources

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Object dependencies in Firebird OO API

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit :
>Hello, All.
>
>In the description of OO API I failed to find if objects (classes) are 
> depended or not.I.e. I would like to know if order of releasing of them 
> matters. Can I release  IProvider before IAttachment and IAttachment before 
> IStatement or it is required to  release acquired interfaces before the 
> interface it was got from?
>

Hello,

Personally, I release my classes in the opposite directions to their 
creation.

coordialement
Norbert

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird Embedded access permissions problem?

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Hello,

Mainly using Delphi 10.3.3 and Firebird 3 & 4 in embebded mode without 
any problem with the only difference that I do not use firedac (too 
much incomprehensible error).
Maybe a clue to your problem.
ps: I work with Firebird OO APIs
Regards,
Norbert

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: oracle numeric conversion (22).

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> ps. in RDB$TYPE on the 26 does not exist :-)

oups in WI-T4.0.0.1687 Firebird 4.0 Beta 1 this ok
26 = int128

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: oracle numeric conversion (22).

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit :
>> what do you recommend for conversion?
>
>Numeric and FB 4.

rdb$FIELD_TYPE = 26
and
rdb$FIELD_SUB_TYPE = 1

it's correct ?

ps. in RDB$TYPE on the 26 does not exist :-)

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] oracle numeric conversion (22).

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

oracle numeric conversion (22).
Good evening,
In the case of a numeric
   length 22 precision 1  scale 0
or length 22 precision 10 scale 0
or length 22 null null

what do you recommend for conversion?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird server resource recommendation for remote server?

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Chuck Belanger phytot...@lanset.com [firebird-support] a écrit :
> NewsReader : Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 
> Thunderbird/60.9.1
> Newsgroups : gmane.comp.db.firebird.user
> Reply-To : firebird-support@yahoogroups.com
>
> Oh, yeah. We are using FB 3+ (latest ver), 64 bit on the server.

Hello,

Being in the case, I will try to answer you even if my English is that 
of google ;-)

I have VMs win2k8 r2 6 or 8 cores and 16giga with FB3 databases of 80 
to 300 giga average on a node in Germany connected from Finland.


Points to consider in the order:

1) Network response time between client / server. Between 14ms & 30ms 
it's not bad. Attention to the network in PAT / NAT

2) Disk system, SSD is almost mandatory if you are working in native FB 
connection with forced writing.

3) Do not send a scan of the lungs in a blob native connection! use a 
micro or web service for that.

4) Query the DB via stored procedures.

5) Type of SLA of the provider.

6) Make several test from various suppliers on ipv4 wired before 
starting to work on the project

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Round the Time

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'Check_Mail' check_m...@satron.de [firebird-support] a écrit :
> Dateadd is an option or extrac t the complete time in hours and minutes, but 
> can I do this more simple?

for fun

cast(overlay( cast(cast('now' as timestamp) as char(24)) placing 
'00:' from 18 for 7) as timestamp )

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: A recommendation (database migration)

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit :
> Is this link permanent? if so, and if you agree, I can publish it at
> firebirdnews.org
>
> []s
> Carlos
> www.firebirdnews.org - www.FireBase.com.br

it can be and if there is any other problem I can fix it.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: A recommendation (database migration)

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] a écrit :
> Hi!
>
> If you have a compiled version with the fix, I think a lot of people
> would enjoy if you can share the executable ;-)

done http://tetrasys.fi/data/ibpump.7z

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: A recommendation (database migration)

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] a 
écrit :
> That’s part of the issue - I’m a Delphi guy and not sure I could get it cross 
> platform.
>
I use Delphi also but would be more interesting to start on codetyphon 
(free pascal).
we wait for another opinion.

-- 
Norbert Saint Georges
http://tetrasys.fi

[firebird-support] Re: A recommendation (database migration)

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Kevin Stanton kevin.stan...@rdb-solutions.com [firebird-support] a 
écrit :
> I would be happy to donate time to help in anyway I can. This is an awesome 
> database and I can’t say enough about FB and the developers.

Hello,

Your tool would be developed in what language? and for which platform?

-- 
Norbert Saint Georges
http://tetrasys.fi

[firebird-support] Re: Insert into Select

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

dmil...@amfes.com [firebird-support] a écrit :
> That's just an "anonymous" procedure. I suppose it is technically something a 
> client can run without having to define it in the database first - but I was 
> hoping for something using just insert & select.

I do not understand English enough to feel the finesse of your 
question.
but, if execute block does not suit you, there is always the 
possibility with merge when matched .. / when not matched then insert 
...

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Insert into Select

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

dmil...@amfes.com [firebird-support] a écrit :
> As I said - I can do this via stored procedures - but is there a way to do it 
> without?

execute block

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: FB4 embed on Centos 8.

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

> If I try embedding, I always have the error
> "operating system directive access failed -Not a folder"

For info, embed works very well under the user "root" (no error 
message).
under any other user, even having "root" rights it does not pass.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] FB4 embed on Centos 8.

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Good evening,

I'm blocking on a series of problems that you certainly have the 
solution for.

When I change the value IPv6V6Only "0 | 1" "False | True" I have a 
socket error in Firebird.log and no way to connect.

If I try embedding, I always have the error
"operating system directive access failed -Not a folder"

On Windows 7 & 10, no problem in embed but on centos8 really no way.

An idea?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: words reserved by version

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Excellent!
A big thank you for your work


>
> I put a backup of the database (Firebird 3) on 
> https://www.dropbox.com/s/ep17q5hv43iwkll/fb_reserverwords_20191112.7z?dl=0
>
> This represents the state of 7 months ago, so it might not contain 
> keywords introduced in 2.5.9 and recent Firebird 4 snapshots.
>
> Mark
> -- 
> Mark Rotteveel
>

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: words reserved by version

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

> Yes, it is in the doc folder:
> https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.keywords

I should have thought about it :-(

Thank you / Dankjewel

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] words reserved by version

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Good morning all,

Is there an exhaustive list of all the words reserved by version of 
firebird (3.x, 4.x) somewhere?

Thank you in advance.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

> /hom/Me/.software/test_only_one_tbl.fdb; found: 11.2, support 12.0"; so, I'm 
> stuck with FlameRobin: how long will it work?; and I couldn't install Red 
> Expert), with an advantage for those who subscribe (everything is 
> imaginable). 

there is a project written in pascal (turbobird 
http://code-sd.com/products/turbobird/) that runs on several 
environments and only needs to be completed. I even found it in typhoon 
code examples.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Will we move when yahoo Groups close theirs doors?

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Mark Rotteveel m...@lawinegevaar.nl [firebird-support] a écrit :
> On 2019-10-23 17:06, blackfalconsoftw...@outlook.com [firebird-support] 
> wrote:
>> Why not simply use a forum implementation, which is a better
>> technology to use for such a form of support than that of a mailing
>> list?
>
> We are using a forum right now. Yahoo Groups is both a forum (until the 
> 28th) and a mailing list. I personally prefer mailing lists, because I 
> want to get things in my mailbox, and not have to go to multiple 
> websites and read the topics there.
>
> Solutions like groups.io and Google Groups are a forum + mailing list
>
> In any case, we are currently discussing what to do in the admin group. 
> In theory staying with Yahoo Groups is an option, but as it will be 
> mailing list only that is invite-only after the 28th , that doesn't 
> really have our preference.
>
> Mark

Personally, I use news://news.gname.org to read and possibly respond to 
the mailing of different groups of Firebird.
This allows me to search for a topic on the 18713 current posts of this 
group

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

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

[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 get an error. 
>
>
 ORDER BY
   CASE :OBC
 WHEN 1 THEN MEMBERS.SURNAME
 WHEN 2 THEN MEMBERS.FIRST_NAME
   END;
   ,
   CASE :OBC
 WHEN 1 THEN  MEMBERS.FIRST_NAME
 WHEN 2 THEN  MEMBERS.SURNAME
   END;

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Firebird 2.5 embed

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Hello,

With a fbembed version 2.5, why only the icudt30.dll and icuuc30.dll do 
not respect RootDirectory parameter in firebird.conf?

there is an additional parameter to provide to the connection?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: stored procedured with insert ... returning

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

talorigo...@yahoo.co.uk [firebird-support] a écrit :
> The table does have a EMPID column defined and if I type the insert statement 
> and execute it, it does work.

eventually use return value named EMPID in the procedure

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: in new API

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
>> transaction id (= current_transaction)
>
> /* jrd\inf_pub.h

ok, we erase everything and we take the sources of UIB.
var
item : ansichar;

data: packed record
  item: AnsiChar;
  len: word;
  case byte of
0: (vByte: Byte);
1: (vSmallint: Smallint);
2: (vInteger: Integer);
3: (dummy: array[0..5] of byte);
end;
fresult : integer;
begin

 item :=ansichar(4);

 tra.getInfo(st,1,@item,sizeof(data),@data);

 if (data.item = item) then
  case data.len of
0: ;
1: fresult := data.vByte;
2: fresult := data.vSmallint;
4: fresult := data.vInteger;
else
  raise exception.Create('Unexpected data size.');
end else
  raise exception.Create('Invalid item identifier.');
works very well.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: in new API

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> transaction id (= current_transaction)

/* jrd\inf_pub.h
/*/
/* Transaction information items */
/*/

#define isc_info_tra_id 4
#define isc_info_tra_oldest_interesting 5
#define isc_info_tra_oldest_snapshot6
#define isc_info_tra_oldest_active  7
#define isc_info_tra_isolation  8
#define isc_info_tra_access 9
#define isc_info_tra_lock_timeout   10
#define fb_info_tra_dbpath  11
*/
getmem(items,8);
val := 4  ;  move(items[0],byte(val),1);
val := 5  ;  move(items[1],byte(val),1);
val := 6  ;  move(items[2],byte(val),1);
val := 7  ;  move(items[3],byte(val),1);
val := 8  ;  move(items[4],byte(val),1);
val := 9  ;  move(items[5],byte(val),1);
val := 10 ;  move(items[6],byte(val),1);
val := 11 ;  move(items[7],byte(val),1);

tra.getInfo(st,length(items),itemsptr,bufferlenght,bufferptr);

result in buffer =
3,5,0,13,21,0,0,20,3,5,0,240,21,0,0,20,3,5,0,173,21,0,0,20,3,5,0,186,21,0,0,20,3,5,0,13,21,0,0,20,3,5,0,240,21,0,0,20,3,5,0,173,21,0,0,20,3,5,0,186,21,0,0,20,3,5,0,171,21,0,0,20,1,..

either here (if I understand correctly):

 1283
 13
 335544341
 1283
 240
 335544341
 1283
 173
 335544341
 

and 335544341 is equal to ( 13,240,173,..I have not found yet) =

-901335544341   infunk  Unknown information item

ok ;-), so he must miss something but what?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: in new API

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

>>>  Almost the same way as with ISC API: use ITransaction::getInfo() and 
>>> IAttachment::getInfo()
>> I search since but can not find any info on items: byteptr.
>> in dot net sources, i found a constant isc_info_next_transaction: = 107 
>> but does not exist in firebird.pas.

>  I assumed you already know how to get this info using ISC API, seems i was 
> wrong.

Well no :-) I do tests and get things wacky or
the error number 335544341

>Anyway, below is what you are looking for:

>isc_info_attachment_id = 22
>isc_info_tra_id = 4

>All constants can be found at \include\ibase.h
a big thank you, I look here.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: in new API

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

>> and connection (= current_connection)?

>  Almost the same way as with ISC API: use ITransaction::getInfo() and 
> IAttachment::getInfo()
I search since but can not find any info on items: byteptr.
in dot net sources, i found a constant isc_info_next_transaction: = 107 
but does not exist in firebird.pas.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] in new API

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Hello,

in the new API, how to find the transaction id (= current_transaction) 
and connection (= current_connection)?

thank you in advance

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird::UtilInterfacePtr()->getPerfCounters

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> where can I find them?

ok in ../../yvalve/perf.cpp

#define TOTAL_COUNTERS 11

// we use case-insensitive names, here they are written with capital 
letters for human readability
KnownCounters knownCounters[TOTAL_COUNTERS] = {
{"RealTime", CNT_TIMER, CNT_TIME_REAL},
{"UserTime", CNT_TIMER, CNT_TIME_USER},
{"SystemTime", CNT_TIMER, CNT_TIME_SYSTEM},
{"Fetches", CNT_DB_INFO, isc_info_fetches},
{"Marks", CNT_DB_INFO, isc_info_marks},
{"Reads", CNT_DB_INFO, isc_info_reads},
{"Writes", CNT_DB_INFO, isc_info_writes},
{"CurrentMemory", CNT_DB_INFO, isc_info_current_memory},
{"MaxMemory", CNT_DB_INFO, isc_info_max_memory},
{"Buffers", CNT_DB_INFO, isc_info_num_buffers},
{"PageSize", CNT_DB_INFO, isc_info_page_size}
};

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Firebird::UtilInterfacePtr()->getPerfCounters

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Hello,

I only found that in isql.epp

const char* ISQL_COUNTERS_SET = "CurrentMemory, MaxMemory, RealTime, 
UserTime, Buffers, Reads, Writes, Fetches";

what are the other possibilities or where can I find them?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: PASCAL UDR - stored procedure BLOB param and return

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

> Anyone can point me in some direction?

the blob field is a ISC_QUADPtr
ISC_QUAD = array [1..2] of Integer;
ISC_QUADPtr = ^ISC_QUAD;

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Udr GenRows sample Pascal

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'livius' liviusliv...@poczta.onet.pl [firebird-support] a écrit :
> what kind of buffer?
> I have tried:
> ss: Array[0..199] of Char;
> ss: Array[0..199] of Byte;
> ss: Array[0..199] of AnsiChar;
> ss: String[200];

for me

var
 ss : ansistring;
begin
 try
  setlength(ss,15);

  ss := blabla...
  
move(pchar(ss)^,_outbuffer[_outmessage[0].Offset+2],_outmessage[0].length-2);

 finally
  setlength(ss,0);
 end;
end;

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Udr GenRows sample Pascal

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'livius' liviusliv...@poczta.onet.pl [firebird-support] a écrit :
> Anybody?
>
> regards,
> Karol Bieniaszewski

HI,

little bit of functional code written with codetyphon.


unit UdrCharToInet6;

{$mode delphi}

interface

uses Firebird, sysutils, sockets;

type

  Char6Procedure = class(IExternalFunctionImpl)
private
  _in, _out, _inlength, _outlength : cardinal;
  _inMessage: inmetata;
  _outMessage: outmetata;
  _inBuffer , _OutBuffer : pchar;
public
  constructor create(iin, iout, iinlength, ioutlength: cardinal; 
var inMessage: inmetata; var outMessage: outmetata);overload;
  procedure dispose(); override;
  procedure getCharSet(status: IStatus; context: IExternalContext; 
name: PChar; nameSize: Cardinal); override;
  procedure execute(status: IStatus; context: IExternalContext; 
inMsg: Pointer; outMsg: Pointer); override;
  end;


//-//

  Char6Factory = class(IUdrFunctionFactoryImpl)
private
  _in, _out, _inlength, _outlength : cardinal;
  _outMessage: outmetata;
  _inMessage: inMetata;
public
  procedure dispose(); override;
  procedure setup(status: IStatus; context: IExternalContext; 
metadata: IRoutineMetadata; inBuilder: IMetadataBuilder; outBuilder: 
IMetadataBuilder); override;
  function newItem(status: IStatus; context: IExternalContext; 
metadata: IRoutineMetadata): iExternalFunction; override;
  end;


  var
FBExcept : FbException;


implementation


constructor Char6Procedure.create( iin, iout, iinlength, ioutlength: 
cardinal; var inMessage: inmetata; var outMessage:outmetata);
   begin
 _in := iin;
 _out:= iout;
 _inlength := iinlength;
 _outlength := ioutlength;
 _inMessage := inMessage;
 _outMessage := outMessage;
 getmem(_inBuffer , _inlength);
 getmem(_outBuffer, _outlength);
 inherited create;
   end;

procedure Char6Procedure.dispose();
   begin
 freemem(_inBuffer);
 freemem(_outBuffer);
 freemem(_InMessage);
 freemem(_OutMessage);
 destroy;
   end;

procedure Char6Procedure.getCharSet(status: IStatus; context: 
IExternalContext; name: PChar; nameSize: Cardinal);
   begin
   end;

procedure Char6Procedure.execute(status: IStatus; context: 
IExternalContext; inMsg: Pointer; outMsg: Pointer);
   var
 fint6 : ansistring;
 Entry : TIn6_Addr;
 wordlen : word;
   begin
 try
   try
   setlength(fint6,48);

   _inbuffer  := pchar(inMsg);
   _outbuffer := pchar(outMsg);
   
move(_inbuffer[_inMessage[0].Offset],Entry.u6_addr16[0],_inMessage[0].length);
   fint6 := lowercase(HostAddrToStr6(Entry));
   wordlen := length(fint6);

   move(word(wordlen),_outbuffer[_outmessage[0].Offset],2);
   
move(pchar(fint6)^,_outbuffer[_outmessage[0].Offset+2],_outmessage[0].length-2);
   
move(_inbuffer[_inMessage[0].NullOffset],_outbuffer[_outMessage[0].NullOffset],2);

   finally
 setlength(fint6,0);
   end;
 except
   on e:exception do begin
 fbexcept := FbException.create(status);
 e.message :='Char to Inet6 Function.execute, '+ e.message;
 fbexcept.catchException(status,e);
 end;
 end;
   end;
  
//-//



procedure Char6Factory.dispose();
   begin
 freemem(_InMessage);
 freemem(_OutMessage);
 destroy;
   end;

procedure Char6Factory.setup(status: IStatus; context: 
IExternalContext; metadata: IRoutineMetadata; inBuilder: 
IMetadataBuilder; outBuilder: IMetadataBuilder);
   var
 inmeta, outmeta : IMessageMetadata;
 i : integer;
   begin
 try
   inMeta  := inBuilder.getMetadata(status);
   _in := inMeta.getCount(status) -1;
   _inlength := inmeta.getMessageLength(status);
   outmeta := outbuilder.getMetadata(status);
   _out:= outmeta.getCount(status)-1;
   _outlength := outmeta.getMessageLength(status);

   if ((_inlength<> 18) or (_outlength<>52)) then
 raise exception.Create('Length error between 
input('+inttostr(_inlength-2)+') and 
output('+inttostr(_outlength-2)+')');
 except
   on e:exception do begin
 fbexcept := FbException.create(status);
 e.message :='Char to Inet6 Factory.setup, OutMessage : '+ 
e.message;
 fbexcept.catchException(status,e);
 end;
 end;
 try
   setlength(_outMessage, sizeof(FBMessage)*_out+1);
   for i:=0 to _out do begin
 _OutMessage[i].FieldName   := outmeta.getField(status, i);
 _OutMessage[i].RelationName:= outmeta.getRelation(status, i);
 _OutMessage[i].OwnerName   := outmeta.getOwner(status, i);
 _OutMessage[i].AliasName   := outmeta.getAlias(status, i);
 _OutMessage[i].FBType  := outmeta.gettype(status, i);
 _OutMessage[i].isNullable  := outmeta.isNullable(status, i);
 _OutMessage[i].SubType := 

[firebird-support] Re: What is currently available ...

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Lester Caine les...@lsces.co.uk [firebird-support] a écrit :
> Nobody using Firebird for web site content?

I use firebird for the web for years with DOT NET and my code Oxygene. 
At the time I relied on Mojoportal written in C # which remains very 
good starting set.

http://www.mojoportal.com/usingfirebird.aspx

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: reset autoincrement field

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Nico Speleers - Carfac BVBA nico.spele...@carfac.com [firebird-support] 
a écrit :
> How can I reset an autoincrement field in firebird 3 ? I used identity to 
> make an autoincrement field.


  ::=
 RESTART [ WITH  ]

http://firebirdsql.org/file/documentation/release_notes/html/en/3_0/rnfb30-ddl-enhance.html

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Best way to delete millions of rows

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit :
>For that Microsoft invented "sequential GUID" quite a lot time ago.
>
>BTW: CHAR(16) CHARACTER SET OCTETS is a better way to keep GUID in 
> database.

For tables of several hundred millions of recordings, if we organize 
the first eight bytes in a less cahotic way, this will lighten Firebird 
by making it faster?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Best way to delete millions of rows

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

kragh.tho...@yahoo.com [firebird-support] a écrit :
> @Ann
> I will run some test and see what happens if the guids are generated in way 
> where the last part varies. Like this:
> 39db9ec6-178e-77b4-5d7b-d4e969b0cd98
> 39db9ec6-178e-e4ba-54ed-92347a131663
> 39db9ec6-178e-c95b-c709-a42e349410df

There would be a lot of advantage, for Firebird, in using this kind of 
guid?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: tdictionary<string,integer>

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> salut,

sorry, bad forum :-(

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] tdictionary<string,integer>

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

salut,

en dot net, une dictionnaire de 50 millions à un temps de réponse nul 
et delphi et lazarus je ne trouve rien d'identique :-(
dans l'application que je développe, ces dico's ( il y en à quatre) 
sont consultés 20 milliards de fois par passe. vous me conseilleriez 
quoi qui tiendrait le coup avec un temps null de réponse bien sur ???

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: max rows par table in FB3

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit :
>This is a hardware error, your disk is dying.

that's what I thought also, after checking the disk and repeated the 
test on other discs and on another machine, it's still the same error 
:-(

the recording limit for FB3 is the same as FB2.5?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] max rows par table in FB3

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Hello,
in the doc (2.5), I found a limit of 2^40 for the maximum number of 
records per table. why I encounter systematic error from 1.6 billion to 
FB 3.01 and FB 4 ?  ( not tried FB2.5).

the data integration continues but it is impossible to create an index 
(tried on a bigint, a char (8) bytes, a smallint) or simply take a 
count(1).

Why ?

firebird.log

"
NORPA   Thu Nov 03 10:05:12 2016
I/O error during "ReadFile" operation for file
Error while trying to read from file
Data error (cyclic redundancy check).
"

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: FB3 returning clause and new API

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Martin Schreiber mse00...@gmail.com [firebird-support] a écrit :
> On Thursday 15 September 2016 11:09:43 Dimitry Sibiryakov s...@ibphoenix.com 
> [firebird-support] wrote:
>> 15.09.2016 11:14, Martin Schreiber mse00...@gmail.com [firebird-support]  
>> wrote:
>>> What if one wants to use
>>> IAttachment.execute() where no IStatement is available?
>> 
>>(S)he must provide IMetadata built with builder.
>
> I am implementing a Firebird 3 connection component for MSEide+MSEgui (a Free 
> Pascal toolkit) so I don't know the returned data of the statements in the 
> first place.
> In case of input params I implemented an own IMessageMetadata derivate which 
> uses the type information of TParam in order to setup the metadata. In case 
> of "returning" the data type is unknown without parsing the SQL statement.
> It seems I always need to prepare the statement first?
>
> Martin
below, a bit dirty but functional code in codetyphon, reading the 
buffer is RS

unit UserData;
{$mode delphi}
{$H+}

interface

uses
  Classes, SysUtils, lNet, Firebird, DateUtils,
  Tzutil, stdctrls, fgl,
  TgzIo,
  TzDeflate,
  TzCompres,
  FBRecordU;

type
  FBSockException = class(Exception);
  TByteArray = array of byte;
  TListoutBuffer = array of TByteArray;
  buf_byte_ptr = ^buf_byte;
  buf_byte = array[0..4095] of byte;
  buf_AnsiChar = array of AnsiChar;
  buf_AnsiCharptr = ^buf_AnsiChar;

  InMessage = record
n: SmallInt;
nNull: WordBool;
end;
  OutMessage = record
relationId: SmallInt;
relationIdNull: WordBool;
relationName: array[0..93] of AnsiChar;
relationNameNull: WordBool;
  end;

  TDataEvent = procedure (Data: AnsiString) of object;

TServerObjectWorkerThread = class;
TThrdExeProc  = procedure of object;
TServerObjectWorkerThread = class(TThread)
protected
FName : String;
FStarted  : Boolean;
FThrdExeProc  : TThrdExeProc;
public
procedure Execute; override;
property  Name: String  read  FName
write FName;
property  Started : Boolean read  FStarted
write FStarted;
property  ThrdExeProc : TThrdExeProcread  FThrdExeProc
write FThrdExeProc;
end;


  TUserData = class
private
  _userdata : string;
  _asocket  : TLSocket;
  _fmemo: TMemo;
  st : IStatus;
  master : IMaster ;
  util : IUtil;
  dpb : IXpbBuilder;
  prov : IProvider;
  att : IAttachment;
  tra : ITransaction;
  stmt: IStatement;
  rs: IResultSet;
  inMetadata, outMetadata: IMessageMetadata;
  inBuffer: InMessage;
outBuffer: array of byte;
outBufferptr: ^TByteArray;
strm: TMemoryStream;
  procedure writeuserdata(fdata:String);
  procedure PrintError(s : IStatus; fmessage:string);
private
  procedure sendfirstbuffer;
  procedure senddata(fdata:ansistring);
  procedure sendSize(fint:uint);
  Procedure SendCompressedString(str: ansistring);
  Procedure SendCompressedBytes(str: tBytesStream);
  Procedure SendRecord(str : ansiString);
  Function CompressToString(str: ansistring):ansistring;
  function concatbyte(a, b: array of byte):TByteArray;
public
  constructor create(fsocket:TLSocket;amemo:tmemo);
  destructor destroy; override;
  property  userdata : string read _userdata write writeuserdata;
  const
 RAW_WBITS = 15;

  end;

implementation


{* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * 
* * *}
procedure TServerObjectWorkerThread.Execute;

begin

end;


constructor TUserData.create(fsocket:TLSocket; amemo:TMemo);
begin
_asocket := fsocket;
_asocket.SetState(ssNoDelay,true);
_fmemo   := amemo;
_userdata := '';
strm := TMemoryStream.create;
end;
destructor TUserData.destroy;
begin
   if att<> nil then
att.detach(st);
att := nil;
   if dpb <> nil then
dpb.dispose;
dpb := nil;
   if prov <> nil then
prov.release;
   prov := nil;
   if st <> nil then begin
st.dispose();
   end;
   st := nil;
   if util<> nil then
   util := nil;
   if master<>nil then
   master := nil;
   _userdata:='';
   if inMetadata <> nil then
   inMetadata := nil;
   if outMetadata <> nil then
   outMetadata := nil;
   _asocket.UserData:=nil;
   if strm<> nil then
   freeandnil(strm);
   inherited destroy;
end;

procedure TUserdata.PrintError(s : IStatus; fmessage:string);
var
maxMessage : Integer;
outMessage : PAnsiChar;
begin
maxMessage := 256;
outMessage := StrAlloc(maxMessage);
util.formatStatus(outMessage, maxMessage, s);
_fmemo.Append(concat(outMessage,#13#10,fmessage));

[firebird-support] Re: Error while parsing procedure procname's BLR

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] a écrit :
> That's a very bad idea. Whole server rely on fbclient.dll with exactly that 
> name.

true. renaming in fbclient.dll, I do not have this error.
yet I called the master interface with the code:
<--
function fb_get_master_interface : IMaster; cdecl; external 
'myfbclient';
-->

it's not a bad idea to work hard?
I have all versions (almost) 1.0 to 4.0 on my machine with their 
renowned dll and this only works like this.

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Error while parsing procedure procname's BLR

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Mark Rotteveel m...@lawinegevaar.nl [firebird-support] a écrit :
> BTW: I believe "CHARACTER SET ISO8859_1 is not installed" can occur if
> you don't have the intl folder in your install.

Thank you for your reply.

true, that without IXpbBuilder (DPB), attachment is done well :-)

my exe is in the root folder of the FB and I renamed fbclient in 
myfbclient to be sure to take the right version.
the itl directory is there

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Error while parsing procedure procname's BLR

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

-CHARACTER SET ISO8859_1 is not installed
X-Newsreader: MesNews/1.08.05.00

I try to connect embedded mode via master interface with the code 
(Pascal).
<--
master := fb_get_master_interface;
util   := master.getUtilInterface;
st := master.getStatus;
prov   := master.getDispatcher;
dpb:= util.getXpbBuilder(st, IXpbBuilder.DPB, nil, 0);
dpb.insertInt(st, isc_dpb_page_size, 4 * 1024);
dpb.insertString(st,isc_dpb_set_db_charset,'ISO8859_1');
dpb.insertInt(st,isc_dpb_set_db_sql_dialect,3);
att := prov.attachDatabase(st, DBPath, dpb.getBufferLength(st), 
dpb.getBuffer(st));
tra := att.startTransaction(st, 0, nil);
stmt := att.prepare(st, tra, 0,
'select * from 
PS_RM_CUST_FROM_ISO2_CP_LANG2(''FI'',''02540'',''FI'')' ,
3, IStatement.PREPARE_PREFETCH_METADATA);
-->
I get this error message.
I've forgotten what?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] fb_get_master_interface, cursor fetchPrior, fetchLast =feature is not supported

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

it's normal ?

and fetchNext no return entire result before isEof(master.getStatus)
why ?

for a set of result of over 100 records it must use something other 
than a cursor ?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Firebird 3.0 - invalid transaction handle (expecting explicit transaction start).

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

I have the same problem without being able to identify or reproduce.

My background, dot net WebForm with Firebird 3.0, when multiple update 
via multiple threads on the same record.

See if this is the same context for you?

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit :
>> 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit :
>>> trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44:
>>> 
 Where I can download v3.0.1 ?
>>> 
>>> 3.0.1 hasn't been released yet, but snapshot builds are available here:
>>> http://www.firebirdsql.org/en/snapshot-builds/
>>> 
>> 
>> the link is dead 
>
> Works here. I get the entry page regarding snapshot builds for all branches 
> and Windows/Linux. Anyway ... ;-)
>
>> http://web.firebirdsql.org/download/snapshot_builds/win/3.0
>
>
> Thomas
>
(www.) me too :-).
but the final address (web.firebirdsql.org) is currently dead from 
Finland and Germany

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: Max RAM for Database Cache in SS FB 3.0 64bit is to small?

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] a écrit :
> trsk...@yahoo.com [firebird-support] schrieb am 02.06.2016 06:44:
>
>> Where I can download v3.0.1 ?
>
> 3.0.1 hasn't been released yet, but snapshot builds are available here:
> http://www.firebirdsql.org/en/snapshot-builds/
>

the link is dead 
http://web.firebirdsql.org/download/snapshot_builds/win/3.0

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: An SQL query perform badly after firebird database file size grow beyond 8GB

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

cyc...@gmail.com [firebird-support] a écrit :
>
>  Is this an issue related to Windows file system? Firebird service or my 
> query?

for test :

  SELECT MAX(A.PostDate) MaxPostDate from (
  select a.postdate
  FROM SL_CS A, SL_CSDTL B
  WHERE A.DocKey=B.DocKey
AND A.Code='300-10001'
AND B.ItemCode='OCC'
AND B.UOM='UNIT'
AND A.Cancelled='F'
AND B.UnitPrice<>0)

-- 
Norbert Saint Georges
http://tetrasys.fi







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

[firebird-support] Re: How to do a running total in SQL

[Norbert Saint Georges n...@tetrasys.eu [firebird-support]]

Hi,
execute block
returns  (reference varchar(10), due double precision, balance double 
precision)
as
begin
balance = 0;
for select
reference,due
from invoices  into :reference, :due
do begin
balance = balance+due;
suspend;
end
end

Norbert







++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

RE: Re: [firebird-support] How To Get Entire Linked Group Details

['Norbert Saint Georges' n...@tetrasys.eu [firebird-support]]

if I understand the request, something like

 

select b.description from

(

select a.* from mygroup a

where  a.linked_to_group is not null

and

(

exists(select 1 from mygroup b  where  b.linked_to_group = a.pk_group )

or a.linked_to_group != (select first 1 pk_group from mygroup where 
linked_to_group is null)

)

) b

where b.linked_to_group = (select first 1 pk_group from mygroup where 
description = 'Vishal Group')

 

 

   Norbert Saint Georges

 

   TetraSys Oy

   Bergantie 69, FI-02540 Kylmälä

   Tel. : +358 (0) 400 27 25 18

   E- mail : n...@tetrasys.fi <mailto:taru.kaukova...@tetrasys.eu> 

 

De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Envoyé : lundi 5 octobre 2015 11:15
À : firebird-support@yahoogroups.com
Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details

 

  

Hi Norbert,

 

The SQL you have shared without CTE, gives me other group details as well if 
they exists. If you create another base group like 'Vishal Group', then this 
SQL gives that group details as well. I tried but putting group name in 
condition but getting only one record, could you show me how to get only 
'Vishal Group' records, so that would also a good learning for me.

 

 

Thanks In Advance.

 

With Best Regards.

 

Vishal

 

 

On Friday, 2 October 2015 6:57 PM, "'Norbert Saint Georges' n...@tetrasys.eu 
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

 

  

Without CTE

 

select a.description from mygroup a

where a.linked_to_group is not null

and

(

exists(select 1 from mygroup b  where  b.linked_to_group = a.pk_group )

or

a.linked_to_group != (select first 1 pk_group from mygroup where 
linked_to_group is null)

)

 

 

   Norbert Saint Georges

 

   TetraSys Oy

   Bergantie 69, FI-02540 Kylmälä

   Tel. : +358 (0) 400 27 25 18

   E- mail : n...@tetrasys.fi <mailto:taru.kaukova...@tetrasys.eu> 

 

De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Envoyé : vendredi 2 octobre 2015 15:24
À : firebird-support@yahoogroups.com
Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details

 

  

 

Hi Karol Bieniaszewski,

 

You are passing "Vishal Group1" in condition, I need to pass "Vishal Group" 
(i.e. base leaf for perticular group), because in the sql you provided if I put 
'Test1', it gives entire structure details, one way that is correct, but only i 
need is to pass required base group as in the condition and not any sub-leaf in 
condition, could you please modify it ?

 

Thanks Again In Advance.

 

With Best Regards.

 

Vishal

 

 

On Friday, 2 October 2015 5:23 PM, "Vishal Tiwari vishuals...@yahoo.co.in 
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

 

  

Hi Karol Bieniaszewski,

 

 

Yess, YOU ARE THE MAN OF THE MOMENT. 

 

Your SQL just ROCKS, JUST ROCKS. AWESOME KAROL, JUST AWESOME.

 

 

I am going to next level of my code where I need to find out that the deepest 
leaf, if it is not used in certain table then I would like to delete it.

 

For time being one more questions (Please expect more in upcoming time on this 
issue :) ), is it possible to get the records for one entire leaf and it 
dependent leafs and then another leaf and its dependent and so on via your SQL ?

 

 

Result order like:

 

Vishal Group 

Vishal Group1

Vishal Group1.1

Vishal Group1.1.1

Vishal Group2

Vishal Group2.1

Vishal Group2.1.1

Vishal Group3

Vishal Group4

Vishal Group4.1

 

 

With Best Regards.

 

Vishal

 

 

 

On Friday, 2 October 2015 4:59 PM, "liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

 

  

Hi,

 

i do not know if you describe your problem precisely.

But i understand it like this:

looks like you need all leaf from same parent (with parent included) as is for 
"Vishal Group1" and all its childs

 

try this

 

 WITH RECURSIVE

 G1_PARENT AS

 (

 SELECT MGP.DESCRIPTION FROM MYGROUP MG INNER JOIN MYGROUP MGP ON 
MGP.PK_GROUP=MG.LINKED_TO_GROUP WHERE MG.DESCRIPTION='Vishal Group1'

 ),

  R_TREE AS 

 ( 

 SELECT TT.PK_GROUP AS A, CAST(CASE WHEN TT.DESCRIPTION=GP.DESCRIPTION THEN 
GP.DESCRIPTION ELSE '' END AS VARCHAR(255)) AS PARENT  

 FROM MYGROUP TT LEFT JOIN G1_PARENT GP ON 1=1

 WHERE TT.LINKED_TO_GROUP IS NULL 

 

 UNION ALL 

  

 SELECT TT.PK_GROUP AS A, CASE WHEN TT.DESCRIPTION=GP.DESCRIPTION THEN 
GP.DESCRIPTION ELSE RT.PARENT END AS PARENT

 FROM MYGROUP TT LEFT JOIN G1_PARENT GP ON 1=1

 JOIN R_TREE RT ON RT.A = TT.LINKED_TO_GROUP

 ) 

 SELECT 

 * 

  

 FROM 

 R_TREE RT2 

 INNER JOIN G1_PARENT GP ON RT2.PARENT=GP.DESCRIPTION 

 INNER JOIN MYGROUP TT2 ON TT2.PK_GROUP=RT2.A 

 

with this query i got the same result as you showed in table below 

 

regards,

Karol Bieniaszewski

 

 

W dniu 2015-10-02 06:36:16 użytkownik Vishal Tiw

RE: Re: [firebird-support] How To Get Entire Linked Group Details

['Norbert Saint Georges' n...@tetrasys.eu [firebird-support]]

Without CTE

 

select a.description from mygroup a

where a.linked_to_group is not null

and

(

exists(select 1 from mygroup b  where  b.linked_to_group = a.pk_group )

or

a.linked_to_group != (select first 1 pk_group from mygroup where 
linked_to_group is null)

)

 

 

   Norbert Saint Georges

 

   TetraSys Oy

   Bergantie 69, FI-02540 Kylmälä

   Tel. : +358 (0) 400 27 25 18

   E- mail : n...@tetrasys.fi  

 

De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Envoyé : vendredi 2 octobre 2015 15:24
À : firebird-support@yahoogroups.com
Objet : Re: Re: [firebird-support] How To Get Entire Linked Group Details

 

  

 

Hi Karol Bieniaszewski,

 

You are passing "Vishal Group1" in condition, I need to pass "Vishal Group" 
(i.e. base leaf for perticular group), because in the sql you provided if I put 
'Test1', it gives entire structure details, one way that is correct, but only i 
need is to pass required base group as in the condition and not any sub-leaf in 
condition, could you please modify it ?

 

Thanks Again In Advance.

 

With Best Regards.

 

Vishal

 

 

On Friday, 2 October 2015 5:23 PM, "Vishal Tiwari vishuals...@yahoo.co.in 
[firebird-support]"  wrote:

 

  

Hi Karol Bieniaszewski,

 

 

Yess, YOU ARE THE MAN OF THE MOMENT. 

 

Your SQL just ROCKS, JUST ROCKS. AWESOME KAROL, JUST AWESOME.

 

 

I am going to next level of my code where I need to find out that the deepest 
leaf, if it is not used in certain table then I would like to delete it.

 

For time being one more questions (Please expect more in upcoming time on this 
issue :) ), is it possible to get the records for one entire leaf and it 
dependent leafs and then another leaf and its dependent and so on via your SQL ?

 

 

Result order like:

 

Vishal Group 

Vishal Group1

Vishal Group1.1

Vishal Group1.1.1

Vishal Group2

Vishal Group2.1

Vishal Group2.1.1

Vishal Group3

Vishal Group4

Vishal Group4.1

 

 

With Best Regards.

 

Vishal

 

 

 

On Friday, 2 October 2015 4:59 PM, "liviuslivius liviusliv...@poczta.onet.pl 
[firebird-support]"  wrote:

 

  

Hi,

 

i do not know if you describe your problem precisely.

But i understand it like this:

looks like you need all leaf from same parent (with parent included) as is for 
"Vishal Group1" and all its childs

 

try this

 

 WITH RECURSIVE

 G1_PARENT AS

 (

 SELECT MGP.DESCRIPTION FROM MYGROUP MG INNER JOIN MYGROUP MGP ON 
MGP.PK_GROUP=MG.LINKED_TO_GROUP WHERE MG.DESCRIPTION='Vishal Group1'

 ),

  R_TREE AS 

 ( 

 SELECT TT.PK_GROUP AS A, CAST(CASE WHEN TT.DESCRIPTION=GP.DESCRIPTION THEN 
GP.DESCRIPTION ELSE '' END AS VARCHAR(255)) AS PARENT  

 FROM MYGROUP TT LEFT JOIN G1_PARENT GP ON 1=1

 WHERE TT.LINKED_TO_GROUP IS NULL 

 

 UNION ALL 

  

 SELECT TT.PK_GROUP AS A, CASE WHEN TT.DESCRIPTION=GP.DESCRIPTION THEN 
GP.DESCRIPTION ELSE RT.PARENT END AS PARENT

 FROM MYGROUP TT LEFT JOIN G1_PARENT GP ON 1=1

 JOIN R_TREE RT ON RT.A = TT.LINKED_TO_GROUP

 ) 

 SELECT 

 * 

  

 FROM 

 R_TREE RT2 

 INNER JOIN G1_PARENT GP ON RT2.PARENT=GP.DESCRIPTION 

 INNER JOIN MYGROUP TT2 ON TT2.PK_GROUP=RT2.A 

 

with this query i got the same result as you showed in table below 

 

regards,

Karol Bieniaszewski

 

 

W dniu 2015-10-02 06:36:16 użytkownik Vishal Tiwari vishuals...@yahoo.co.in 
[firebird-support]  napisał:

  

Hi All,

 

There is some change in my previous SQL. Please consider below SQLs.

 

CREATE TABLE MYGROUP 

(

  PK_GROUP GUID DEFAULT 'newid()' NOT NULL,

  DESCRIPTION Varchar(255),

  LINKED_TO_GROUP GUID,

  PRIMARY KEY (PK_GROUP)

);

 

COMMIT;

 

INSERT INTO MYGROU P (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES 
('{-111---} ', 'My Items', NULL);

 

 

INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES 
('{CD1E33D1-1666-49B9-83BE-067687E4DDD6}', 'Vishal Group', 
'{-111---}');

 

INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES 
('{4B42E7A5-B14C-451B-ACF5-83DD8A983A58}', 'Vishal Group1', 
'{CD1E33D1-1666-49B9-83BE-067687E4DDD6}');

IN SERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES 
('{A87E921D-0468-497D-92C5-19AB63751EE8}', 'Vishal Group1.1', 
'{4B42E7A5-B14C-451B-ACF5-83DD8A983A58}');

INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES 
('{0FDC729A-8FCC-4D23-8619-436A459835DD}', 'Vishal Group1.1.1', 
'{A87E921D-0468-497D-92C5-19AB63751EE8}');

 

INSERT INTO MYGROUP (PK_GROUP, DESCRIPTION, LINKED_TO_GROUP) VALUES 
('{2E15A2A9-7E40-422E-A5D6-C3F6C63F8591}', 'Vishal Group2', 

RE: [firebird-support] Firebird 3.0 Development Admin Tools

['Norbert Saint Georges' n...@tetrasys.eu [firebird-support]]

I use it for some months IBExpert http://www.ibexpert.net/ibe/  Firebird 3

 

 

Platform:

 

Windows 2000, Windows XP x32, Windows Server 2003 x32, XP Tablet PC, Windows XP 
x64, Windows Server 2003 x64, Windows Vista x32, Windows Server 2008, Windows 
Vista x64, Windows 7 x32, Windows 7 x64, Windows Server 2008 R2, Windows 8

Version:

 

2015

Language:

 

English, German, Portuguese, Spanish, Italian, French, Dutch, Japanese, 
Russian, Polish, Czech, Hungarian

 

 

 

   Norbert Saint Georges

 

   TetraSys Oy

   Bergantie 69, FI-02540 Kylmälä

   Tel. : +358 (0) 400 27 25 18

   E- mail : n...@tetrasys.fi mailto:taru.kaukova...@tetrasys.eu 

 

De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] 
Envoyé : jeudi 15 janvier 2015 16:02
À : firebird-support@yahoogroups.com
Objet : [firebird-support] Firebird 3.0 Development  Admin Tools

 

  

Hi,

 

I've to develop a new application which will be launched not before end of 
year. So I thought it's best to go for the 3.0 release (still in Beta, I know). 
But till the end of the year I assume 3.0 will be launched.

 

Nevertheless: I need a tool to maintain / develop the database. In the past I 
used sql manager for interbase firebird. But it's not supporting 3.0 yet. Any 
advice, which tools are able to handle 3.0 databases?

 

BR
Christoph