Hi,
FB4
iso8859_1
With a varchar(32765) field, the API returns a nullOffset outside the
buffer length and the next field gives me an offset identical to the
nullOffset of the previous field.
Did I miss something?
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list
Dimitry Sibiryakov a écrit :
Norbert Saint Georges wrote 23.09.2022 7:26:
which version should be used and in which case should one or the other be
used?
decodeTimeTz is used for ISC_TIME_TZ type and decodeTimeTzEx is used for
ISC_TIME_TZ_EX type (SQL_TIME_TZ and SQL_TIME_TZ_EX values in
Hi,
which version should be used and in which case should one or the other
be used?
thank you in advance,
Norbert
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
mmath libtommath-devel glibc-static
libstdc++-static libtool-ltdl-devel zlib zlib-devel -y
cd firebird
bla bla
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
;
START_SESSION
=
Statement failed, SQLSTATE = HY000
Profiler plugin is not found
-At function 'RDB$PROFILER.START_SESSION'
SQL>
Server Version: LI-T5.0.0.681 Firebird 5.0 Initial
this ok :-)
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Deve
VARCHAR(8000),
INFORM_EMAIL CHAR(1),
FROM_IPVARCHAR(16) character set octets,
REGISTER_DATETIME TIMESTAMP,
EDIT_FROM_IP VARCHAR(16) character set octets,
EDIT_DATETIME TIMESTAMP,
PAYCHAR(1),
DELETEDCHAR(1) DEFAULT 'F',
PASSWD VARCHAR(20)
);
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
months :-)
but ok :-)
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hello,
a varbinary has a subtype of 1 and not 0 (binary) normal?
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hello,
I just compiled Firebird via git and he pulls me out the version
Firebird 5.0.0.40-Initial.amd64 .
Normal?
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Mark Rotteveel a écrit :
On 2021-02-04 09:39, Norbert Saint Georges wrote:
yes, this is what I found but there is no definition RDB $ FIELD_TYPE
= 30 or 31 in rdb $ types in FB4, what is it for?
The EXTENDED TIMESTAMP WITH TIME ZONE and EXTENDED TIME WITH TIME ZONE are
protocol-only data
Jirí Cincura a écrit :
yes, this is what I found but there is no definition RDB $ FIELD_TYPE =
30 or 31 in rdb $ types in FB4, what is it for?
The "extended" definition is just for protocol, where the message contains
also the TZ offset. But this is never stored.
OK, thanks
rdb $ types in FB4, what is it for?
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
rload of timestamp_tz and time_tz?
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Norbert Saint Georges a écrit :
That said, as far as I'm aware nothing changed in how this worked, but I do
want to point out that there seems to be a mismatch in versions. You say
you're using 4.0.0.2298, but that version tag indicates you're using
4.0.0.2265.
exact, I
Mark Rotteveel a écrit :
On 18-12-2020 15:58, Norbert Saint Georges wrote:
Mark Rotteveel a écrit :
On 18-12-2020 15:14, Norbert Saint Georges wrote:
Server version LI-V6.3.0.2265 Firebird 4.0 Release Candidate 1 on centos
8.
What tool are you using that it still uses the old 'Inte
27;sRp' :-) nothing helps.
now i just made a dumpling and it works!
I recompiled the source in 32bits forgetting the lib 64 and it still
works :-(
???
I will take the tests like this to see if it holds.
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interfac
Mark Rotteveel a écrit :
On 18-12-2020 15:14, Norbert Saint Georges wrote:
Server version LI-V6.3.0.2265 Firebird 4.0 Release Candidate 1 on centos 8.
What tool are you using that it still uses the old 'InterBase backwards
compatible' version tag instead of the new version tag t
me without any changes.
an idea?
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Paul Reeves a écrit :
Does anyone have any thoughts on this?
Paul
First of all, thanks for your code, it's nicer to read than c ++ :-)
Just a question about the "read only" transaction in 03.select.pas on
line 224, you are not using the ptb initialized on line 217, norma
cluding maintenance ones, and are
worth to be provided anytime sooner than in v5.0.
regards
Pavel Cisar
Personally, I use the new pascal API every day and have been waiting
for this implementation for a long time because it is essential for all
lib devs without that they do not even start.
Dmitry Sibiryakov a écrit :
27.04.2020 15:23, Pavel Cisar wrote:
Or is the impression that this feature is not actually implemented really
true?
Yes it is true though should work in embedded mode.
is it functional in embedded?
are you sure ?
--
Norbert Saint Georges
http://tetrasys.fi
abnormally.
NORPA Mon Apr 20 11:40:25 2020
"C: \ Program Files (x86) \ Firebird \ Firebird_4_0 \ firebird.exe":
terminated abnormally (4294967295)
It is likely that I make a mistake in my code but the message "address
without privilege" worries me a little :-)
Normal as a
) to
have the latest version of firebird.pas
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Steve Bailey a écrit :
So, where do I get 1815 from?
http://web.firebirdsql.org/download/snapshot_builds/win/4.0/
to day, 1817 :-)
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Steve Bailey a écrit :
( I am using WI-T4.0.0.1436 Firebird 4.0 Beta 1 on Windows 10.)
you need to update the version of Firebird 4 currently 1815.
In your version, 1436, this was not yet implemented.
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
.Free;
end;
end;
Afterwards, all the tz dates will be returned compatible firedac in the
"fdconnection1" session
and this method can be used to format the new format of FB4 (except
varbinary it seems to me)
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web
String(IStatus;FB_I128Ptr;LongInt;LongWord;PChar);"
15424 lines compiled, 1.0 sec
3 warning(s) issued
--
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Tony Whyman a écrit :
See http://tracker.firebirdsql.org/browse/CORE-6207
this is the difference between the compilation of the day before
yesterday and that of the git less than an hour ago
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https
ext_offset: ISC_SHORT;
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hello
In FB4, when adding a timestamp field it creates me timestamp_tz
(32752). normal?
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
hing like
SQL_BFile is present.
excellent, I'll take a look.
A big thank-you
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Adriano dos Santos Fernandes a écrit :
On 23/12/2019 09:08, Norbert Saint Georges wrote:
Apologies, I badly speak in English.
In Firebird.pas, there are two procedures:
1) IUtil_loadBlobPtr = procedure (this: IUtil; status: IStatus; blobId:
ISC_QUADPtr; att: IAttachment; tra: ITransaction
Alex Peshkoff via Firebird-devel a écrit :
> On 2019-12-12 11:29, Norbert Saint Georges wrote:
>> Hello everyone,
>>
>> for the procedures IUtil_loadBlobPtr & iUtil_dumpBlobPtr what type of
>> field is provided? BFile ??
>>
>
> May be I do not understa
Dimitry Sibiryakov a écrit :
20.12.2019 21:19, Norbert Saint Georges wrote:
I try all the possibilities in numeric (38), decimal (38) it returns me,
via pascal API, always a 32762 and not a 32752
You must use the latest snapshots, not old beta release.
Thank you for your answers.
after
Dimitry Sibiryakov a écrit :
20.12.2019 21:08, Norbert Saint Georges wrote:
it is declared SQL_INT128 with 32752 but cannot find a way to declare it in
an FB4 table.
An idea or a link?
doc/sql.extensions/README.data_types.txt
thank you for your reply.
but I try all the possibilities in
Good evening,
it is declared SQL_INT128 with 32752 but cannot find a way to declare
it in an FB4 table.
An idea or a link?
thank you in advance
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird
oulala, I did not check this
it's my bullshit day.
Many thanks for your time
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Mark Rotteveel a écrit :
On 2019-12-16 15:42, Norbert Saint Georges wrote:
Mark Rotteveel a écrit :
I can't answer that without information what the problem is.
Mark
okay :-)
I was actually referring to what you meant with:
"""
t = kb
t1 = ok
"""
Espe
Dimitry Sibiryakov a écrit :
16.12.2019 15:42, Norbert Saint Georges wrote:
I am developing an application to import Oracle DBs to Firebird 4.
Do you mean "automatic import"?
yes, for people like me, who don't like tinkering with something other
than Firebird :-)
part
k you in advance.
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
type number from oracle and the above value is an example.
What do you advise me?
-Message d'origine-
De : Mark Rotteveel [mailto:m...@lawinegevaar.nl]
Envoyé : lundi 16 décembre 2019 13:32
À : Norbert Saint Georges; For discussion among Firebird Developers
Objet : Re: [Firebird-
nd in client-java:
Identity column {0} of table {1} must be of exact number type with zero
scale
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hello everyone,
for the procedures IUtil_loadBlobPtr & iUtil_dumpBlobPtr what type of
field is provided? BFile ??
thank you in advance.
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
, win2008r1, .. are out ;-)
FYI, FB 3.x works great on these platforms.
Regards,
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Hello,
Fbclient.dll no longer supports windows version 5.2-> 6.0?
Entry procedure entry point « ucrtbase.abort » could not be located in
the dynamic link library api-ms-win-crt-runtime-|1-1-0.dll
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface
Alex Peshkoff via Firebird-devel a écrit :
I'm afraid I have to ask you to checkout once again from github and send me
log once again - firebird.pas was missing in 'clean' target.
it's ok now on centos8
https://tetrasys.fi/data/FB4makeOnCentos8_2.7z
a big thank-you
--
N
Alex Peshkoff via Firebird-devel a écrit :
On 2019-11-29 12:57, Norbert Saint Georges wrote:
Hello everyone,
When compiling sources via the git repository, clop does not create the
firebird.pas file on either cent 8 or windows 7 32/64; Why ? :-)
Can you send here full build log (i.e. make
Hello everyone,
When compiling sources via the git repository, clop does not create the
firebird.pas file on either cent 8 or windows 7 32/64; Why ? :-)
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo
Hello everyone,
Is there a DB FB4 that includes all the features built into FB4, like
"employee" up to date?
Thank you in advance
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
: Windows package
Reporter: Norbert Saint Georges
the Firebird.pas file is distributed only in the linux version but in no other
version.
in version 4.0.0.1629, there are the following errors:
In Pascal, "record" is a reserved word.
after renaming:
"record" to &
Alex Peshkoff via Firebird-devel a écrit :
On 10/14/19 1:59 PM, Norbert Saint Georges wrote:
Alex Peshkoff via Firebird-devel a écrit :
On 10/12/19 5:57 PM, Norbert Saint Georges wrote:
Good evening,
I find the Firebird.pas file in the B3_0_Release but not in the master,
normal
Alex Peshkoff via Firebird-devel a écrit :
On 10/12/19 5:57 PM, Norbert Saint Georges wrote:
Good evening,
I find the Firebird.pas file in the B3_0_Release but not in the master,
normal? :-)
Depends upon _where_ you do not find it. File is generated during the build,
i.e. it's missi
Alex Peshkoff via Firebird-devel a écrit :
On 10/12/19 5:57 PM, Norbert Saint Georges wrote:
Good evening,
I find the Firebird.pas file in the B3_0_Release but not in the master,
normal? :-)
Depends upon _where_ you do not find it. File is generated during the build,
i.e. it's missi
Good evening,
I find the Firebird.pas file in the B3_0_Release but not in the master,
normal? :-)
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Good morning all,
IBlob.getInfo always returns [2,0,0, .] regardless of the requested
tags.
What is the procedure for knowing the size and number of segments of
SQL_Blob with an IBlob?
thank you in advance,
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web
Good morning all,
in the example 07.blob.cpp we find the code
"// Message for data exchange
FB_MESSAGE (Msg, ThrowStatusWrapper,
(FB_BLOB, b)
) message (& status, master); "
Firebird.pas does not take the definition of FB_Message nor FB_BLOB.
In Pascal, how do you do?
--
Vlad Khorsun a écrit :
01.10.2019 20:12, Norbert Saint Georges wrote:
Hello,
I try different solutions to use the new API in Pascal.
I get good "service_mgr"
I pass spb.insertTag (st, isc_action_svc_trace_start);
I get the error "'Internal error when using API clap
Buffer (st));
I can not find any documentation on the subject via goo, would you have
a link of a functional example?
Thank you in advance,
Norbert
--
Norbert Saint Georges
http://tetrasys.fi
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Affects Versions: 3.0.1, 3.0.0, 4.0 Initial
Reporter: Norbert Saint Georges
CREATE OR ALTER FUNCTION INT16_BIN(
FINT16 SMALLINT)
RETURNS CHAR(2) CHARACTER SET OCTETS
EXTERNAL NAME 't4s_to_bin!int16_bin'
ENGINE UDR;
int16Procedure = class(IExternalFunctionImpl)
...
Hello all,
When the input parameter of a UDR function is zero, the outmsg pointer
is null, why?
--
Norbert Saint Georges
http://tetrasys.fi
--
Firebird-Devel mailing list, web interface at
https
Hello,
In the
procedure execute(status: IStatus; context: IExternalContext; inMsg:
Pointer; outMsg: Pointer); virtual; abstract;
inMsg and outMsg Pointer to what?
And how to recover it?
--
Norbert Saint Georges
http://tetrasys.fi
eclaration per dll.
When you know, the UDR functions work well :-)
Thank you,
--
Norbert Saint Georges
http://tetrasys.fi
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
Adriano dos Santos Fernandes a écrit :
> And you do it with these spaces (' int16_bin ') and expect it to work?
>
>
> Adriano
No, there is no space, it must be a copy / paste effect in the mail :-)
--
Norbert Saint Geor
UdrPlugin.registerFunction(status,' int16_bin ',int16Factory.create());
On the basis of the example procedure but fails to register it. I
still have the message "UDR plugin entry point not found."
on the implementation of
a UDR Function?
--
Norbert Saint Georges
http://tetrasys.fi
--
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
RNS guid2
EXTERNAL NAME 'int16!int16_bin'
ENGINE UDR;
Or can I find a pascal example of a UDR function that is fine?
thank you in advance.
--
Norbert Saint Georges
http://tetrasys.fi
--
Fi
Hello all,
in new API, How to declare an array of bigint?
builder := master.getMetadataBuilder(st,1);
builder.setType(st,0,SQL_ARRAY +1);
?? builder.setSubType(st,0, 16);
?? builder.setLength(st,0,100);
--
Norbert Saint Georges
http://tetrasys.fi
Gabor Boros a écrit :
> 2016. 02. 24. 13:20 keltezéssel, Norbert Saint Georges írta:
>> ok, sorry I did not understand.
>>
>> I found the source of a new VM and it compiles under lazarus 3.0 good
>>> -)
>
> Hi Norbert,
>
> How did you do it?
>
> I t
ok, sorry I did not understand.
I found the source of a new VM and it compiles under lazarus 3.0 good
:-)
Carlos H. Cantu a écrit :
> Currently Firebird.pas can be found only in the linux builds.
> That's what Alex is talking about. It should be on Windows builds too.
--
Norbert Sa
placed into binary package.
>
> Alex,
Hi,
Program create;
uses Sysutils, Firebird; <-- Firebird unit ??? Where can you find it?
var
.
--
Norbert Saint Georges
http://tetrasys.fi
--
Site24x7 APM Insight
Dmitry Yemanov a pensé très fort :
> 21.03.2014 20:32, Dmitry Yemanov wrote:
>
>> Obviously a bug. Working on it, thanks.
>
> Fixed now, please test.
LI-T6.3.0.30892 test ok :-)
thank you
Norbert
--
..
TetraSys
http
??
Norbert
--
..
TetraSys
http://www.tetrasys.eu
--
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. W
Dmitry Yemanov a couché sur son écran :
> 29.12.2013 11:46, Norbert wrote:
>
>> yes everything by default and then I changed to try if it changed
>> something but nothing nothing!
>>
>>> Where did you get binaries?
>>
>> http://web.firebirdsql.org/
Il se trouve que peshk...@mail.ru a formulé :
> Are you using default firebird.conf?
yes everything by default and then I changed to try if it changed
something but nothing nothing!
> Where did you get binaries?
http://web.firebirdsql.org/download/snapshot_builds/win/3.0/
N
still no way to use this version on Windows 2k3 32bit
firebird.log
MYIIS6 Sat Dec 28 17:55:56 2013
Unexpected call to register plugin Arc4, type 16 - ignored
MYIIS6 Sat Dec 28 17:55:57 2013
Unexpected call to register plugin Remote, type 2 - ignored
MYIIS6 Sat Dec 28 17:55:57
Mark Rotteveel a formulé ce lundi :
> On 9-12-2013 21:49, Norbert wrote:
>>> Error 335544421 is "connection rejected by remote interface". How are
>>> you connecting to Firebird: fbclient.dll (if so 3.0 version or a 2.5 or
>>> earlier?), or Jaybird, .NET
hing
under windows)
I tested all the possibilitée configuration, including WireCrypt = 0
I understand more or look too, the last version to run on a windows is
30471
Norbert
--
..
TetraSys
http://www.tetrasys.eu
--
Sp
Hello,
On multiple machines 2k3 32 64 2k8, 2k12 64, no way to configure
FB3.0.0.30776
335544421 error systematically whatever settings.
Initialization via GSEC ok
a better idea or a config that works? :-)
Norbert
--
..
TetraSys
http://www.tetrasys.eu
78 matches
Mail list logo
