Hello all,
what are the rules for alias names? Which characters are allowed in an
alias? Does it follow the OS rules for a filename?
If that is documented somewhere you are welcome to RTFM me with a
hint to where I can find it ;-)
Regards
Stefan
--
Stefan Heymann, Tübingen, Germany
>> For me it must continue with the development of Flamerobin.
>>
>> I know many people who feel very comfortable with him.
>>
>> I really don't understand why its development has stopped.
> Development of a free open source project happens by virtue of its
> contributors. If those
>> If you want to have it for free, like in
>> free beer, you can sit down, write it and publish it
> This is the plan. ;-)
> Gabor
Sounds like a good plan :-))
Regards
Stefan
> Official or not, we need a simple, up to date, Firebird only, native
> GUI.
I don't get the point. There are GUI tools readily available
(IBExpert, Upscene, etc.). If you want to have it for free, like in
free beer, you can sit down, write it and publish it (that's how free
software is made
> This may seem like a very naive question, but is it possible to edit
> the SQL of a trigger from within a programming language (Delphi, in
> my case).
> I use IBX components (I know this is not supported, but it seems to
> work fine!), and I want to periodically update the date condition on
>
Hello all,
can I safely assume that all local and RETURNS variables are already
initialized to NULL when my Stored Procedure (or Trigger) starts?
Or do I need to treat them as "undefined" (as in Pascal/Delphi) and
initialize them myself?
Regards
Stefan
--
Stefan Heymann, Tübingen, Germany
>> DummyPacketInterval = 0 (but this should be irrelevant for this type
>> of issue)
>Try to change it. This _is_ relevant for this type of issue.
That did the trick. Thanks, Dimitry!
Regards
Stefan
Hello all,
I have a customer who is reporting this scenario:
He has several type C networks (192.168.x.y) routed together. When a
client is inactive for some time (e.g. a few hours) the connection
gets lost, BUT ONLY when the connection is from another network than
the one the server resides in.
Issam,
the NONE characterset doesn't "know" how to handle the è in "Absence
de germes pathogènes". There is this byte with the hex value E9, but
this could be any character.
I assume you used Windows 1252 or ISO 8859-1 to store this string in
your NONE field (that's because these are used for
>> On some servers we encounter a sudden reboot after FB install.
>> [...]
> Wasn't it BSOD because of hardware malfunction? In Windows system
> setting turn off automatic reboot on error.
No. A BSOD needs a user intervention in order for the machine to
reboot. In the cases I have seen, Windows
> Besides that, is there any other advantage of gbak or nbackup
> against an ordinary copy of the database?
When a GBAK backup finishes successfully you know that your database
is physically intact. When a restore finishes successfully you also
know that your database is logically intact
> When I need to copy my Firebird database: Do I need to shutdown the
> Firebird instance first?
Yes. Becaus when you don't do that, the server may access the file
during your copy process and you would get a corrupt file copy.
> and If yes, what is the proper way to shutdown and startup it?
There are requests to implement Time zones in Firebird:
http://tracker.firebirdsql.org/browse/CORE-694
http://tracker.firebirdsql.org/browse/CORE-909
These two are in the "Optional features" list for Firebird 4:
https://www.firebirdsql.org/en/planning-board/
Best Regards
Stefan
--
Stefan
>> SYSDBA users can see other connected users using monitoring tables
>> but is it possible to implement such feature for non-SYSDBA users?
The only one who can also "see" connections from user users is the
database owner. Other than that I don't know of a way to do that.
Regards
Stefan
> I want to alter an existing stored procedure with varchar
> parameters having length of 31000. Whenever I try to execute this query I get
> an exception of
> “Invalid token. Invalid request BLR at offset 102. Implementation limit
> exceeded. Block size exceeds implementation restriction.”
>
Tomasz,
> One of the legacy databases I happen to maintain has character sets and
> collations messed up. [...]
For a database that is messed up like this, I'd go the clean way and
use a pump. That would also give you the opportunity to change it to
Unicode (UTF-8) at the same time, which is a
> Does it apply to remote servers also such as
> www.myserver.com:/opt/database/fbdata.fdb
> The release note README file in the embbeded zip says:
> [...]
You are mixing up access to a remote database (only fbclient.dll
needed) and the Embedded Firebird server (fbembed.dll, renamed to
> I have INSERT about 10 records in a Table, the size of the FB Database
> grew up to 15MB
> I DELETE the records the size remains 15MB.
That is normal. A Firebird database is organized in pages that are
allocated when needed. When you delete the records, the pages will be
marked as free
> What's required for the Windows app to access a remote Firebird database ?
> The minimal installation
The absolute minimum you need is the fbclient.dll (same 32/64-bitness
as your application). I put it in the same folder as my application's
.exe file so it can be found easily.
My customers
>> Is there a remote chance that this reboot has anything to do with the
>> Firebird installation that went on at that very second? Can it be
>> related to the installation of the Win32 runtimes that was going on at
>> this time?
>Look into Windows Event Log to find out the reason for reboot.
Hello all,
I recently installed Firebird 2.5.6 x64 on a customer's machine
(Windows 2012 R2), using the Firebird installer from
http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.6-Release/Firebird-2.5.6.27020_0_x64.exe/download
During or after the installation of the Win32
> UNICODE_AI collation is useless, but DE_DE_AI can work unless Stefan
> needs to keep words in other languages in the same field as well.
That's the point. I don't know what language is used (can be every
European language) and so I'll have to live with that.
How can I work with that DE_DE_AI
> Also, it is questionable if you should consider a and ä different
> letters, even in German. See e.g.
> https://de.wikipedia.org/wiki/Alphabetische_Sortierung
For sorting, treating them as "same" is correct. However, for things
like comparisons (in a unique key for example) they are not the
I expect that an accent insensitive compare treats accented characters
as the "same" as their un-accented counterparts because the accent
does not change the character itself but things like pronounciation or
stress.
So in Frech, à is similar to a, é is similar to è and you use an
accent
> While that answer is correct, the better answer would be for the
> Project to modify engine and installer to be Windows Vista+
> compliant and have all configuration files stored in All
> Users\Application Data\Firebird and not in Programs Files\Firebird
I just wanted to suggest that
Bhavbhuti,
> My application allows users to create a database and it's entry in
> aliases.conf is created by the application. This essentially is
> fine and works well in Admin mode, as soon as the same is tried to
> be done using the normal non-admin mode I am not able to update aliases.conf
>
I wonder what is wrong with simply invoking ALTER TABLE X ALTER
COLUMN Y TYPE CHAR(N) CHARACTER SET ISO8859_1
This will only change the metadata of that field. It will not check if
the data really is ISO8859_1. When *you* are sure about that, it
shouldn't be a problem.
Regards
Stefan
when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database
owner), the MON$ROLE field always shows 'NONE', even when the user is
logged in with a specific role.
Is there a way to find out the role another user (with a specifid
attachment_id) is logged in?
AFAIR, the MON$ROLE
Hallo all,
when I call SELECT * FROM MON$ATTACHMENTS (logged in as the database
owner), the MON$ROLE field always shows 'NONE', even when the user is
logged in with a specific role.
Is there a way to find out the role another user (with a specifid
attachment_id) is logged in?
Using Firebird
I’m using Firebird 2.5.3, and I am looking for text in a emo field, eg.
I’m tempted to do something like
Select * from mytable t where lowercase(t.mymemo) like ‘%find me%’
but since this memo field could be enormous, I’m guessing that wold be
horribly inefficient.
I use upper() for that
30 matches
Mail list logo