[firebird-support] Trigger created as inactive

Hi  All I have a script that creates my database structure.  I create the following trigger for a table but unlike my other triggers this one is created 'inactive'.  I can run 'ALTER TRIGGER FilterStore_Inc ACTIVE' and activate the trigger without issue. The table and sequence are already

Re: [firebird-support] How to "remap" the count datatype from BIGINT to INTEGER in firebird 3

I have dealt with this before on large projects (FB 2.0 / 2.5).  Its not really a big deal.  Just do a (text) search through your .dfm (form/datamodule) files for the field and edit the text files to change the data type to the correct version.  You can even automate the process as required.

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

Hi Chris I haven't been following the thread, so this may be totally of track but, Embedded only supports one connection.  If you try to connect a second instance you get the database unavailable error message you are seeing.  Is it simply that you have something else (your app or a DB

Re: [firebird-support] Firebird startup issue

Hi Karol Yes that fixes it, although I now have to wait 2 minutes after starting my computer before I try and use Firebird, but I guess its not a big deal as I don't reboot often. Thanks Rob

[firebird-support] Firebird startup issue

Hi I have just upgraded my PC (everything new except the HDD).  Now when I boot my computer the Firebird service shows as started but looking at the log I see the following entries TAU    Fri Feb 01 16:46:47 2019     INET/inet_error: bind errno = 10013 TAU    Fri Feb 01 16:46:47 2019    

[firebird-support] Service name

Hi All I am trying to write something that checks if the Firebird service is running (Windows app).  On my machine (running 2.5 super classic) it shows as 'FirebirdServerDefaultInstance'.  Do other versions (super server, FB 3.0 , 4.0) use different names for the service ? Would I be safe

Re: [firebird-support] Remote Event not working on Windows Server 2003

Hi I haven't used FB events for a while but most likely the issue is security / firewall.  Your Server OS is likely blocking the additional Port needed for FB events.  What we used to do was specify a fixed 'RemoteAuxPort' in the FB conf file and then specifically unblock that port in the

Re: [firebird-support] Firebird:Search All Fields In All Tables For A Specific Value

On 12/02/2018 10:03 AM, iorip...@sina.com [firebird-support] wrote: > > Do not know table name, do not know field name. > > Only know A Specific Value. > > How to find out witch tables and fields include this Value? > > Thank you! > Hi Use the RDB$ (firebird system) tables to first get a

Re: [firebird-support] Re: How to get a list of columns from another select

Hi We do this all over the place. We have a custom grid component that has a save as option, so the grid could be displaying anything. We simply iterate the columns collection of the grid component. If your custom Query is displayed in a grid you should be able to do this in your dev

Re: [firebird-support] internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 239)

Hi I am no expert in these things but I thought that DB file access that was not 'through' the FB server while FB server is running could cause DB file corruption. With our systems we always exclude the FDB from virus scanning and external backup applications. We have a FB backup (GBak) run

Re: [firebird-support] Re: Issue with Database Cache Size on FB 3.0

Hi Fabian Can't see your screen shot but FB usage at 2GB sounds like the limit for a 32Bit app. Have you installed the 32Bit version of FB accidentally? Thanks Rob On 2/06/2016 11:12 a.m., fabia...@itbizolutions.com.au [firebird-support] wrote: Dmitry Something funny is going on

[firebird-support] Temporarily disable constraints

Hi Is it possible to temporarily disable a FK constraint? I have found a couple of requests for this feature dated 2009 but these still show as open. Did this functionality ever get implemented ? It would save me a lot of work :) Thanks Rob

Re: [firebird-support] date format

OOps sorry, wrong email address :) On 16/10/2015 11:24 a.m., 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: Â > http://www.sysprobs.com/change-date-format-windows-7-ddmm Why does this matter to this list? Sean

[firebird-support] date format

http://www.sysprobs.com/change-date-format-windows-7-ddmm -- - Robert Martin Development Manager Ph 03 377-0495 fax03 377-0496 email r...@chreos.com Wild Software Ltd www.chreos.com Please forward all support queries to supp...@chreos.com so we may respond to your

Re: [firebird-support] SQL for TCC

Sorry set the SQL to the wrong 'support' email. Please ignore. Thanks Rob On 27/08/2015 12:07 p.m., Robert martin r...@chreos.com [firebird-support] wrote: UPDATE CsItem SET YeRef = 7051 WHERE ItemRef IN (688421, 688413, 688405, 688438, 688446) To run the above - On any ONE machine

[firebird-support] SQL for TCC

UPDATE CsItem SET YeRef = 7051 WHERE ItemRef IN (688421, 688413, 688405, 688438, 688446) To run the above - On any ONE machine. - Go to Maintenance Advanced SQL Entry - Cut and paste the SQL into the 'SQL String to be processed' box - Click Process - The SQL has run so you can now close the

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

Hi I don't know what the error message is, you didn't include it! but it is likely your join is wrong and returning one of every detail record for every header (i.e. 78000 * 3000 records !) Check your query and make sure the detail records are linked to the master correctly (i.e. JOIN detail

Re: [firebird-support] Need Speed Optimization for SQL

Wow ! Do you have an index on CRM_JOB_ITEMS.PK_JOB_ITEMS ? On 16/04/2015 10:29 a.m., Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: @Rob: Your SQL is taking 28 seconds... On Thursday, 16 April 2015 3:56 AM, Robert martin r...@chreos.com [firebird-support] firebird

Re: [firebird-support] Need Speed Optimization for SQL

Hi Try replacing your IN statement with an EXISTS clause. Something like CRM_DOCUMENT_HEADER.DOCUMENT_TYPE = 1 AND EXISTS(select PK_JOB_ITEMS from CRM_JOB_ITEMS where PK_JOB_ITEMS = CRM_DOCUMENT_ITEMS.FK_JOB_ITEM and FK_JOB = '{8BDDED49-8509-48C1-A169-B7E68A74C230}' ROWS 1) Cheers Rob On

[firebird-support] Chinese Pinyin to Unicode

Hi I have some data that appears to be Chinese entered using Pinyin. The data is stored in a FB 2.0 DB in Charset NONE. We want to port the data over to a FB 2.5 DB with Charset UTF8. Just pumping the data does not work. We thought we had solved it by Exporting from the DB to a UTF8 formatted

[firebird-support] Chinese Code page / Unicode conversion

Hi Our product used to run on FB 2.0 with the character set configured to 'NONE'. We released a new version using FB 2.5 and character set to UTF8. One of our sites had been storing Chinese data in their database using the Chinese langauge pack and Windows XP. After converting the database

[firebird-support] TCP connection issue

Hi The firebird log file on a newly installed machine shows the following messages MAIN-PCFri Jan 09 15:01:03 2015 INET/inet_error: read errno = 10054 MAIN-PCFri Jan 09 15:01:04 2015 Unable to complete network request to host Main-PC. Error reading data from the

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

i * How does your gbak restore call look like? GBak -C -User %1 -Pas %2 G:\FBDump\OCCEasyPos.fbk LocalHost:F:\DB\Kaufmann\Uddannelse\OCCEasyPos.fdb -v -rep -o -FIX_FSS_METADATA ISO8859_1 -fix_fss_data ISO8859_1 -y G:\FBDump\ ;RestoreEasyPos.txt Have you tried it with the -G flag. This