We tried to install the Firebird 2.5.1 pack by silent in our product. In all
OS, FB installed correctly. But , in Win 7 machines it shows the Internal Error
2755. 1622 "Path of the filename.msi"
Could you please suggest this case..
Hello Michael,
> Alexey Kovyazin schrieb am 21.05.2012 um 15:04 (+0400):
> >
> > You have hit transaction limit of Firebird.
> > To prevent it, make backup/restore more often.
>
> What makes you think so?
>
I saw diagnostics log from IBFirstAID Diagnostician.
:)
>And why would that make the mem
Hello,
In a stored procedure there are 6 Input Parameters F1 to F6. This varchar
variables contains table-field-names and I verify this.
Now I thought I can use a statement like this:
i = 0;
while (i < 7) do
begin
idexists = 0;
stmtxt = 'select 1 from rdb$databa
Hi there,
I am running a firebird superclassic server on Scientific Linux 6.2. I
installed this using the EPEL repos. The version I am running is
2.5.1.26351.0.
This server is a dedicated firebird server and does nothing else but run
firebird and serve databases. However I am using it to serve a
Hello! I have a simple SP with something like this:
select my_field
from some_table
where id in (1,3,56,100)
How can I do to pass "(1,3,56,100)" a an input parameter?
I've been googling a lot, but found nothing... It seems to be tricky to google
something like "firebird select in" !
If I can'
> Hello! I have a simple SP with something like this:
>
> select my_field
> from some_table
> where id in (1,3,56,100)
>
> How can I do to pass "(1,3,56,100)" a an input parameter?
You can pass the IN list as a string, build the SQL statement
dynamically and execute the SQL with:
[FOR] EXECUTE
Hi guys
Our system used to do a force users off and do a nightly backup/restore. Seems
that when our IT moved to offsite continuous data warehousing, the
backup/restore caused a significant increase in the data being warehoused and
so they stopped doing it.
2^31 (0x7FFF) might be big but r
Hi, I'm trying to use a CTE a bit differently from what I usually do, but am
failing.
WITH MyCTE AS
(SELECT CAST(:FromMainTable AS VarChar(5)) FromMainTable, Field1
FROM MySmallLookupTable
WHERE Field2 = :FromMainTable
UNION
SELECT CAST(:FromMainTable AS VarChar(5)), Field1
FROM MySmallLookupTabl
Hello Set,
> Hi, I'm trying to use a CTE a bit differently from what I usually do, but
> am failing.
>
> WITH MyCTE AS
> (SELECT CAST(:FromMainTable AS VarChar(5)) FromMainTable, Field1
Wouldn't this be the value of Field2 then?
> FROM MySmallLookupTable
> WHERE Field2 = :FromMainTable
> UNION
Hello, Sergio!
Tuesday, May 22, 2012, 3:25:43 PM, you wrote:
S> Hello! I have a simple SP with something like this:
S> select my_field
S> from some_table
S> where id in (1,3,56,100)
S> How can I do to pass "(1,3,56,100)" a an input parameter?
Simple:
Select something
>From Table T
Where :P
Hi All,
We use Firebird 2.5 64 bits classic + 64 bit ODBC driver + Windows 2008 R2
64 bit. Until now its performance has been exemplary, but recently we have
encountered performance problems when switching from a HP 380G7 with 1
quad-core to a HP380G7 with 2 six-core (=12 core). In the new machin
I have a simple app, which needs to run for a few users, written in C#.net.
The users to not have the ability to run an install on their own computers, so
we must install via a simple xcopy. Currently we are using SQLite, but the
performance is pretty bad when the db gets a bit large.
Can I h
The computer that hosts the Firebird DB will need a proper Firebird
server installed on it. The 'Clients' can use the Embedded server to
access that server. The database file doesn't need to be shared.
You could possibly install Firebird server via xcopy, and then register
the server service
13 matches
Mail list logo