[firebird-support] External Tables

2018-03-09 Thread alansbr...@gmail.com [firebird-support]
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

[firebird-support] Re: Execute Block size limit

2018-03-09 Thread ho...@agencybusys.com [firebird-support]
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

[firebird-support] Faulty BLRs

2018-03-09 Thread Matthias Winkler maze...@gmail.com [firebird-support]
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

Re: [firebird-support] ASCII values

2018-03-09 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

[firebird-support]

2018-03-09 Thread Mourad Hedfi mou...@bilog.fr [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

RE: [firebird-support] ASCII values

2018-03-09 Thread hugo.lar...@yahoo.com [firebird-support]
Many thanks András! //ugo