Hi,
I am trying to restore a backup using Firebird 2.5, and am getting the
following error:
---
Omni Control Centre
---
Unsuccessful execution caused by system error that does not preclude successful
execution of subsequent statements.
Do not
Hi,
Does anyone have any idea what has happened to FIBPlus from DevRace for Delphi?
They haven't brought out any updates for a year now, not since Delphi XE4.
They aren't responding to support tickets, or emails either.
Thanks
Maya
Thank you for all the suggestions
hopefully, we're not talking about more than a few million rows in this
table?...
I'd say definitely not more than a million, probably around 15000 for the
products tables, 5000 for the customer tables, and 100 000 for the jobs and
orders tables.
But, each
Hi,
I'm not sure if this is a problem or not, but I have quite a few entries like
this with NULL transaction ID's in the MON$STATEMENTS table:
MON$STATEMENT_ID
460577
MON$ATTACHMENT_ID
128
MON$TRANSACTION_ID
NULL
MON$STATE
0
MON$TIMESTAMP
NULL
MON$SQL_TEXT
Select abc from xyz where this =
I'm not sure if this is a problem or not, but I have quite a few
entries like this with NULL transaction ID's in the MON$STATEMENTS table:
Is this a sign that my code isn't cleaning something up properly, or
is it perfectly normal?
Any idea under what circumstances this will happen?
i.e.
Is that not going to be affecting performance in a bad way?
Nope.
Thanks Dmitry!
++
Visit http://www.firebirdsql.org and click the Documentation
Hi,
I've got quite a tricky SQL query (well, at least for me it is, I'm hoping
someone may have done this before)
Here's a simplified example of what I'm trying to do:
I have a table with
IDGroupID FKCode Value
1 1
I've got quite a tricky SQL query (well, at least for me it is, I'm hoping
someone may have done this before)
Here's a simplified example of what I'm trying to do:
I have a table with
IDGroupID FKCode Value
1 1
Norbert wrote:
>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
Thank you Norbert, that does look like
>>In Firebird 3 it will be possible with window functions. In Firebird 2.5 I
>>don't know a way in pure SQL.
>>Mark
Great, thanks Mark.
Cool, so I’ll be doing something like this, when Firebird 3 is available:
select emp_no, salary,
sum(salary) over (order by salary) cum_salary,
sum(salary)
Hi,
I'd like to add a running total to my result set. For example:
Table: Invoices
Reference Due
Invoice1 50.00
Invoice2 30.00
Invoice3 20.00
I'm guessing SQL would be something like:
Select
Reference,
Due,
Sum_Total(Due) as Balance
>From
>Loius Wrote:
>You could create a denormalized field that contains the difference of those
>values (updated by a trigger, perhaps), and you can put
>an index on that new field. Then change the query to find rows where [new
>difference field] < 0.
>Make sense?
Thank you, looks like I will
Hi Vishal,
>I need to understand how to set Wait/No Wait Transaction in firebird.
I think you mean in Delphi? Might be better to ask on the Firebird tools group,
but I have replied below
>Also I have one doubt that I when we start transaction through code as shown
>below, the transaction locks
>Alan Wrote:
>Partno, del_qty no_boxes, (pallet_qty, qty_per_box - do not vary for each part)
>ABC 200 10300 20
>ABC 200 10300 20
>ABC 100 5 300 20
>So far so good, but some of their customers require a second barcode label
>>Can you connect locally by using TCP/IP(i.e.: using localhost or the
>>server's own IP)?
Just my 2c. We have also experienced this on a few PC's.
A connection string of:
localhost:c:\MyFolder\MyData.fdb
gives the connection rejected error.
Changing to:
c:\MyFolder\MyData.fdb
resolves
>I have a small application written in Delphi that uses Firebird, It is
>intended to be used on a single computer currently. Possibly moving the
>database to a server later which would mean installing firebird on the server
>and then a separate install of Firebird on the client.
>But for now
>I have been using Firebird 2.5.7 64 bit on Windows 7 for sometime, also using
>FreeAdhocUDF. I just installed Firebird 3.0.2.32703 64 bit and now
>FreeAdhocUDF is no longer loading.
>I see that there is a support ticket in place for this exact bug, but so far
>no resolution. This is a major
Hi,
I am (EVENTUALLY), getting around to upgrading from Firebird 2.5 to Firebird 3.
I purchased the conversion guide, and so far so good, except for this problem,
which I cannot find a mention of anywhere, no online, nor in conversion the
guide:
SELECT C.ENDDATE
FROM CMN_PERIODS C
WHERE
18 matches
Mail list logo