Greetings All,
Can anyone tell me if Firebird 1.5.3 will run on Windows 2012 R2 Server?
Our Delphi application has run since 1997 on one version or another of windows
server. It is currently on Windows 2003 Server and we have had no issues at
all. Our office is wanting to install a new
Greetings Bogdan,
Yes, SUBSTR() does exists in v1.5 so I converted it successfully, I've alwasy
used SUBSTRING() before. However, when I tried to run a few simple comparisons
with 1 character off in the strings it always returned OK for the result. So I
declared a few new variables
According to this I was correct - startpos and length must be integer literals
http://www.firebirdsql.org/refdocs/langrefupd15-substring.html
- Original Message -
From: 'Bogdan' bog...@mordicom.si [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Thursday, June 25,
Thanks Svein I'll dig into this to see if something like this might work.
Mike
- Original Message -
From: Svein Erling Tysværsvein.erling.tysv...@kreftregisteret.no
[firebird-support]
To: firebird-support@yahoogroups.com
Sent: Wednesday, June 24, 2015 3:06 PM
Subject: Re:
Greetings All,
I would like to pass into a stored procedure two social security numbers for
comparison and have the result tell me if one character has changed, or if two
characters were switched or if it does not compare at all.
Has anyone done anything like this they could share? Or is it
Greetings All,
Setting up a new Windows 7 computer and installed Delphi XE5 and Firebird 1.5.6
I am able to open and compile my Delphi source just fine.
When I try to connect to the database using the TIBDatabase component I receive
the connection rejected by remote interface error
library as GDS32.DLL for legacy app
support? selected. The GDS32.DLL is required to use the Interbase components
in Delphi.
All is well now and thought I should let others know what I had to do.
Mike
- Original Message -
From: 'Softtech Support' stwiz...@att.net [firebird-support
Greetings All,
What is the best way in a stored procedure to add a minute or a few seconds to
a TimeStamp?
Thanks,
Mike
---
This email has been checked for viruses by Avast antivirus software.
http://www.avast.com
:
tsTest = (:tsTranCreateDate - (1.0/86400.0));
Incorrectly returns 10/31/2012 7:50:15 AM
Mike
- Original Message -
From: 'Softtech Support' stwiz...@att.net [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 10, 2015 3:02 PM
Subject: Re: [firebird
In the code provided below I meant to type 2012 not 201
- Original Message -
From: 'Softtech Support' stwiz...@att.net [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 10, 2015 3:01 PM
Subject: Re: [firebird-support] Add 1 minute to a TimeStamp
Greetings All,
Firebird 1.5.3
Should be elementary but, I'm drawing a blank on how to accomplish this.
I have a table (ACCT_CASE_COURT) that contains these fields (among others):
ACCT_CASE_COURT_IDINTEGERNOT NULLPK
ACCT_IDINTEGERNOT NULL
CASE_IDSMALLINTNOT NULL
Hi Martijn,
I did finally come up with this
SELECT DISTINCT(ACC.CASE_NUMBER),
(SELECT COUNT(ACC2.ACCT_CASE_COURT_ID) FROM ACCT_CASE_COURT ACC2 WHERE
ACC2.CASE_NUMBER = ACC.CASE_NUMBER) AS CNT
FROM ACCT_CASE_COURT ACC
GROUP BY 1
Nut, I like yours better.
Now I need to exclude any
Good Morning All,
I'm back from vacation and wanted to check in to see if there was any other
ideas on this issue since I sent this reply on Oct 14th.
Thanks,
Mike
- Original Message -
From: 'Softtech Support' stwiz...@att.net [firebird-support]
To: firebird-support
Greetings All,
Firebird 1.5.3 (Yes I know it is old)
Using the following syntax with 09/01/14 and 09/04/14 for the parameters
fetches 20 distinct records
SELECT DISTINCT DCD.ACCT_ID, AC.CLT_ID
FROM DEBTOR_CASE_DEBT DCD
JOIN ACCT_CASE AC ON AC.ACCT_ID =
Greetings Martijn,
Just happening to be testing this in Database Workbench. Have used this
product for years and just love it.
Thanks for you reply.
So my second SQL should have been as follows? It results in an error Dynamic
SQL Error SQL error code = -104 Token unknown - line 1, char 34 ,
Hi Martijn,
I knew I was going to get in trouble by not providing enought information as I
thought by proving less it would be just a little bit clearer to understand, my
bad...
Let's start over with an simplified explanation of the tables:
ACCT_CASE: Case Management table
ACCT_IDINTEGER
Hi Martijn,
I want to count the number of records in the DEBTOR_CASE_DEBT table (not DEBT)
where the ACCT_ID, CASE_ID and DEBT_NO are distinct and specific to CLT_ID.
Is this possible in v1.5.3?
If not and I need to create a view and COUNT() that, can you provide an example
or tell me where
Greetings All,
Can anyone tell be if Firebird v 1.5.3 will install and run effectively on
Windows Server 2012?
It is currently being ran on a Windows 2003 Server and they are wanting to
upgrade to a new server and I just wanted to see if there would be any issues.
Thanks to any who can shed
To: firebird-support@yahoogroups.com
Cc: Softtech Support
Sent: Friday, December 06, 2013 8:52 AM
Subject: Re: [firebird-support] Firebird v1.5.3 on Windows Server 2012
On Fri, 6 Dec 2013 08:33:25 -0600
Softtech Support stwiz...@att.net wrote:
Can anyone tell be if Firebird v
Greetings All,
v1.5.3
I need to know how many tables, indicies, functions, stored procedures, etc are
in my Firebird database.
Is there a quick way to determine this?
Thanks,
Mike
[Non-text portions of this message have been removed]
On Wed, Jul 17, 2013 at 1:55 PM, Softtech Support stwiz...@att.net wrote:
**
Greetings All,
v1.5.3
I need to know how many tables, indicies, functions, stored procedures,
etc are in my Firebird database.
Is there a quick way to determine this?
See here
Thanks, Looks like it is working now. Appreciate your guidance
- Original Message -
From: Tupy... nambá
To: firebird-support@yahoogroups.com
Sent: Tuesday, June 25, 2013 2:23 PM
Subject: [firebird-support] GBak Backup Restore Problem
Dear Friends,
We have a
time compilation of
EXECUTE STATEMENT.
--- In firebird-support@yahoogroups.com, Softtech Support stwizard@...
wrote:
Thanks for your reply.
I should have mentioned that this stored procedure is used to generate a
Stair-Step Financial Report (My first attempt at such a report I might
Month Value
2. use PSQL statement: EXECUTE STATEMENT, you can read about it in
Firebird-2.5-LangRef-Update.pdf
--- In firebird-support@yahoogroups.com, Softtech Support stwizard@...
wrote:
In Delphi I have the ability to reference a field using FieldByName()
inside a For loop like
Greetings All,
Firebird v1.53
I need to programatically (Using Delphi) retreive the input parameters from a
stored procedure. Is this possible?
Thanks,
Mike
[Non-text portions of this message have been removed]
I figured it out...
SELECT P.RDB$PARAMETER_NUMBER,
P.RDB$PARAMETER_NAME
FROM RDB$PROCEDURE_PARAMETERS P
WHERE P.RDB$PROCEDURE_NAME = 'SPS_COTM_ACTIVITY_RPT'
AND P.RDB$PARAMETER_TYPE = 0
- Original Message -
From: Softtech Support
To: Firebird Support
Sent: Friday
'
AND P.RDB$PARAMETER_TYPE = 0
- Original Message -
From: Softtech Support
To: Firebird Support
Sent: Friday, May 03, 2013 8:55 AM
Subject: Can I retreive parameters from a stored procedure?
Greetings All,
Firebird v1.53
I need to programatically (Using Delphi) retreive
or
function that can find the second occurance of value passed in
On Thu, 14 Mar 2013 10:00:17 -0500, SoftTech mi...@softtechks.com
wrote:
Greetings All,
I would like to pass in a string and a substr and the position of where
the
x occurrence is.
Example:
String
Firebird 1.5
Anything available to find an ASCII_CHAR(13) in a given string and return
the position of it?
Thanks,
Mike
On Thu, 14 Mar 2013 10:47:57 -0500, SoftTech mi...@softtechks.com
wrote:
Firebird 1.5
Anything available to find an ASCII_CHAR(13) in a given string and
return
the position of it?
I think the answer is the same as my answer to your previous question :)
Mark
Greetings All,,
Using Firebird 1.5
I have a stored procedure where I pass in a begin and end date.
Is there way to process each date within a for or while loop so that I can
return a record for each date regardless if I find any data to report on for
that date?
Any tips on how to code this
Perfect, thanks
- Original Message -
From: Scott Morgan
To: firebird-support@yahoogroups.com
Sent: Friday, February 08, 2013 11:20 AM
Subject: {Disarmed} Re: [firebird-support] For loop or while loop inside of a
stored procedure?
On 08/02/13 16:54, SoftTech wrote
Greetings Martijn and Mark,
You're exactly right that fixed the problem.
Mark it also fixed this error
ISC ERROR CODE: 335544606
ISC ERROR MESSAGE:
expression evaluation not supported
Thanks to both of you for taking the time to respond,
Mike
- Original Message -
From: Martijn
Greetings All,
Using Firebird 1.5.3
D.CREATE_DATE is defined as a TimeStamp in the database.
V_END_DATE is an input parameter defined as Date
V_END_DATETIME is an input parameter defined as TimeStamp
I have a stored procedure with the following execute statment
EXECUTE STATEMENT 'SELECT
:
library Softtech;
uses
SysUtils,
Classes,
SQLFunctions in 'SQLFunctions.pas';
{$R *.RES}
exports SQLCondParamRepl;
begin
end.
Unit Source
] Replacement of parameters within a
stored procedure
On 14-12-2012 21:49, Dmitry Kuzmenko wrote:
Hello, SoftTech!
Saturday, December 15, 2012, 12:36:32 AM, you wrote:
S I have used Execute Statement in the past. Using it to run SQL
S statements built on the fly. What my
Firebird v1.5
A SQL statement is stored in a table.
Inside of a stored procedure I need to retrieve this SQL statement, replace
:Param1 and :Param2 with actual values then execute it. I will of course
know the value, just don't know how to replace the :Param1 and 2 with the
value.
SELECT
Kuzmenko
To: firebird-support@yahoogroups.com
Sent: Friday, December 14, 2012 2:14 PM
Subject: {Disarmed} Re: [firebird-support] Replacement of parameters within a
stored procedure
Hello, SoftTech!
Friday, December 14, 2012, 10:01:51 PM, you wrote:
S I cannot do what I need
I use Database Comparer by www.clevercomponent.com they have a stand alone
utility, an ActiveX component as well as a VCL component so you can develop
your own interface which is what I have done.
- Original Message -
From: Steve Cookson
To: firebird-support@yahoogroups.com
Johansen
To: firebird-support@yahoogroups.com
Sent: Monday, October 29, 2012 4:06 PM
Subject: {Disarmed} [firebird-support] Re: UNION prevents all records from
being pulled to the results
SoftTech wrote:
The SQL that follows pulls these results: (These results are missing 5
Greetings All,
The SQL that follows pulls these results: (These results are missing 5
records from the second select of the union)
FEE_CODEAMT_EARNED_AGENCYSHOW_IN_PMT_DIST_PLANFEE_CATEGORY
CCO27610
SVC1.1710
SVC3010
This is the SQL statement:
Greetings All,
Does anyone know how I can accomplish this from within a stored procedure?
I need to convert a timestamp 01/26/2012 05:38:32am to a string
01262012053832.
Will actually be using CURRENT_TIMESTAMP within the stored procedure.
Still using Firebird 1.5.3 (Hope to convert down the
I think I have something figured out...
- Original Message -
From: SoftTech
To: firebird-support@yahoogroups.com
Sent: Thursday, January 26, 2012 5:50 AM
Subject: {Disarmed} [firebird-support] How do I convert a timestamp to a
string from within a stored procedure
43 matches
Mail list logo