Hi!
Having bought Delphi XE2, I tried to compile my old (well, very old) UDF
in a 64bit mode. I expected a total fail, because the UDF was written in
Delphi 5 for Interbase 6.0, but after I fixed string types, the UDF
actually works with Firebird 2.1 x64. With one exception - a function
which
The function:
function STRBLOB(Value: PAnsiChar; Dest: PBlob): PBlob;
begin
Result := Dest;
Dest^.PutSegment(Dest^.BlobHandle, Value, StrLen(Value))
end;
That's CDECL, too. I copied it from the implementation rather than from
the interface.
Josef Kokes
Hello, Josef!
Monday, June 18, 2012, 10:18:57 AM, you wrote:
JK function STRBLOB(Value: PAnsiChar; Dest: PBlob): PBlob;
cdecl
JK The blob record (probably wrong for x64):
JKTISC_BlobGetSegment = function(BlobHandle: PInt;
JK Buffer: PAnsiChar;
JK BufferSize: LongInt;
JK var
Hi!
Hello, Josef!
Monday, June 18, 2012, 10:18:57 AM, you wrote:
JK function STRBLOB(Value: PAnsiChar; Dest: PBlob): PBlob;
cdecl
Yeah, I realized too late that I should have used the declaration from
interface, not from implementation. I have that.
JK The blob record (probably wrong
Hi *,
(similar message I posted already in Firegird-general, but it seems, that this
list is not so active)
As a example I have select like:
SELECT col1, col2,
(select sum(col3) from table2 where col1=a.col1 and col2=a.col2) as col3
FROM table1 a;
In this case query PLAN is like:
PLAN
My email is
ha...@logosnet.cy.net
unfortunately long time ago I joined the group and I get hundreds of
emails.
Can you please delete me from the mailing list .It looks like I cannot do it
myself because most probably my data were lost,
Already forgot my access codes etc..Please tell me
On Mon, 18 Jun 2012 14:19:32 +0300, Costas Hadjimarcou
ha...@logosnet.cy.net wrote:
My email is
ha...@logosnet.cy.net
unfortunately long time ago I joined the group and I get hundreds of
emails.
Can you please delete me from the mailing list .It looks like I cannot
do
it
On Mon, 18 Jun 2012 13:35:33 +0200, Mark Rotteveel m...@lawinegevaar.nl
wrote:
On Mon, 18 Jun 2012 14:19:32 +0300, Costas Hadjimarcou
ha...@logosnet.cy.net wrote:
My email is
ha...@logosnet.cy.net
unfortunately long time ago I joined the group and I get hundreds of
emails.
18.06.2012 11:37, lacakus wrote:
I guess, that it is because COALESCE is internaly transformed into CASE
WHEN subselect IS NULL then 0 else subselect end
So in expression is subselect twice.
Correct.
My question is if subselect is really executed twice for every row in
table1? or is there
Thanks Dmitry for reply.
Backporting optimization from 2.5 to 2.1 would be a big work ?
L.
I guess, that it is because COALESCE is internaly transformed into CASE
WHEN subselect IS NULL then 0 else subselect end
So in expression is subselect twice.
Correct.
My question is if
18.06.2012 16:17, lacakus wrote:
Thanks Dmitry for reply.
Backporting optimization from 2.5 to 2.1 would be a big work ?
Yes, it would be highly undesirable.
Dmitry
Thanks Dmitry for reply.
Backporting optimization from 2.5 to 2.1 would be a big work ?
Yes, it would be highly undesirable.
I understand. Thanks.
Is there any smart workaround ?
My situation is as follows:
I have view, where are columns like:
coalesce(subselect1, 0) as col3,
Just turn on the Windows AT service (if it is not already), and it
should do what you are used to doing in Cron. Just look it up on Google
and go from there. Works fine with Firebird backups.
--
-
Myles Wakeham
Director of Engineering
Tech Solutions USA LLC
Myles Wakeham wrote:
Just turn on the Windows AT service (if it is not already), and it
should do what you are used to doing in Cron. Just look it up on Google
and go from there. Works fine with Firebird backups.
But it still needs a script to emulate the firebird-backup script. Trim older
I have found no information in any FAQs or knowledge base
thanks
[Non-text portions of this message have been removed]
On Mon, Jun 18, 2012 at 1:27 PM, michael jones m...@btinternet.com wrote:
I have found no information in any FAQs or knowledge base
There's a new On Disk Structure (ODS) for V2.5. To get full benefit from
2.5, you must backup the database and restore it on 2.5. However, 2.5 can
read the old
michael jones schrieb am 18.06.2012 um 18:27 (+0100):
[Moving from Firebird 2.1 (32 bit) to 2.5 (64 bit)]
I have found no information in any FAQs or knowledge base
The release notes have migration info:
https://www.google.com/search?q=firebird+release+notes
Michael
17 matches
Mail list logo