[firebird-support] Doubt about TempCacheLimit parameter...

Firebird ver 2.5.7.27050 64 bitsSuperserverWindows Server 2012R2 What is the unit of TempCacheLimit? Thanks in advance

Re: [firebird-support] Bulk upload options

Just found this article https://www.arbinada.com/en/node/1425 Firebird: bulk insert and bulk export Submitted by Serguei_Tarassov on Fri, 02/08/2013 - 16:50 Firebird doesn't support INSERT BULK command or bcp.exe utility. But the external tables can be a good replacement. Simple example is

[firebird-support] Bulk upload options

I am looking for the fastest way to run a bulk insert. I believe one way would be using isql.exe , I need to plan a solution to upload into a single table around 500 million records. Does anyone have experience with bulk updates via isql? Would it be X times faster than using a normal

Re: [firebird-support] Doubts regarding statistics of indexes and tables...

Thank you for your help. It was very helpful! On Sunday, May 13, 2018, 12:50:26 AM CDT, Helen Borrie hele...@iinet.net.au [firebird-support] wrote:   Javier wrote: > > Ok, but how do I restore the statistics? Using "update" statements? You do not

Re: [firebird-support] Re: Udr GenRows sample Pascal

Thank you botch Norbert and Dimitry for your help problem was with fill method the method is to use move index [1] of string and casting or StrLCopy or simplest possible this one which does not require any casting: StrPLCopy(outMessage.ss, s, High(outMessage.ss)) regards, Karol Bieniaszewski

[firebird-support] Firebird ADO.NET: ExecuteNonQuery Returns -1 On Successful Insert

Hello. I am using the Firebird 2.5 Embedded Edition with the Firebird ADO.NET provider version 5.5 or 5.7. I am not sure which, since it has been so long since I set up the references for my project and the assembly being used is not taken from the actual provider library that has all the

[firebird-support] MON$Attachment privileges

> This break logic in our application. Agree - I don't supply role on connection in my apps at all, but to allow user to view attachments I must do this. Also, I need a possibility to grant privileges to regular user for managing server users (like SYSDBA) - as i know this is possible, but

Re: [firebird-support] MON$Attachment privileges

Hi, thank you. I see that in FB3 this is the only way :(This break logic in our application. Regular user ca not have privileges to change db structure but with RDB$Admin role he can :(I see that this is implemented only in FB4tracker.firebird.org/browse/CORE-2557 Regards,Karol Bieniaszewski

[firebird-support] MON$Attachment privileges

To do this you must follow this steps (for FB 2.5): - grant role RDB$ADMIN to user in your working DB  - user must login with RDB$ADMIN role into your DB. After that he can access MON$ATTACHMENTS.     Hi,   how can i grant select on MON$Attachements to normal user that he/she can see all

Re: Re: [firebird-support] Re: Udr GenRows sample Pascal

>It depends on information in IMessageMetadata. > > > I have tried: > > ss: Array[0..199] of Char; > > ss: Array[0..199] of Byte; > > ss: Array[0..199] of AnsiChar; > >This is a right declaration for CHAR(200). > OK > > ss: String[200]; > > > > with last string[200] i got result

Re: [firebird-support] Re: Udr GenRows sample Pascal

15.05.2018 6:54, 'livius' liviusliv...@poczta.onet.pl [firebird-support] wrote: > what kind of buffer? It depends on information in IMessageMetadata. > I have tried: > ss: Array[0..199] of Char; > ss: Array[0..199] of Byte; > ss: Array[0..199] of AnsiChar; This is a right declaration for

[firebird-support] Firebird and PySide

Hi, I want to connect a QT/Pyside Application to a firebird 3 server using ODBC but I get only "Error": app = QApplication(sys.argv) db = QtSql.QSqlDatabase.addDatabase('QODBC') db.setHostName('localhost') db.setDatabaseName('iNew.fdb') db.setUserName('SYSDBA')

[firebird-support] MON$Attachment privileges

Hi,   how can i grant select on MON$Attachements to normal user that he/she can see all attachements not only self?   I use Firebird 3.   regards, Karol Bieniaszewski