[firebird-support] Re: RES: Version number

2012-11-22 Thread Dmitry Yemanov
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

[firebird-support] Parameter in select statement possible?

2012-11-22 Thread patrick_marten
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

Re: [firebird-support] Parameter in select statement possible?

2012-11-22 Thread Thomas Steinmaurer
> 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.

[firebird-support] Re: Parameter in select statement possible?

2012-11-22 Thread karolbieniaszewski
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))

Re: [firebird-support] Re: RES: Version number

2012-11-22 Thread Jesus Garcia
> 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

Re: [firebird-support] Firebird connection from win 7 home basic

2012-11-22 Thread Mark Rotteveel
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

Re: [firebird-support] Firebird on Windows 8

2012-11-22 Thread Mark Rotteveel
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

Re: [firebird-support] Re: RES: Version number

2012-11-22 Thread Thomas Steinmaurer
>> 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

[firebird-support] Re: RES: Version number

2012-11-22 Thread Dmitry Yemanov
22.11.2012 14:35, Thomas Steinmaurer wrote: > I would say nullable compound indices, but Dmitry might have the > ultimate answer. ;-) Absolutely correct. Dmitry

Re: [firebird-support] Firebird on Windows 8

2012-11-22 Thread Daniel Rail
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

[firebird-support] Backup problem when different client libraries connected to DB?

2012-11-22 Thread Benton Quest
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

RE: [firebird-support] firebird process hangs every aprox 10 days

2012-11-22 Thread Svein Erling Tysvær
>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

RE: [firebird-support] Re: DB w/ 16kb page site and BLOB fields size w/ content just 40bytes by record

2012-11-22 Thread Leyne, Sean
> 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

[firebird-support] Re: Backup problem when different client libraries connected to DB?

2012-11-22 Thread Dmitry Yemanov
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

[firebird-support] I want to store encrypted passwords in a VARCHAR(50) field

2012-11-22 Thread red_october2009
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

[firebird-support] Re: Index Corruption Firebird 1.5

2012-11-22 Thread rddymanohar
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