Re: [firebird-support] Firebird 4 and RDB$ERROR

2019-05-16 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
Am 16.05.19 um 10:49 schrieb sbai...@mutualconsultants.ltd.uk [firebird-support]: > > Maybe this question is also off-topic, but can you tell me which group > I should use for posting questions about FB4 Beta 1? This would be https://lists.sourceforge.net/lists/listinfo/firebird-devel hth

Re: [firebird-support] re: Can't get Firbird 3.x embedded to work in Delphi 10.3 update 1?

2019-04-24 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
://docwiki.embarcadero.com/RADStudio/Rio/en/Configuring_Drivers_(FireDAC) mit freundlichen Grüßen Frank Schlottmann-Gödde

Re: [firebird-support] GPRE

2019-02-20 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
* * g e n e r a l _ o n _ e r r o r * ** * * Functional description * Handle any general ON_ERROR clause during ODS level detection. * *****

Re: [firebird-support] Unit testing for stored procedures?

2014-12-06 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
On 05.12.2014 17:19, Tim Ward t...@telensa.com [firebird-support] wrote: Anyone done any of this? Testing a stored procedure involves - set up test data - run the procedure - check and report on results - any clean up needed (remove or restore output data, reset generators, ect ect) and

Re: [firebird-support] Compile Firebird-2.5.3 with Ptxdist for ARM

2014-10-02 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
On 01.10.2014 14:28, Mathias Stucki mathias.stu...@fasnacht.biz [firebird-support] wrote: Hello, I am trying to compile Firebird-2.5.3 with ptxdist-2014.09.0, using OSELAS.Toolchain-2013.12.2. Unfortunately I’m getting a lot of compile errors: Well, the build process for FB2.5 isn't fit

Re: [firebird-support] anywhere we can do a showcase of firebird projects?

2014-08-05 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
Am 04.08.2014 17:51, schrieb g80r...@gmail.com [firebird-support]: I just wonder. What about: http://www.firebirdsql.org/en/case-studies/ hth Frank -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-09 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
On 09.06.2014 15:51, Mike Ro miker...@gmail.com [firebird-support] wrote: So the only mystery (for me!) remaining is why the UDF is so much faster when it is writing 4096 bytes at time with forced writes on? Usually it is faster to let the server do the dirty work, but I'm not sure that it is

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-07 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
On 06.06.2014 15:11, Mike Ro miker...@gmail.com [firebird-support] wrote: Frank, thank you for taking the time to do this. It confirms that there is definitely something wrong with my setup (are you using Firebird version 2.5.2?). No, its LI-T3.0.0.31151 Firebird 3.0 Alpha 2, but that

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-06 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
On 04.06.2014 00:08, Mike Ro miker...@gmail.com [firebird-support] wrote: Unfortunately I haven't had any success in trying this because blob_put_segment() is causing Firebird embedded to throw an instance of Firebird::status_exception followed by a core dump that I really can't get to the

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-02 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
Am 28.05.2014 11:38, schrieb Mike Ro miker...@gmail.com [firebird-support]: I am sorry to bump this, but has anyone else got experience of using blobs on Linux? Yes, of course, but I never felt the need to time the operations, we are using a udf s.th. like: void EXPORT fn_b_load ( char*

Re: [firebird-support] Request for advice

2014-04-24 Thread Frank Schlottmann-Gödde
On 04/24/2014 01:32 PM, Mags Phangisa wrote: Thanks Thomas. Blobs are seldom accessed. As a compromise, I would suggest to place your blobs into a separate table, it will increase the size of your main database, but will also speed up the acccess to your blobs without interfering with

Re: [firebird-support] An unhandled exception of type 'System.NotSupportedException' occurred in FirebirdSql.Data.FirebirdClient.dll

2014-02-10 Thread Frank Schlottmann-Gödde
Am 10.02.2014 08:31, schrieb nkd...@gmail.com: I am creating a project windows runtime component with c# , I want to create a embedded DB so i am using Firebird-2.5.2.26540-0_x64_embed and .net provider NETProvider-2.5.2-CF . every time i am getting same error: An unhandled

Re: [firebird-support] Firebird client error ibxeUnknown

2013-08-18 Thread Frank Schlottmann-Gödde
On 17.08.2013 16:06, Wolfgang Kluge wrote: Good evening. I will greatly appreciate if somebody could help me with this. The Delphi 5 source code: procedure T_main.LoadForm( FormClass: TFormClass; FormName: String; Splash: Boolean ); var ChildForm : TForm; nReturn : Integer;

Re: [firebird-support] Python FDB 1.4 not returning the first record

2013-08-16 Thread Frank Schlottmann-Gödde
On 16.08.2013 11:50, greatdaydan wrote: I have just started using Python and have discovered FDB. Super-duper! Now I can create a web interface for one of my applications. I am using the FDB 1.4 documentation to learn how to use FDB. A 'select * from table' returns all but the first record.

Re: [firebird-support]

2013-05-03 Thread Frank Schlottmann-Gödde
Am 30.04.2013 14:18, schrieb Lepage, Pierre: Hi, We are using Firebird Client 1.0 on one or a lot of computers in the company. Actually, we analyze the situation because we plan to migrate every computers in the company from Windows XP to Windows7 64bits. We need to know if Firebird

Re: [firebird-support] Delphi XE2. Migrating from IBX components

2013-03-25 Thread Frank Schlottmann-Gödde
Am 08.03.2013 16:52, schrieb Sergio: Hello I have all my apps in Delphi with the IBX components and ClientDataSets to conect with a FB Database. Since long time ago IBX creator says it doesn't support FB. So far I can work with very simple queries fine. But now I'd like to use a component

Re: [firebird-support] Delphi XE2. Migrating from IBX components

2013-03-25 Thread Frank Schlottmann-Gödde
Am 25.03.2013 22:49, schrieb Frank Schlottmann-Gödde: Am 08.03.2013 16:52, schrieb Sergio: Hello I have all my apps in Delphi with the IBX components and ClientDataSets to conect with a FB Database. Since long time ago IBX creator says it doesn't support FB. So far I can work with very simple

Re: [firebird-support] Authentication = Trusted, where to learn more

2012-12-02 Thread Frank Schlottmann-Gödde
On 11/30/2012 10:47 AM, Brian Dunstan wrote: Hi, Where can I learn about using trusted authentication? Thanks in advance, Brian Firebird release notes: http://firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb210-wintrusted hth Frank -- Fascinating creatures, phoenixes, they can carry

Re: [firebird-support] Learning Curve

2012-11-08 Thread Frank Schlottmann-Gödde
On 11/08/2012 07:20 PM, Marsha wrote: Hi all, Can anyone recommend some introductory tutorials, online courses, and/or prerequisite information I need to learn before diving into Firebird? http://www.firebirdfaq.org/faq324/ is a good starting point and if all else fails

Re: [firebird-support] Slow query with like '%xxx%' clause

2012-07-13 Thread Frank Schlottmann-Gödde
On 13.07.2012 14:22, Tupy... nambá wrote: Wenn man die Vorschlage aus Herrn Gödde folgen wird, man kann ein Googler bauen. d.h., wenn man insert oder update macht, dann eine Tabelle mit Suchwörte und Index wird aktualiziert.. stimmt das ? Genau, but don't forget the delete :-) If

Re: [firebird-support] Reference manual in on place

2012-07-12 Thread Frank Schlottmann-Gödde
On 07/12/2012 06:17 PM, K Z wrote: Hello, Does anyone knows where i can find a full reference manual of the FB2.5? For example, i tried to search the command SOUNDEX in the FB site and inside the documents mentioned at http://www.firebirdsql.org/en/reference-manuals/ (Reference Manuals

Re: [firebird-support] The data is not displayed correctly using UTF8

2012-02-24 Thread Frank Schlottmann-Gödde
On 23.02.2012 19:23, Sergio Garcia wrote: Hi. We created a DB with UTF8 as Default character set (SS v2.5.1.26351). In FlameRobin we see the data correctly (Canadá), however from the Delphi (v6), using native controls at palette Interbase, the data is not displayed correctly (Canadá).

Re: [firebird-support] Re: Precompiling with gpre and Firebird 2,5

2012-01-03 Thread Frank Schlottmann-Gödde
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 31/12/11 16:18, cartonace wrote: Hello Frank Thanks for the swift reply but the environment variables were/are already set and it still prompted me for a user name and password. I think the security has been beefed up somewhere between 1.5

Re: [firebird-support] Precompiling with gpre and Firebird 2,5

2011-12-31 Thread Frank Schlottmann-Gödde
On 30.12.2011 13:39, cartonace wrote: I am trying to migrate to 2.5 from 1.5. I am updating a c program that writes data to a table. When I try to run the program I get the following error: Your user name and password are not defined. Ask your database administrator to set up a Firebird

Re: [firebird-support] Re: selecting a field by name (using a var)

2011-11-07 Thread Frank Schlottmann-Gödde
Am 07.11.2011 16:27, schrieb Tomasz Tyrakowski: Hi, One small improvement. Instead of execute statement :loc_sql into :out_fecha; I'd recommend for execute statement :loc_sql into :out_fecha do suspend; and additional take a look at

Re: [firebird-support] Re: Firebird 2.5 crashing after calling UDF

2011-11-04 Thread Frank Schlottmann-Gödde
Am 26.10.2011 02:49, schrieb sir_wally_lewis: the same unaltered code works under CenTos 64 bit in 2.1 though. Still do not understand why my freepascal UDF is crashing. I have added an issue to the tracker http://tracker.firebirdsql.org/browse/CORE-3651 cheers FSG -- Fascinating creatures,

Re: [firebird-support] Re: Firebird 2.5 crashing after calling UDF

2011-11-01 Thread Frank Schlottmann-Gödde
will create a simplified testcase and add it to the tracker asap. mit freundlichen Grüßen Frank Schlottmann-Gödde -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers and they make highly faithful pets. - J.K. Rowling

Re: [firebird-support] Re: Firebird 2.5 crashing after calling UDF

2011-10-26 Thread Frank Schlottmann-Gödde
On 26.10.2011 02:49, sir_wally_lewis wrote: Thanks for the fixes to my C library Tomasz and for your help. All my C Library is originally extracted from FreeUDFLibC and I added extra functions. There were errors in the C Code that I was unaware of. Amazing that the same unaltered code

Re: [firebird-support] Re: Pascal UDF passing timestamps/strings

2011-10-11 Thread Frank Schlottmann-Gödde
name 'dt_topas', pascaldatetofbdate name 'dt_tofb'; end. --- mit freundlichen Grüßen Frank Schlottmann-Gödde -- Fascinating creatures, phoenixes, they can carry immensely heavy loads, their tears have healing powers

Re: [firebird-support] Pascal UDF passing timestamps/strings

2011-10-07 Thread Frank Schlottmann-Gödde
On 07.10.2011 10:44, sir_wally_lewis wrote: Has anyone successfully written a pascal UDF to pass timestamps/strings without using the ibobjects library? Yes, what problems do you face? mit freundlichen Grüßen Frank Schlottmann-Gödde -- Fascinating creatures, phoenixes, they can carry