RE: [firebird-support] Proper Case Function for Firebird 2.5.4 and above

I use Database Workbench for all my Firebird Development and testing. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Monday, July 15, 2019 7:49 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] Proper Case Function for Firebird

[firebird-support] Proper Case Function for Firebird 2.5.4 and above

Greetings All, We are currently on Firebird 2.5.4 and hope to move to Firebird 3.0 by the end of this year once I determine what all needs to take place in preparation to do so. One of the things we did when moving from Firebird 1.5 to 2.5 was to remove the dependencies on external UDF's from

[firebird-support] Installing Firebird during the installation of my product

Greeting All, I have a small application written in Delphi that uses Firebird, It is intended to be used on a single computer currently. Possibly moving the database to a server later which would mean installing firebird on the server and then a separate install of Firebird on the client.

[firebird-support] Cannot create simple table

Greetings All, Firebird v2.5.4 Trying to create a simple table and receive this error: unsuccessful metadata update cannot create index PK_CUR_CASE_INV_NON_JUD_CNT while executing: ALTER TABLE CUR_CASE_INV_NON_JUD_CNTY ADD CONSTRAINT FK_CUR_CASE_INV_RPT3 FOREIGN KEY (REPORT_ID)

RE: [firebird-support] How does one connect to Firebird 2.5.4 that is on a windows server from a linux client?

Yes I have, about 6 months ago I went through the entire guide. I went back and looked just now and directed the user to look at the Working with Databases section of the quick start guide. I hope it is what he is needing. I know nothing about Linux. Thanks, Mike Have you read Fireburd

[firebird-support] How does one connect to Firebird 2.5.4 that is on a windows server from a linux client?

I have one person in our office that uses a Linux work station that wants to connect to our Firebird database v 2.5.4 that is on a Windows 2012 Server. Can anyone share information or a link on how that can be done? I would really appreciate any help. Thanks, Mike

RE: [firebird-support] Why does "IF (NOT(EXISTS(SELECT 1..." not work as expected?

Greetings Thomas, Yes, I first have to get my tables cleaned up and then add cascading delete foreign key constraint on PER_ADDRESS referencing ADDRESS Thanks, Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, May 12, 2016 12:29

RE: [firebird-support] Why does "IF (NOT(EXISTS(SELECT 1..." not work as expected?

ugh your reply again and then see if I can get this to work. Thanks again, Mike -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, May 11, 2016 11:51 PM To: 'stwizard' stwiz...@att.net [firebird-support] Subject: Re: [fireb

[firebird-support] Why does "IF (NOT(EXISTS(SELECT 1..." not work as expected?

Greetings All, Firebird 2.5.4 Here is my simple Stored Procedure. It simply looks for any address in the ADDRESS table that starts with '0 ' as in "0 SE ADAMS ST" and COUNT(*) how many time it might have been used in PER_ADDRESS and if COUNT() > 0 delete the links from the PER_ADDRESS

RE: [firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

Arno, Thanks for your pointing out the issue with my SQL statement. Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, April 06, 2016 4:36 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] SQL Error Code -104:

RE: [firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

-104: What is wrong with this rather simply SQL? On 06.04.2016 o 22:03, 'stwizard' stwiz...@att.net [firebird-support] wrote: > SELECT DISTINCT P.AREA_CODE, P.PHONE_NO, > > (SELECT COUNT(*) > > FROM PHONE P2 > > WHERE P2.PHONE_ID = P.PHONE_ID) AS CNT > > FROM PH

[firebird-support] SQL Error Code -104: What is wrong with this rather simply SQL?

SELECT DISTINCT P.AREA_CODE, P.PHONE_NO, (SELECT COUNT(*) FROM PHONE P2 WHERE P2.PHONE_ID = P.PHONE_ID) AS CNT FROM PHONE P WHERE P.AREA_CODE IS NOT NULL GROUP BY 1, 2 HAVING (SELECT COUNT(*) FROM PHONE P3 WHERE

RE: [firebird-support] How do find duplicates in a table?

ort@yahoogroups.com Subject: Re: [firebird-support] How do find duplicates in a table? 04.02.2016 20:09, 'stwizard' stwiz...@att.net [firebird-support] wrote: > How do I form a SQL Select statement that will return which records in > my PERSON table have duplicate SOC_SEC_NO. RTFM GROUP B

[firebird-support] How do find duplicates in a table?

Greetings All, How do I form a SQL Select statement that will return which records in my PERSON table have duplicate SOC_SEC_NO. In other words I need a list of persons where the social security number appears in the database more than once. Some SOC_SEC_NO may be null which I do not

RE: [firebird-support] How do find duplicates in a table?

Thanks Woody much simpler. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, February 04, 2016 1:42 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] How do find duplicates in a table? Try this instead: Select Soc_Sec_No,

[firebird-support] How to return a count using a SQL Select Statment

This stored procedure returns: PREP Shawnee KS 10/01/2015 - 10/06/2015 248 RES Wyandotte KS 10/01/2015 - 10/15/2015 4 SET TERM ^^ ; CREATE PROCEDURE SPS_DOCKET_WORKLIST_LIST returns ( WORKLIST_NAME VarChar(60), WORKLIST_COUNT SmallInt) AS begin FOR

RE: [firebird-support] How to return a count using a SQL Select Statment

Ed, So simple wasn’t it ;>) Thanks, Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, November 12, 2015 9:52 AM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] How to return a count using a SQL Select

RE: [firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

an error or what? regards, Karol Bieniaszewski Oryginalna wiadomość Od: "'stwizard' stwiz...@att.net [firebird-support]" <firebird-support@yahoogroups.com> Data: 03.11.2015 14:59 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: [firebird-su

[firebird-support] Why can't I have a SUSPEND or UPDATE in the same Stored Procedure?

Greetings All, Firebird v 2.5.4 Many times I would like to run a report before I do an update. Why can’t I allow for both in one stored procedure? Look at the end of this stored procedure where I use V_REPORT. Thanks, Mike SET TERM ^^ ; CREATE PROCEDURE X_CHK_LEGAL_CASE_DATE

RE: [firebird-support] How can I see which query within a stored procedure execution takes the longest time?

Hi Tim, Thanks for the reply. You mentioned that you did it with a logging procedure. Can you share what you exactly what you did to accomplish this? Mike

[firebird-support] Error while attempting to add a Primary key to a table that has no records

Greetings, Firebird v2.5.4 I use Database Workbench v 5 as my database development tool. I have this table which is currently empty (0 rows). It originally had a primary key on TRUST_STATEMENT_ID and ORIGINAL_PMT_ID CREATE TABLE TRUST_STATEMENT_PMT_BACKOUT_CHK (

RE: [firebird-support] Error while attempting to add a Primary key to a table that has no records

Hmmm, I tried again this evening and it would allow me to add the primary key. Very strange. Since we moved to a new windows server 2012 R2 and upgraded to v2.5.4 firebird running Classic Super Server from v1.5.4 running Classic Server, could any of that have anything to do with it?

RE: [firebird-support] How to Extract Filename from file path inside a stored procedure?

Mark, Thank you and the other gentleman that replied as I was able to create my own SP to do exactly what I needed to do and it works in both version of Firebird. Mike

[firebird-support] How to Extract Filename from file path inside a stored procedure?

Greetings All, Firebird v1.5.3 and v2.5.4 I need a way to extract just the file name for a given file path either by code in a stored procedure or by calling a UDF in the stored procedure. Example, I need to extract "SNKSAid.dat" from "K\Frontline\Documents\Aids\SNKSAid.dat" Any

RE: [firebird-support] Setting up FreeAdhocUDF on an Ubuntu Server

Although I cannot help you, you might try this email address h...@freeadhocudf.org at www.FreeAdhocUDF.org as I found them very helpful in getting my issue resolved a few weeks back

RE: [firebird-support] RETURNING_VALUES optional variables?

Jorge, I have done a SELECT FROM instead of an EXECUTE PROCEDURE when I do not need all the fields returned in a stored procedure. This will only work I think if the SP has a SUSPEND; in it. SELECT R_PRINC_BAL, R_FEE_BAL FROM SPS_CASE_CUR_BAL(:ACCT_ID, :CASE_ID, NULL, 1)

RE: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing? (SOLVED)

Greetings Set, Set you are truly an asset to this list and in my book rank at the top of the list with Helen and Mark. I have learned so much from you three in the last few months. I of course do not discount any others that send out helpful replies as I can learn from all (Trust me).

[firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

Greetings All, First off, I would like to thank all members of this list for taking the time to reply on this list. Much appreciated… Really need some help on this one folks. Not sure if this is related to IN, NOT IN vs EXISTS, NOT EXISTS or not. I have a main stored procedure (not

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined

Helen, Thanks for all the time you took to share your ideas in this post and the prior concerning this issue. I was NOT able to use this: ALTER EXTERNAL FUNCTION funcname [ENTRY_POINT 'new_entry_point'] [MODULE_NAME 'new_library_name']; It would allow me to do this, but I was still

[firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined

Greetings All, On a new Windows 7 64 bit computer I installed Firebird v2.5.4 64 bit I then installed the FreeUDFLib 64bit functions I then did a firebird v1.5.3 backup of the metadata only and then restored this on firebird v2.5.4. I made sure to use the following switches during the

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined

Correction: I met to say I then installed FreeAdhocUDF not FreeUDFLib library. And according to their website I also install the 4 icu*44FAU.dll files to the Bin folder. http://freeadhocudf.org/documentation_english/dok_eng_icu.html I’ve rebooted the computer too, so I’m at a loss

[firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Character Set and Collations

Greetings All, I recently did a metadata only backup of my Firebird 1.5.3 database. Please note this database has a character set of NONE and anywhere where this could be set has remained NONE and no Collation was set either. NOTE: We DO NOT use BLOBs we use VarChar for our memo fields.

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Sub-Selects that reference the same tables

Set, I had to search for what a CTE was as I have not heard of it and no wonder it (CTE Common Table Expression) was introduced in Firebird v2.1 although it was available in other SQL Server engines for years. This looks to be of great interest to me once we are up and running on v2.5.4.

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Using 2.5.4 FB Client to access a 1.5.3 DB database (Follow-Up)

to 2.5.4 - Using 2.5.4 FB Client to access a 1.5.3 DB database (Follow-Up) At 08:36 a.m. 30/07/2015, 'stwizard' stwiz...@att.net [firebird-support] wrote: The new Windows 2012 R2 64 bit server will have the 64 bit Firebird server v2.5.4 install on it (But alternately may have Firebird 32 bit

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Using 2.5.4 FB Client to access a 1.5.3 DB database (Follow-Up)

Thanks Neil for your reply, Thanks to all who take the time to reply to the following. I have a follow up question that goes along with this subject and of course anyone can chime in. The new Windows 2012 R2 64 bit server will have the 64 bit Firebird server v2.5.4 install on it (But

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - CHECK Constraint Change Question

2015 08:15:35 -0500, 'stwizard' stwiz...@att.net [firebird-support] firebird-support@yahoogroups.com wrote: Greetings All, In the Firebird 2 Migration Installation guide http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-I nstallation.pdf on page 4 it states

RE: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4

, 'stwizard' stwiz...@att.net [firebird-support] firebird-support@yahoogroups.com wrote: Thank you Helen for your reply, I'll do as you suggest and read the release notes (in order) and I may have question after reading them. Just know that upgrading the database (apart from the metadata character

[firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

Greetings All, In the Firebird 2 Migration Installation guide http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf on page 8 under the performance section it

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

Set, thank you for the very detailed response as it is VERY helpful and informative. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Friday, July 24, 2015 7:49 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Upgrade Firebird

RE: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

1.5.3 to 2.5.4 - Existence Predicates NOT IN Question On 24-7-2015 13:25, 'stwizard' stwiz...@att.net [firebird-support] wrote: Greetings All, In the Firebird 2 Migration Installation guide http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf

[firebird-support] FreeUDFLib 64 Bit version

Greetings, Does anyone know where I can get a 64 bit version of the FreeUDFLib.dll? I know Jeff Overcash (TeamB) has done it per this link, but I have no idea how to get ahold of him http://codeverge.com/embarcadero.interbase.general/freeudflib-and-developing-udfs/1083840 Thanks,

RE: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4

Hi Marianne and thank you for your reply, I found the link to IBSuregeon yesterday and reviewed it, I’m already on dialect 3 and although FBClone sounds intriguing, it also scares me if someone like Helen does not recommend it. Mike From: firebird-support@yahoogroups.com

RE: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4

, July 23, 2015 2:56 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4 At 11:42 p.m. 22/07/2015, 'stwizard' stwiz...@att.net [firebird-support] wrote: Greetings All, Im needing to get underway way with preparing my Firebird 1.5.3

[firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4

Greetings All, I'm needing to get underway way with preparing my Firebird 1.5.3 database for migration to 2.5.4. Is there any documentation available that discusses what all needs to be looked at before backing up the database in 1.5.3 and restoring to 2.5.4? Possibly a migration

RE: [firebird-support] Firebird 1.5.3 on Windows 2012 R2 Server

I have not heard back from anyone on this and the office is asking me to provide an answer on this. So please, can someone that has experience with this or know for sure, let me know? Thanks, Mike From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent:

Re: [firebird-support] Firebird 1.5.3 on Windows 2012 R2 Server

Guys, My email client blew up and I lost all of my inbox (outlook express) on windows XP back on Jun 30th. I just got my new computer (Windows 7) setup using MS Outlook for my email client. I had this email up ready to reply (on the old computer) when this happened, so I copied this off