Re: [firebird-support] Re: FB 3 embedded on Windows 7 64 bit
On 10.03.2017 15:35, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In firebird-support@yahoogroups.com, wrote : > > >> Are ther other possibilities to set the Firebird path than setting >> %FIREBIRD%? A parameter to attachDatabase() maybe? > > SetEnvironmentVariable. > > > https://msdn.microsoft.com/en-us/library/windows/desktop/ms686206(v=vs.85).aspx > > Use it before attempt to establish very first connection, or before > attempt to load fbclient.dll (if it is possible in your app). > So setting FIREBIRD environment variable is the correct and only way to define the Firebird/plugin path at runtime? Martin
[firebird-support] Re: FB 3 embedded on Windows 7 64 bit
On 10.03.2017 08:41, Martin Schreiber wrote: > Hi, > I want to use FB 3 in embedded mode in an application: > https://gitlab.com/mseide-msegui/mseuniverse/wikis/msekicadbom/MSEkicadBOM > (under construction). > It works well on Linux. On Windows 7 64 bit I installed > Firebird-3.0.1.32609_0_x64.exe > When I set %FIREBIRD% to the FB install directory connecting the database by > attachDatabase() shows the error > " > unavailable database > ". Got it working, there was a problem with the file path. Are ther other possibilities to set the Firebird path than setting %FIREBIRD%? A parameter to attachDatabase() maybe? Martin
[firebird-support] FB 3 embedded on Windows 7 64 bit
Hi, I want to use FB 3 in embedded mode in an application: https://gitlab.com/mseide-msegui/mseuniverse/wikis/msekicadbom/MSEkicadBOM (under construction). It works well on Linux. On Windows 7 64 bit I installed Firebird-3.0.1.32609_0_x64.exe When I set %FIREBIRD% to the FB install directory connecting the database by attachDatabase() shows the error " unavailable database ". Without %FIREBIRD% it shows " Unable to complete network request to host "windowsmse". -Failed to locate host machine. -The specified name was not found in the hosts file or Domain Name Services. " What could be wrong? Thanks, Martin
[firebird-support] FB3, documentation of parameter tags?
Hi, I'm looking for the documentation of valid parameter block tags for IProvider.attachDatabase(), createDatabase() and IAttachment().startTransaction(). Does it exist? Thanks, Martin
Re: [firebird-support] Re: FB3 returning clause and new API
On Thursday 15 September 2016 15:06:58 'Mark Rotteveel' m...@lawinegevaar.nl
[firebird-support] wrote:
> You either need to generate the necessary metadata yourself, but then you
> either have to guess, or have the user provide the type. You can't use
> openCursor as insert ... returning doesn't have a cursor; just like an
> executable procedure it has a single result that is returned on execute.
>
Does calling IAttachment.prepare() in order to get the output message metadata
produce a performance penalty, expecially an additional server roundtrip? I
assume so. The format of the received data must be known in FB-client library
when the data arrives, so it should be possible to provide an
IMessageMetadata after execute().
A very comfortable solution would be when openCursor() would work for all
statement types because of the problem that it is not known if openCursor()
or execute() must be called before parsing the SQL statement in user code or
preparing the statement.
It seems that calling openCursor() with
"
insert into TABLE1 (STR1) values ('aabbccdd') returning PK
"
actually returns a valid IMessageMetadata by IResultSet.getMetadata(). What
apparentely not works is fetchNext()...
Martin
Re: [firebird-support] Re: FB3 returning clause and new API
On Thursday 15 September 2016 12:25:31 Norbert Saint Georges n...@tetrasys.eu
[firebird-support] wrote:
>
> below, a bit dirty but functional code in codetyphon, reading the
> buffer is RS
>
Thanks, but do I read the code correct, that you also use
IAttachment.prepare() in order to get the messagemetadata? Does this cause an
additional server roundtrip?
With IAttachment.execute() there is no messagemetadata available and with the
statement
"
insert into TABLE1 (STR1) values ('aabbccdd') returning PK
"
IAttachment.openCursor() seems not to work.
Martin
Re: [firebird-support] FB3 returning clause and new API
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 ++ 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: [firebird-support] FB3 returning clause and new API
On Thursday 15 September 2016 10:29:27 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 15.09.2016 10:16, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > > And then how to get the data? > >Last two parameter of the methods is an output message where output data > is returned in. Signature of execute in firebird.pas is: " function execute(status: IStatus; transaction: ITransaction; inMetadata: IMessageMetadata; inBuffer: Pointer; outMetadata: IMessageMetadata; outBuffer: Pointer): ITransaction; " A value for outMetadata probably is available by IStatement.getOutputMetadata(). What if one wants to use IAttachment.execute() where no IStatement is available? How can one know if IAttachment.execute() or IAttachment.openCursor() must be called without having IStatement.getFlags() from a prepared statement other than parsing the SQL statement in user code? Does IAttachment.prepare() involve a server roundtrip? Thanks for your patience. Martin ++ 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: [firebird-support] FB3 returning clause and new API
On Thursday 15 September 2016 09:01:04 Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 15.09.2016 7:56, Martin Schreiber mse00...@gmail.com [firebird-support] wrote: > > How the values of a returning clause can be fetched with OOP-API? > >Use IAttachment::execute() for single execution of queries without > parameters and IStatement::execute() for the rest. And then how to get the data? Is using openCursor() not possible so one does not need to know if it is a SELECT or another statement? Martin ++ 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] FB3 returning clause and new API
Hi,
How the values of a returning clause can be fetched with OOP-API?
Example:
"
insert into TABLE1 (STR1) values ('aabbccdd') returning PK
"
Martin
Re: [firebird-support] Re: Which ICU version for Firebird 3.0
On Thursday 01 September 2016 15:58:23 Martin Schreiber wrote: > On Thursday 01 September 2016 15:23:53 Dmitry Yemanov > > dim...@users.sourceforge.net [firebird-support] wrote: > > 01.09.2016 12:15, Martin Schreiber wrote: > > > In order to implement Firebird 3.0 support in MSEide+MSEgui I try to > > > build and install Firebird on a OpenSUSE 13.1 X86 system. "make" > > > returns the error: " > > > Could not find acceptable ICU library > > > " > > > Which ICU version is "acceptable"? > > > > Default ICU version for v3.0 is 5.2. > > ICU version 52.1-55.1 is installed, should this work? Which ICU files are > searched and where are they searched by v3.0? > For the record: It was necessary to build ICU 5.2.1 from source, the RPM package did not work. Martin ++ 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] How to install Firebird 3.0 on Linux?
Hi, What is the recommended way to install Firebird 3.0 on OpenSUSE 13.1 X86? The script "install.sh" from https://sourceforge.net/projects/firebird/files/firebird-linux-i386/3.0-Release/Firebird-3.0.0.32483-0.i686.tar.gz/download stops with the errormessage: " unable to open database Could not find acceptable ICU library " Thanks, Martin
Re: [firebird-support] Re: Which ICU version for Firebird 3.0
On Thursday 01 September 2016 15:23:53 Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > 01.09.2016 12:15, Martin Schreiber wrote: > > In order to implement Firebird 3.0 support in MSEide+MSEgui I try to > > build and install Firebird on a OpenSUSE 13.1 X86 system. "make" returns > > the error: " > > Could not find acceptable ICU library > > " > > Which ICU version is "acceptable"? > > Default ICU version for v3.0 is 5.2. > ICU version 52.1-55.1 is installed, should this work? Which ICU files are searched and where are they searched by v3.0? Martin ++ 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] Which ICU version for Firebird 3.0
Hi, In order to implement Firebird 3.0 support in MSEide+MSEgui I try to build and install Firebird on a OpenSUSE 13.1 X86 system. "make" returns the error: " Could not find acceptable ICU library " Which ICU version is "acceptable"? Thanks, Martin
[firebird-support] Re: How to know the ICU version of a collation in a database
On 08/03/2016 05:21 PM, Martin Schreiber wrote: > Hi, > Since an online update on my OpenSUSE Leap 42.1 I get the well known > error "COLLATION UNICODE_CI for CHARACTER SET UTF8 is not installed". > I assume that something changed with the ICU libraries. > How can one find out the used ICU library version of a database? > For the record: I assume that I actually did not run the OpenSUSE installed firebird version before but a version I compiled myself with ICU 3.0 default and that OpenSUSE restored the original startscript. I could fix the issue by copying the ICU 3.0 library files libicudata.so.30 libicudata.so.30.0 libicui18n.so.30 libicui18n.so.30.0 libicuuc.so.30 libicuuc.so.30.0 from the self compiled Firebird version to /usr/lib64 and to change /usr/lib64/firebird/intl/fbintl.conf " icu_versionsdefault " to " icu_versionsdefault 3.0 " I am still interested how one can find out the used ICU version (or versions?) of a database file. BTW, I am the author of the very sophisticated and very unknown cross platform development environment MSEide+MSEgui for Free Pascal which has excellent Firebird support - I think. ;-) https://sourceforge.net/projects/mseide-msegui/ Martin
[firebird-support] How to know the ICU version of a collation in a database
Hi, Since an online update on my OpenSUSE Leap 42.1 I get the well known error "COLLATION UNICODE_CI for CHARACTER SET UTF8 is not installed". I assume that something changed with the ICU libraries. How can one find out the used ICU library version of a database? Thanks, Martin
[firebird-support] How to know the ICU version of a collation in a database
Hi, Since an online update on my OpenSUSE Leap 42.1 I get the well known error "COLLATION UNICODE_CI for CHARACTER SET UTF8 is not installed". I assume that something changed with the ICU libraries. How can one find out the used ICU library version of a database? Thanks, Martin
