I'm having a problem with dynamic events and maybe someone can tell me what I'm doing wrong, or if this is a bug. My events contain the station number, date...
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...
This morning I got the following message on one of our systems in the firebird logfile. page 52620, page type 5 lock conversion denied (215) (firebird 2.1.4,...
Hi, I want to install the Firebird 2.5 server through MSI Installer with logging options. Could you please provide the command line parameters for Firebird...
I tried to grant execute permission for stored procedures for a role. but when this procedure is executed by a user in this role I get message, that rights...
Hello, Unfortunately I have not yet found a solution to the problem. I use a String and would like to add a string-variable to the string. I need before and...
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 ...
Dear experts, I got following error after issuing SET statistics INDEX "RDB$INDEX_16" Error: GDS Exception. 335544351. unsuccessful metadata update MODIFY...
Hi, Trying to gain access to a couple of old FB 2.0 databases, I can't remember what username is set as database owner and has grants to access the database. ...
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,...
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...
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...
Our main database is Firebird 2.1 running on a windows 2k8 server In the middle of the night with no real users, a single program was running updating data...
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...
Hi all. I have a question about how Firebird internally updates a record. Here an example: Create table test(cod integer, name varchar(50)) Commit; Insert into...
Hi, I've archived some old FDB files since my Win2000 (32 bit) days, and unfortunately some of them are available only in FDB form, not as a backup file. Is...
hi-- this seems like it should've been simple...but i can't figure it out? please help... gbak -b aaa.gdb aaa.fbk creates a .fbk database file. i assume this...
Hi everybody, I'm trying to optimize a complex query, and by doing so, I found something that surprised me and I would like to ask if anybody have an...
Hi All, I am writing the query for getting the first 100 records from the table. Like - select first 100 * from XXX I am able to get the data from the table ...
Saw a bit of discussion, but could use a more direct clarification to the question: Will 64-bit FB read 32-bit data files? Or, (as hinted in an earlier...
Hello, it's a long time I have been subscribed to a Firebird mailing list. So hello again, especially to Helen who always helped me years ago. Here are several...
Hi All, Please help me why the select statement is not working . while select only first 50 I am able to get the database but while select whole it is under...
I am trying to use external files but keep getting this error Access to external file "C:\magusdb\dxs3.txt"; is denied by server administrator. I have modified...
Firebird 1.5 is trying to ask the employee strcount procedure. But the Firebird 2.5 does not work. What can I do for work. ... SELECT STRCOUNT( '.',...
I use FB 2.5.1 When I hold a consultation of a filter-tipped board he returns a record with void value to me. As I avoid this? select sum(t.saldo) as saldo...
Hi everybody, There is a way to format a datetime inside a query ? When use a CAST function to convert datetime to string : CAST(SUBSTRING(CAST(a.LAST_UPDATE...
