barcadero marketing matriel
>>
>> Already was discussed here a couple of months ago. Look into archives.
>
> Which archives?
news (port:119)
news.gmane.io/gmane.comp.db.firebird.user
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
o compile a
> running program right now?!
but if, of course, the development team has everything planned :-)
SET BIND OF TIME ZONE TO LEGACY ;
SQL_TIMESTAMP_TZ ->SQL_TIMESTAMP
--
Norbert Saint Georges
htt
Thanks
>
> Gregor
after a test with the compiled version of the day, indeed, there is the
following error if we do not use the 1815 version of fbclient
"Unsuccessful execution caused by system error that does not preclude
successful execution of subsequent statements.
Invalid clumplet buffer structure:
net/downloadcenter/)
all other utilities tested to date generate compatibility errors.
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit h
Gregor
32754 = SQL_TIMESTAMP_TZ and EMS and FireDAC does not recognize it yet.
You are interested in doing the test with a version compiled with the
latest sources
--
Norbert Saint Georges
http://tetrasys.fi
-
ore IAttachment and IAttachment before
> IStatement or it is required to release acquired interfaces before the
> interface it was got from?
>
Hello,
Personally, I release my classes in the opposite directions to their
creation.
coordialement
Norbert
--
Norbert Saint Ge
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:/
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
nnection! use a
micro or web service for that.
4) Query the DB via stored procedures.
5) Type of SLA of the provider.
6) Make several test from various suppliers on ipv4 wired before
starting to work on the project
--
Norbert Saint Geor
estamp )
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other
'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 fi
'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:/
r opinion.
--
Norbert Saint Georges
http://tetrasys.fi
atform?
--
Norbert Saint Georges
http://tetrasys.fi
derstand English enough to feel the finesse of your
question.
but, if execute block does not suit you, there is always the
possibility with merge when matched .. / when not matched then insert
...
--
Norbert Saint Geo
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://tetra
> 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.
--
Norb
g system directive access failed -Not a folder"
On Windows 7 & 10, no problem in embed but on centos8 really no way.
An idea?
--
Norbert Saint Georges
http://tetrasys.fi
+++
recent Firebird 4 snapshots.
>
> Mark
> --
> Mark Rotteveel
>
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsq
> 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://tetra
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
(turbobird
http://code-sd.com/products/turbobird/) that runs on several
environments and only needs to be completed. I even found it in typhoon
code examples.
--
Norbert Saint Georges
h
't
> really have our preference.
>
> Mark
Personally, I use news://news.gname.org to read and possibly respond to
the mailing of different groups of Firebird.
This allows me to search for a topic on the 18713 current
bove works, but if I put in 2 fields as below, I get an error.
>
>
ORDER BY
CASE :OBC
WHEN 1 THEN MEMBERS.SURNAME
WHEN 2 THEN MEMBERS.FIRST_NAME
END;
,
CASE :OBC
WHEN 1 THEN MEMBERS.FIRST_NAME
WHEN 2 THEN MEMBERS.SURNAME
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://tetra
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
t;All constants can be found at \include\ibase.h
a big thank you, I look here.
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql
es not exist in firebird.pas.
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top
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://t
> 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
);
ss := blabla...
move(pchar(ss)^,_outbuffer[_outmessage[0].Offset+2],_outmessage[0].length-2);
finally
setlength(ss,0);
end;
end;
--
Norbert Saint Georges
r6Factory.newItem(status: IStatus; context:
IExternalContext; metadata: IRoutineMetadata):iExternalFunction;//
int16Procedure;
begin
Result := Char6Procedure.create(_in, _out, _inlength,
_outlength,_inMessage, _outMessage);
end;
end.
--
Norbert Saint Ge
com/usingfirebird.aspx
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) m
en/3_0/rnfb30-ddl-enhance.html
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql.org and click the Documentation item
on the mai
rdings, if we organize
the first eight bytes in a less cahotic way, this will lighten Firebird
by making it faster?
--
Norbert Saint Georges
http://tetrasys.fi
-c709-a42e349410df
There would be a lot of advantage, for Firebird, in using this kind of
guid?
--
Norbert Saint Georges
http://tetrasys.fi
Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> salut,
sorry, bad forum :-(
--
Norbert Saint Georges
http://tetrasys.fi
++
Vi
coup avec un temps null de réponse bien sur ???
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql.org and click the Documentation
FB3 is the same as FB2.5?
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) m
, a smallint) or simply take a
count(1).
Why ?
firebird.log
"
NORPA Thu Nov 03 10:05:12 2016
I/O error during "ReadFile" operation for file
Error while trying to read from file
Data error (cyclic redundancy check).
"
--
Norbert Saint George
o.append(concat('Error compress n° : ',inttostr(err),#13#10));
end;
strm.Clear;
strm.free;
end;
function TUserData.concatbyte(a, b: array of byte): TByteArray;
var ia, ib: Longint;
begin
ia := length(a);
ib := length(b);
if ia>0 then
SetLength(result, ia +ib)
else
SetLength(result,ib);
if ia>0 then
move(a,result[ia],ia);
move(b,result[ia],ib);
end;
end.
--
Norbert Saint Georges
http://tetrasys.fi
interface : IMaster; cdecl; external
'myfbclient';
-->
it's not a bad idea to work hard?
I have all versions (almost) 1.0 to 4.0 on my machine with their
renowned dll and this only works like this.
--
Norbert Saint Georges
http:/
well :-)
my exe is in the root folder of the FB and I renamed fbclient in
myfbclient to be sure to take the right version.
the itl directory is there
--
Norbert Saint Georges
ht
3, IStatement.PREPARE_PREFETCH_METADATA);
-->
I get this error message.
I've forgotten what?
--
Norbert Saint Georges
http://tetrasys.fi
++
Visit http://www.firebirdsql.org and
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
nd Windows/Linux. Anyway ... ;-)
>
>> http://web.firebirdsql.org/download/snapshot_builds/win/3.0
>
>
> Thomas
>
(www.) me too :-).
but the final addre
rg/en/snapshot-builds/
>
the link is dead
http://web.firebirdsql.org/download/snapshot_builds/win/3.0
--
Norbert Saint Georges
http://tetrasys.fi
++
300-10001'
AND B.ItemCode='OCC'
AND B.UOM='UNIT'
AND A.Cancelled='F'
AND B.UnitPrice<>0)
--
Norbert Saint Georges
http://tetrasys.fi
+++
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
linked_to_group is null)
)
) b
where b.linked_to_group = (select first 1 pk_group from mygroup where
description = 'Vishal Group')
Norbert Saint Georges
TetraSys Oy
Bergantie 69, FI-02540 Kylmälä
Tel. : +358 (0) 400 27 25 18
E- mail : n...@tetrasys.fi <mailto:taru.kauk
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
, Windows Server 2008 R2, Windows 8
Version:
2015
Language:
English, German, Portuguese, Spanish, Italian, French, Dutch, Japanese,
Russian, Polish, Czech, Hungarian
Norbert Saint Georges
TetraSys Oy
Bergantie 69, FI-02540 Kylmälä
Tel. : +358 (0) 400 27 25 18
Any body can help us to export the product table to Excel or CSV format.
Yes, contact me by e-mail
Norbert
--
..
TetraSys
http://www.tetrasys.eu
++
Visit http://www.firebirdsql.org
LtColRDSChauhan a couché sur son écran :
Please help me migrate to Firebird 2.5.2 from Firebird 3.0.
Thanks Regards,
Lt Col (Retd) Rajiv Dular Singh Chauhan
FBClone works very well for this
http://code.google.com/p/fbclone/downloads/list
--
..
TetraSys
http://www.tetrasys.eu
Preparing query: SELECT a.CON_ID, a.* FROM XRD_RC_DATA_VIEW_F a
What is XRD_RC_DATA_VIEW_F?, a table or view ?
test:
select * from data_summary a
join ( select * from data_view group by 1,2,3 ) b on a.d_1= b.d_2
Norbert
--
..
TetraSys
http://www.tetrasys.eu
Andrzej Grzegorczyk a émis l'idée suivante :
It is view.
this may be the source of the slowness you describe, it is not normal
for so can record.
--
..
TetraSys
http://www.tetrasys.eu
Hi,
select * from data_summary a
join ( select * from data_view group by 1,2,3 ) b on a.d_1= b.d2
?
Norbert
65 matches
Mail list logo