22.11.2012 10:57, Maya Opperman wrote:
> I thought I would only START to see the problem if I went from 2.5.1 to
> 2.5.2 (without rebuilding).
This is also possible, but only if you migrate not to the official
v2.5.2 release but to some earlier snapshot build.
Dmitry
Hello,
is it possible to use parameters within the select statement?
Something like
"select cast (:PATH || FILENAME as varchar(255)) as FILEPATH from SOME_TABLE"
Best regards,
Patrick
> is it possible to use parameters within the select statement?
>
> Something like
>
> "select cast (:PATH || FILENAME as varchar(255)) as FILEPATH from SOME_TABLE"
Yes, but I guess you will get an error at prepare time.
You explicitely have to specify what data type the :PATH parameter is,
e.g.
Hi,
question is where are you using this?
stored proc ..
Karol Bieniaszewski
--- In firebird-support@yahoogroups.com, "patrick_marten"
wrote:
>
> Hello,
>
> is it possible to use parameters within the select statement?
>
> Something like
>
> "select cast (:PATH || FILENAME as varchar(255))
> This is also possible, but only if you migrate not to the official
> v2.5.2 release but to some earlier snapshot build.
>
> Dmitry
>
> One question Dimitry. We have some quite large databases and cannot do a
backup restore cycle. Also rebuild indices may take so much time.
What kind of indices ha
On 21-11-2012 14:37, Federico wrote:
> Hi All,
> I have a firebird 2.1.2 database running on a Windows 2003.
> I already have windows xp clients, also windows 7 64 bits profesional, all
> logged into the same domain as the server and every one using ODBC conections.
>
> But I want to connect a Win
On 21-11-2012 20:40, heineferreira wrote:
> Hi
>
> Do you have any plans to put Firebird and the database drivers and flamerobin
> into the windows 8 app store?
> Aparantly there are major issues with sideloading in windows 8.
You can install Firebird and Flamerobin without issue on Windows 8. Th
>> This is also possible, but only if you migrate not to the official
>> v2.5.2 release but to some earlier snapshot build.
>>
>> Dmitry
>>
>> One question Dimitry. We have some quite large databases and cannot do a
> backup restore cycle. Also rebuild indices may take so much time.
> What kind of
22.11.2012 14:35, Thomas Steinmaurer wrote:
> I would say nullable compound indices, but Dmitry might have the
> ultimate answer. ;-)
Absolutely correct.
Dmitry
Hi,
At November-22-12, 6:31 AM, Mark Rotteveel wrote:
> On 21-11-2012 20:40, heineferreira wrote:
>> Hi
>>
>> Do you have any plans to put Firebird and the database drivers and
>> flamerobin into the windows 8 app store?
>> Aparantly there are major issues with sideloading in windows 8.
> You c
Hi there,
We have a Linux server (64 bits OS) running Firebird 1.5.6 (32 bits) serving a
2GB Firebird database. We have a variety of legacy and "recent" client
applications connecting to the database, some using Borland's BDE, other use
the Firebird DotNet provider, we have IBExpert and some ot
>susi (Server) Tue Nov 20 15:42:27 2012Modifying procedure
>SP_CARGA_LIQ_HABERES_DET which is currently in use by active user requests
I don't know anything about this part of Firebird, but the error message above
sounds like someone is doing some data definition (ALTER PROCEDURE
SP_CA
> 22.11.2012 1:16, Leyne, Sean wrote:
> >
> > If that size is less than the free space on the data page, then the
> > blob would be stored with the data, taking only 40 bytes.
>
> I'd say it gonna take 8 bytes per blob id + up to 8 bytes per alignment (both
> compressed) + 28 bytes per blob head
22.11.2012 19:38, Benton Quest wrote:
>
> I've noticed that when I run a backup from the Linux console using gbak,
> the backup does not end normally, it "crashes" with an error message.
What is the error message? What is the gbak command line?
Dmitry
I am using Delphi 7 and CryptoPressStream. When encrypted, the encrypted
string could include "control" type characters that I'm worried could mimic an
"End of Record" character.
Is there any danger that the encrypted password string, when stored in the DB,
could corrupt the table or DB? Sh
Yes we plan to move to the latest version which is already under way but lately
these index issues have become a daily nag. Will try and upgrade the customer
to 1.56 in the mean while and see if that solves it for the time being.
Thanks
--- In firebird-support@yahoogroups.com, Thomas Steinmaure
16 matches
Mail list logo