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
>>
>>
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
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
>
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
>
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
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
>
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
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
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
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
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
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),
'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 )
--
'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
'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
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.
--
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?
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
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
> 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
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
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
> 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
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
> /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
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?
>
>
> 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
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
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
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;
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
>>> 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
>> 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
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
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_COUNT
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
> 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
'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...
'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 =
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.
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 ]
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
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
Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> salut,
sorry, bad forum :-(
--
Norbert Saint Georges
http://tetrasys.fi
++
Vi
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
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
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)
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
>>>
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
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
-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;
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
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
'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,
'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:
>
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
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
ecords, 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
sel
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
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,
60 matches
Mail list logo