I am currently using Firebird Embedded edition for a military simulation I have
been working on.
I have seen recently that Firebird 3.0 has just been released with a brand new
User-Guide. Along with this, I noticed that Firebird 4.0 is now on the books
for development.
However, in the interim
Helen...
Thank you for your quick reply
I must be working on too many software projects as I completely forgot about
the earlier Firebird 3.0 release. It may have been the way the site was
presenting its current news that lead me to believe that the 3.0 version was
new.
In any
Carlos...
Thank you for your quick reply
I must be working on too many software projects as I completely forgot about
the earlier Firebird 3.0 release. It may have been the way the site was
presenting its current news that lead me to believe that the 3.0 version was
new.
In any
I just wanted to follow up on this thread about learning Firebird-SQL since I
have extensive experience with using SQL with a variety of database engines
over a very long career.
That being said, the gentleman who stated that you cannot use T-SQL with
Firebird is primarily correct and learning
I have to disagree with your observation. It is clearly stated in the Firebird
SQL Reference Manual that the development of Firebird-SQL is with a strict
implementation of the SQL-92 Standard.
This is not to say that Firebird-SQL does not go beyond the SQL-92 Standard but
it is somewhat limite
Hi Liviuslivius...
I have to offer my apologies as of now as I have not been able to find the
statement I referred to in my previous email. However, I did come across it in
one of the Firebird manuals as I was looking for information as to why I was
having so much trouble adopting to Firebird-
Mark...
One of the newer and nice error trapping features in T-SQL is the
implementation of the "Try-Catch" block, which I used quite a bit when working
on developing corporate databases.
Another was the use of "select" to to test out functionality. for example,
with T-SQL in a database manag
Hello...
I have been doing fairly well at converting a project's database to Firebird
Embedded, transposing all of the inline SQL to Firebird stored procedures.
However, with the following procedure I am creating a slightly
complex SELECT statement based upon two incoming parameters.
It seems
Thank you very much for your help, Karol...
As soon as I corrected my procedure based on your information, it worked as
expected.
Thank you, again...
Sincerely,
Steve Naidamast
Hello...
I have been in the process of converting my application's SQL Server T-SQL code
to Firebird PSQL procedures. So far so good until I got to the one where I
built a Firebird procedure with a recursive CTE in it.
The following code is an exact match to my original SQL Server T-SQL code..
András...
Thank you very much for your assistance. Your suggestion seemed to work like a
charm.
However, I though only the issuance one "SUSPEND" was enough to flush the
entire buffer of all records...
Steve
I am not sure if I understand your explanation here...
1...
Why would I test the input parameter, "PI_KEY_IN" for each row? I am only
doing this to ensure that the client never sends an input value of zero(0).
2...
In the other email you sent you stated that...
"A FOR .. DO is a loop construc
Thank you, Mark, for clearing up my misunderstanding. 😊
When I found some sample code on StackOverflow that demonstrated the use of
the "FOR-DO" construct, I realized what I had misunderstood.
I believe I sent you an email that suggested my correction to my understanding
of this construc
For many years I have been tracking the development of the Firebird Database
Engine and have watched it move from its 1.5 version to its most recent
release, version 3.0.3.
On a number of occasions I have attempted to work with this database engine.
And though I have many years of extensiv
Thank you, Karol...
I'll take your information and update the article's section on views...
With warm regards,
Steve
Hi B?Iint...
If you are using the same connection string for a connection to a local
Firebird engine as you did for a remote engine, this is where your issue may
lie.
The connection string for a the local, embedded edition is slightly different
from that of connecting to a remote server.
The query as written should work for both the embedded server as well as a
remote server.
Can you provide the query PSQL and the exact error message/information that is
being thrown?
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 f
Thank you Helen, for your reply to my original query regarding ADO.NET and
Firebird...
I did in fact find the Firebird .NET provider Email list after I had submitted
my query here and then forwarded the same query over there.
Jiri was kind enough to respond. His reply included the info
Thomas...
You may want to consider purchasing Carlos' e-book on Firebird Migration at
the following link...
https://www.firebirdnews.org/migration-guide-to-firebird-3/
https://www.firebirdnews.org/migration-guide-to-firebird-3/
It is very well written and has a lot of information rega
Hello...
About two years ago I had completed a fully working SQL Server Source Control
application that had the same basic features as the similar tools of its much
larger competitors, Red Gate and ApexSQL.
I attempted to market the application to .NET developers who were using SQL
Serve
Thank you all for your kind and informative replies.
It appears that the information you all provided gives me encouragement to
review my current product for a conversion to the Firebird Database Engine.
To be sure, this will be a lot of work since the entirety of the SQL Server
Shared Ma
My thoughts exactly...
Even with scripting out all the database objects before the sources are
deleted, sorting through them on large database can become a timely effort if
you need to recompile only a few.
Besides, who breaks into a database to steal stored procedure code??? And if
y
Thanks for the heads up, Mark...
However, Carlos' explanation when I read through it again, does appear to be a
little confusing at the least.
Why not simply disallow it altogether and be consistent?
As I just mentioned in another reply to you, no one breaks into databases to
steal st
I don't believe that is the problem here...
Steve Naidamast
http://www.blackfalconsoftware.com http://www.blackfalconsoftware.com
That seems to have fixed the issue...
However, the other day I believe I had tried the 32bit client and it still
wasn't being seen as a valid client library.
Just tried it again and now it is working as expected. Maybe when I tried the
32bit client something was stuck in the application
If as Mark has already stated, there is no way to provide information on
procedures as to when they were last accessed, you may want to opt for your own
logging file that is updated every time a procedure is called.
You can do this either with a trigger in each stored procedure or within your
From what I can see, if your clause is failing on the date comparison, it could
be that you are comparing a date object to a string. You should ensure that
your castings are correct for both sides of the comparison clause.
After looking at the CASE clause you provided, its structure appears
Mark...
Do you know how the data is stored in the Yahoo mailing list? If not, could
you contact the administrator to find out?
There may be a way to convert it to another platform in case the project
leaders decide to move it to another platform...
Steve Naidamast
Sr. Software Engi
Karen...
For configuration issues such as the one you described, you may want to
purchase a copy ofthe Firebird Migration Guide at the link below...
https://www.firebirdnews.org/migration-guide-to-firebird-3/
https://www.firebirdnews.org/migration-guide-to-firebird-3/
Though it is tit
These type of string operations are better done at the client side in C#,
VB.NET, Java, or any other high level language. Using any variant of SQL to do
such tasks would be quite onerous.
However, if this is a homework assignment and you need some assistance, please
let me know and I would
May I ask why you are using the embedded version of Firebird for a web
application?
This version of Firebird does not have the optimization advantages of the
server version, even if it is using the same core kernel...
Steve Naidamast
Sr. Software Engineer
Hi Daniel...
I have done extensive database development in a very long career in the field.
As a result, I have learned the following axioms...
1...
If you are using a localized database (ie: Firebird Embedded) it really
doesn't matter where you define your SQL code since there is no ch
I have two comments on this thread...
I...
The examples provided (I & II) do not necessarily show a correct pattern of
either. In the first example, the assumption can be made that the description
is unique and thus requires a unique example.
The second is merely a reverse of the first
Just a question about the use of ZeroMQ...
Has anyone considered using ZeroC's Ice Framework?
It appears to be a much more finished product with better diocumentation than
ZeroMQ and is completely Open Source...
Steve Naidamast
Sr. Software Engineer
I believe this has been done with such database engines as SQL Server and
PostgreSQL.
However, the Firebird Database Engine has a stricter standard as to what is
implemented in the SQL language than other such engines. Nonetheless, it
appears that there is some similar capabilities as th
By using a global table in Firebird, could not multiple users cause a conflict
if two such users were to issue the same query against the global table?
Coming from a SQL Server background, I am used to using local temporary
tables, which are isolated on a query by query basis...
Steve Nai
Hi Helen...
Thank you for clearing this up for me.
However, could you clarify what you mean between a session or a transaction?
Steve Naidamast
Sr. Software Engineer
Mark is correct in his previous reply as I went through some of the
documentation for the Open EMR System. The OpenEMR system makes use of the
MySQL database engine, not Firebird.
You can look at the following two links for installation guidance for this
system on windows...
https://ww
Antonio...
I believe you are asking how you install a Firebird Database Engine on a
"hosted web site" by one of the many providers available to developers on the
Internet.
If this is the case, than you will not find many that support the Firebird
Database intrinsically whereas most suppo
Hi Alexey...
I currently use the EMS SqlManager software for all my Firebird database
administration
I have been using their software for many years for the SQL Server, MySQL, and
PostgreSQL databases with very few issues.
However, I do have an issue with the Firebird SQL error repo
Why not simply use a forum implementation, which is a better technology to use
for such a form of support than that of a mailing list?
Steve Naidamast
Sr. Software Engineer
I never use anything by Google as I do not like how they handle their user data
so cavalierly. In any event, If moving the Yahoo mail data to a Google Groups
platform would make it easy for the development team than I would see this as
an appropriate solution.
However for the type of techni
Hello...
I need to store a byte array for the security aspect of the application I am
developing.
Would you simply store it in a field defined with the BLOB type or use the
ARRAY type if one knew the length of the array?
Thank you...
Steve Naidamast
Sr. Software engineer
I have found what I needed.
Sorry for the bother...
I was having trouble finding a way top convert the array into a string, which
led me to believe I would have to store it in array format.
I eventually found the correct solution after going through several incorrect
ones. I couldn'
I do not like using Java applications on my workstation, mostly as a result of
the extra clutter they bring in addition to the enormous number of Microsoft
files I already have installed.
That being said, I do agree with the commenters in this thread where the
Firebird Development Group shou
Thank you Anne, for your succinct comments regarding the differences between
the efficiencies of a CHAR and VARCHAR field definitions.
Human observation cannot actually elicit any observable effects between the
two.
However, internally, the CHAR field definition is more efficient as th
Though I cannot dispute what you are saying, to me it does not make much sense.
If a VARCHAR field is defined for 1000 characters and it is stored in the
table at a 1000 character length than there is no purpose to an actual VARCHAR
field definition.
VARCHAR fields have always been dy
Your statement, which may be true, does not sit well with a previous statement
that states that a VARCHAR field of 1000 characters is stored in the table with
1000 characters.
Your statement is suggesting a null length (until the field is updated) with
two bytes for an actual length, which i
Here is the link to the definition of CHAR and VARCHAR field definitions from
the IB-Experts site...
https://www.ibexpert.net/ibe/index.php?n=Doc.CHAR
https://www.ibexpert.net/ibe/index.php?n=Doc.CHAR
It defines the storing of CHAR and VARCHAR in the same manner, though the
VARCHAR data
What do you mean I am wrong? I have merely re-iterated how all database
engines I have worked operate.
And what you are saying is that a CHAR field in Firebird acts in the same
manner as that of a VARCHAR field. If that were the case there would be no
difference in how they are used and no
The links provided to me had the information on the IB-Experts web site...
If there information is incorrect, you should contact them to have it
corrected...
Steve Naidamast
Sr. Software Engineer
I found what we have been arguing over in the Firebird 2.5 Language Reference
Manual since I don't seem to have the one for version 3.0. I looked for it at
the Firebird site but it does not appear to be listed...
>>>
CHAR DATA TYPE (CHAR(n), CHARACTER(n))
-
Doesn't the page size definition as per a database depend on one designs their
database tables and how such tables will be used?
In any event, here is what the Developer Guide for version 3.0 of Firebird
states...
The actively supported versions of Firebird support the following page size
I was going the recommend the same join constructs as Karol did.
However, I am not sure why Karol suggested the construct of composite indicies
in his reply as I thought you were going to create 2 additional indices, one
for each of the fields in the multiple or clauses. As a result, this wo
Karol...
My misunderstanding I should apologize to you...
I misunderstood you when you said, "Firebird cannot use composite index
here"...
I thought you may have been trying to suggest them to the person who opened
the thread but couldn't with the way his SQL query had been coded...
Kevin...
EMS Sql Manager has a great list of tools for Firebird and Interbase that will
provide the very processes you are looking for... https://www.sqlmanager.net
https://www.sqlmanager.net
Granted these are commercial products but I have been using them for years and
have found them
rebird-support]
Sent: Thursday, May 3, 2018 5:17 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Problem returning multiple rows from a
CTE-recursive procedure
03.05.2018 23:04, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, I though only the issuance one &q
Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
Sent: Friday, May 4, 2018 12:25 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Problem returning multiple rows from a
CTE-recursive procedure
04.05.2018 18:13, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-supp
Hi Dimitry...
Is it that we can no longer reply to messages on the Firebird Yahoo Group? I
went there to ask about FB 4.0 and I could see all the messages but there were
no reply options.
As to what I was trying to respond to, you note in your message below that you
would recommend FB 4.0. H
Hello...
Is there any way to secure the FDB file from unauthorized access (other than
compression and encryption, which I am starting to implement in my project) and
if not, is there expected to be at least password protection for the Embedded
edition in Firebird 4.0?
Thank you...
Steve Naida
Elmar...
Thank you for your reply regarding protecting a Firebird Embedded Database.
However, why is it assumed that a database file that is stored locally cannot
be breached by unauthorized access? Given the nature of sophisticated security
breaches and hacking endeavors today, such data file
bject: Re: [firebird-support] Re: Securing Firebird Embedded database
On 2019-12-18 16:30, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> Is there any way to secure the FDB file from unauthorized access
> (other than compression and encryption, which I am
Elmar...
My current concept for making a Firebird Embedded Edition somewhat secure
without a password (and as you say, using password means little if people
already know a database;s internal structure) is to offer two levels of
encryption. The first would be using DotNetZip to compress and en
Hello...
I am developing a security extension, which is used as a loaded assembly to my
main application, all of which use the Firebird Embedded Edition 2.59 for my
application's database.
As part of my security processes, I compress the file upon exiting the
application. When the compression
Thank you very much for all your replies.
I will try the "Clear Pools" option with the Firebird ADO.NET provider first.
If that doesn't work, I have come up with the idea to start a small, external
process that will check for the release of the file by the application and then
delete it...
Tha
66 matches
Mail list logo