RE: [firebird-support] ASCII values
Many thanks András! //ugo
[firebird-support]
Hello, I want to use FreeAdhocUDF with Firebird 2.5.8 on Mac OS 10.10. I've executed the UDF script on my database and modifying firebird.conf as :UdfAccess = Restrict UDF ; /Library/Frameworks/Firebird.framework/Versions/A/Resources/English.lproj/var/; But when I execute a query using dateToStr function, I've the following error : Statement failed, SQLSTATE = 39000 invalid request BLR at offset 39 -function DATETOSTR is not defined -module name or entrypoint could not be found Can anyone tell me what I'm missing ? Best regards
Re: [firebird-support] ASCII values
On 2018-03-09 06:33, hugo.lar...@yahoo.com [firebird-support] wrote: > I have a column char(2) where two ASCII values stored. For example > 0011, 0001 are stored as (3,1). > When I do a select I dont get any result because the result is not > alphanumeric. 3 is ETX and 1 is NUL. > I can get the values programmatically but I want to do bit comparison > with sql query. > Anyone might know how? You can use hex literals[1] for that, eg yourcolumn = x'0301' This requires Firebird 2.5 or higher. Be aware that 0x01 is not NUL, it is SOH (Start Of Heading), NUL is 0x00. Mark [1]: https://firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-dml.html#rnfb25-dml-hex
[firebird-support] Faulty BLRs
Hi Everybody, I just joined to group for this question: I made changes to some view and procedures. As far as I understood, I need also to redefine (drop, create) all procedures/views which use the changed ones? Flamerobin is already proposing to drop these dependencies before changing the item itstelf. So far so gooo. Now I also added a column to an existing table. Is it then also necessary to recreate all BLRs using this table? Is there a way of automatically finding them? In general it remains unclear if in the past all BLRs where recreated when needed: - It there a procedure to verify that all BLRs are still consistent? - Is there a way to re-create all BLRs in a DB? - Is there a way to find faulty BLRs? Some kinde of test? (Backup and restore, maybe?) This BLR topic is quiet dangerous because the BLRs remain hidden from the user until there occurs an error. Thats somehow a weired concept of abstraction. Is there a switch to force recreation of the BLRs on every access? Literature is quite short about this topic. Hope someone can help Matthias
[firebird-support] Re: Execute Block size limit
I have limited block size to < 64 K and <255 inserts. That creates several blocks to be executed in order to insert all the data. I'm hesitant to execute them serially. Is it acceptable to enclose all the blocks inside a transaction that can be rolled back if a failure occurs later in the transaction?
[firebird-support] External Tables
Hi! I'm trying to create an external table with a normal user and I'm getting this error: This operation is not defined for system tables. unsuccessful metadata update. CREATE TABLE EXT_CTB_LANCAMENTO failed. There is no privilege for this operation. How do I grant permission to a regular user to create external tables? During my tests only sysdba could create them. Thank you for the help!