Re: [Firebird-devel] how to declare a decfloat (16) with a scale of zero for a column GENERATED BY DEFAULT AS IDENTITY

2019-12-16 Thread Pierre Y.
> BTW: Such an extremely high part-number seems rather odd, and could > indicate those numbers encode additional information, which may indicate > this should be a string anyway. > Could these number be GUID encoded as Int128 ? If so they could be stored as CHAR(16) CHARACTER SET OCTETS Firebird-D

Re: [Firebird-devel] Firebird 3, time to rename conflict names ?

2012-11-18 Thread Pierre Y.
ird Tools) is not so, or, more longer but hard to steal "firebird" ! : firebird-backup firebird-stats firebird-preprocess firebird-lockprint ... And a "firebird" wrapper so we can call things like : "firebird backup", "firebird stats", "firebird preproce

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-3715) EXTRACT(YEAR_FOR_WEEK from '2012-01-01')

2012-01-03 Thread Pierre Y.
>> The first week of a year is, by convention, the first week that contains >> the first Tuesday of the year. > For example, according to ISO 8601 I think the first week of a year is > the first week that has four or more days on the new year. > This seems to contradict what Pierre wrote above.

Re: [Firebird-devel] Firebird Transaction ID limit solution

2011-12-28 Thread Pierre Y.
On Wed, Dec 28, 2011 at 5:34 PM, Yi Lu wrote: > It is feasible to roll over the transaction ID without putting the database > offline? i.e. when ID is close to limit, reset it to 0 from the code? Seems that PostgreSQL AutoVacuum daemon do that for Postgresql databases : http://www.postgresql.org

[Firebird-devel] Using the Firebird 3.0 API with Delphi

2011-12-12 Thread Pierre Y.
Hi All, Thanks to Vlad, we achieved the translation of the FB3 OO API in UIB Components for Delphi. You can checkout the code from SourceForge repository : https://uib.svn.sourceforge.net/svnroot/uib/trunk Now, we only miss hints to deal with FbMessage, it seems that the examples (fbstuff on gi

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Pierre Y.
>> I'm very interrested in seeing how to use the new Firebird OO API in >> Delphi. We gave it a try two weeks ago and we only succeeded with the >> getVersion() function ! Everything else generated errors or access >> violations. > >    Could you send to me your Delphi wrapper for the API ?  I'll l

Re: [Firebird-devel] Database shutdown when udf raises an exception

2011-12-07 Thread Pierre Y.
>>> I expect the "Delphi people" will work on it. >> >>   No way, I'm afraid. I'm quite good in Delphi, but I have no idea how to >> convert C++ >> classes to Delphi classes. > >    I can help. I'm very interrested in seeing how to use the new Firebird OO API in Delphi. We gave it a try two weeks

Re: [Firebird-devel] The new Firebird OO API

2011-12-02 Thread Pierre Y.
>> I advanced a bit more with this new API but I just absolutely don't >> see how to deal with FbMessage. What is it ? How do I have to use it >> to access (or send ?) data ? >> >> > https://github.com/asfernandes/fbstuff/blob/master/src/test/v3api/StaticMessageTest.cpp Thank you Adriano. I think

Re: [Firebird-devel] The new Firebird OO API

2011-12-01 Thread Pierre Y.
Hi, I advanced a bit more with this new API but I just absolutely don't see how to deal with FbMessage. What is it ? How do I have to use it to access (or send ?) data ? Thank you for your help, Regards, -- Pierre Yager --

Re: [Firebird-devel] The new Firebird OO API

2011-11-29 Thread Pierre Y.
I think very strange to still have to build DPB by hand... Can you expose something that may give access to the ClumpletWriter to ease that ? >>> Probably it's worth thinking about it, but IMHO building parameters >>> block is not critical from API point of view. >> But it does add t

Re: [Firebird-devel] The new Firebird OO API

2011-11-28 Thread Pierre Y.
ess to the ClumpletWriter to ease that ? At least, I can create and drop a database ;-) But I would be able to set up more complex fields like the default dialect, the page size and the default character set. Regards, -- Pierre Yager On Mon, Nov 28, 2011 at 8:55 PM, Pierre Y. wrote: >> g++ -Wall -I.

Re: [Firebird-devel] The new Firebird OO API

2011-11-28 Thread Pierre Y.
> g++ -Wall -I../../src/include -lfbclient -o libUdrCppExample.so -fPIC > UdrCppExample.cpp ../../gen/Debug/firebird/plugins/libudr_engine.so -shared Thank you Alex for the answer. It compiled ! I don't know how to test if it works, but it compiled ;-) Next I want to compile a VERY simple piece o

[Firebird-devel] The new Firebird OO API

2011-11-27 Thread Pierre Y.
Hi all, If I understood well the conference about Providers, Plugins and new OO API from Alex this week-end at the Firebird Conference, all we have to do to enter the new OO API is to find the new fb_get_master_interface method and play with the new IMaster interface ? Well. I found the fb_get_ma