[firebird-support] Storing headings and paragraphs in a Firebird database

2013-06-06 Thread certfb
This is probably a question for Stack Overflow, but I would like a Firebird specific answer so asking here. I would like to store simple documents in a Firebird database as an ordered collection of paragraphs as follows: Document 1 Record 1 - 1. Heading 1 Record 2 - 1.1 Heading 2 Record 3 -

[firebird-support] Re: Storing headings and paragraphs in a Firebird database

2013-06-06 Thread certfb
Thank you Andre, this is exactly what I was looking for! Processing the hierarchy within one document is very easy using a recursion. Could I ask how you have implemented the recursion - i.e. in the client, using a CTE or with a stored procedure? The reason for asking is that AFAIK

[firebird-support] Re: Storing headings and paragraphs in a Firebird database

2013-06-06 Thread certfb
Thank you very much for taking the time to explain this in such clear detail. This virtually means I have one query sent to the FB server for each hierarchy level, constrained to paragraphs having the current paragraph as parent (WHERE IDParent = :IDThisParagraph...). Can I ask,

[firebird-support] Re: Storing headings and paragraphs in a Firebird database

2013-06-06 Thread certfb
I have an extra column for the position within one and the same hiararchy. Thanks, I will try to do something similar. I will play around with this for a little while now!

[firebird-support] Re: GUI version of FB Trace Manager (fbtracemgr)

2013-04-08 Thread certfb
The only problem that I have at the moment is that I am using the isc_info_svc_timeout command as part of a isc_info_svc_line isc_service_query() but instead of replying with isc_info_svc_timeout in the header the server replies with isc_info_svc_line but a zero length

[firebird-support] Re: GUI version of FB Trace Manager (fbtracemgr)

2013-04-08 Thread certfb
--- In firebird-support@yahoogroups.com, certfb miker169@... wrote: The only problem that I have at the moment is that I am using the isc_info_svc_timeout command as part of a isc_info_svc_line isc_service_query() but instead of replying with isc_info_svc_timeout

[firebird-support] GUI version of FB Trace Manager (fbtracemgr)

2013-04-07 Thread certfb
Hello list! I have implemented a very simple GUI version of the bundled trace tool fbtracemgr using wxWidgets. If anyone is interested I am more than happy to upload or send them the code. If I get the chance I will try to write a blog because some aspects of the trace API take a bit of

[firebird-support] Re: GUI version of FB Trace Manager (fbtracemgr)

2013-04-07 Thread certfb
The only problem that I have at the moment is that I am using the isc_info_svc_timeout command as part of a isc_info_svc_line isc_service_query() but instead of replying with isc_info_svc_timeout in the header the server replies with isc_info_svc_line but a zero length data block.

[firebird-support] Re: fbtracemgr and embedded

2013-03-15 Thread certfb
since v2.5 it is possible to use Firebird embedded without install of full CS package. All you need is to create the almost the same folders layout as with full Firebird package, including bin, intl, lib, plugin, UDF folders and its contents. Create simlink lib/libfbembed.so.2.5

[firebird-support] Re: fbtracemgr and embedded

2013-03-10 Thread certfb
Sorry for the (possibly) silly question, but is it possible to use fbtracemgr with the embedded server? Yes Thank you for your answers, that is great news. By the way my purpose for using tracing is to be able to see a how parametrised selects created with IBPP are resolved.

[firebird-support] Re: fbtracemgr and embedded

2013-03-10 Thread certfb
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: Sorry for the (possibly) silly question, but is it possible to use fbtracemgr with the embedded server? Yes Thank you for your answers, that is great news. By the way my purpose for using tracing is