On 2019-11-12 10:14, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu
> [firebird-support] wrote:
>> Good morning all,
>>
>> Is there an exhaustive list of all the words reserved by version
On 2019-11-12 10:03, Norbert Saint Georges n...@tetrasys.eu
[firebird-support] wrote:
> Good morning all,
>
> Is there an exhaustive list of all the words reserved by version of
> firebird (3.x, 4.x) somewhere?
>
> Thank you in advance.
Yes, it is in the doc folder:
https://github.com/Firebird
ormat date for the parameter?
Either don't use strings for data, or make sure to always use the
ISO-8601 format: yyyy-mm-dd.
Mark
--
Mark Rotteveel
On 2019-10-31 15:32, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 31.10.2019 15:15, Daniel Miller dmil...@amfes.com [firebird-support]
> wrote:
>> My question - is this intended behavior?
>
>For "generated *by default*" it is intended behavior. Your trigger
> obviously e
On 2019-10-31 15:15, Daniel Miller dmil...@amfes.com [firebird-support]
wrote:
> The fault or misunderstanding is probably mine, but:
>
> I thought the "identity" definition was functionally the same as the
> before-insert with generator. Particularly with regards to handling
> null
> values dur
On 2019-10-30 11:58, 'Check_Mail' check_m...@satron.de
[firebird-support] wrote:
> Hello,
>
> I use Microsoft Access as frontend, firebird 3 superserver as backand.
> Now, there a many linked tables in access over firebird odbc, some of
> the colums are in double precision format.
>
> Now, I don
ntroduces
aliases `BINARY(n)` and `VARBINARY(n)` for these types.
For longer values, use a `BLOB SUB_TYPE BINARY`.
Don't use an array type, they are badly supported in drivers and tools,
and even within Firebird support is minimal in DSQL/PSQL.
Mark
--
Mark Rotteveel
data encoded in base64 will consume 1/3 more bytes than
necessary.
Mark
--
Mark Rotteveel
On 2019-10-23 17:32, Stefan Heymann li...@stefanheymann.de
[firebird-support] wrote:
>>> 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
On 2019-10-23 14:49, jonatan.laurit...@yahoo.dk [firebird-support]
wrote:
> Sometimes I receive error message (during development and tests, of
> course):
>
> deadlock
> update conflict with concurret update
> concurrent transaction number is 2926
>
> Then I can find the other attachment with th
On 2019-10-23 17:06, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> 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?
We are using a forum right now. Yahoo Groups is both a forum (until the
28th
On 2019-10-22 16:12, 'Ismael L. Donis Garcia' sli...@natio.co.cu
[firebird-support] wrote:
> 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 fre
ible archive.
I don't have backups for firebird-general, firebird-coredocs and
firebird-architect, as those seem to be closed groups, and the tool I
wrote for the other groups isn't working. I probably need to add some
authentication, but I haven't tried that yet.
Mark
--
Mark Rotteveel
On 2019-10-08 14:18, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> Everything worked up to the last step. After a variety of bounced
> emails (some with the registration in the subject), I was
> finally able to post a question on the website. As of today, there
> are no responses
mail with subject 'Join request for
firebird-net-provider []'
4. Reply to this mail (don't use the 'Join This Group' button in the mail)
You should receive a mail with subject 'You have joined the group
firebird-net-provi...@googlegroups.com'.
5. Then send an email with your question to
firebird-net-provi...@googlegroups.com
Mark
--
Mark Rotteveel
rom C#, you really need to ask a more specific question with more
details on the firebird-net-provider list (not here).
Mark
--
Mark Rotteveel
;m not sure
if moderator approval is applied for new subscribers).
Mark
> On Thu, Oct 3, 2019 at 11:40 AM Mark Rotteveel m...@lawinegevaar.nl
> <mailto:m...@lawinegevaar.nl> [firebird-support]
> <mailto:firebird-support@yahoogroups.com>> wrote:
>
>
On 2019-10-04 14:01, Marcelo Guimaraes mfguimar...@gmail.com
[firebird-support] wrote:
> Hello everyone!
>
> Reading about FB performance, I hit this page:
> https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-appx05-montables.html
>
> My surprise on the
On 3-10-2019 18:32, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 3-10-2019 14:14, Clyde Eisenbeis cte...@gmail.com [firebird-support]
> wrote:
>> I've been to
>> https://groups.google.com/forum/#!forum/firebird-net-provider. Is there
>> a logi
ing, you can post by sending an email to
firebird-net-provi...@googlegroups.com
Mark
--
Mark Rotteveel
On 2019-10-01 20:15, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> Thanks for clarifying. Is there a more current Embedded_fb3.pdf doc?
> I don't see fbclient.dll file mentioned in that doc (although
> fbclient.dll is in Firebird 3.zip).
>
> Referencing fbclient.dll to Visual Stud
On 2019-10-01 19:15, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> I downloaded both Firebird 2.5.zip and Firebird 3.zip. I cannot find
> the file (fbembed.dll) described in Embedded_fb3.pdf.
Please read that PDF again, it mentions fbembed.dll only once, and in
the past tense to
ail as well). Maybe it is held for approval?
Mark
--
Mark Rotteveel
I think this is more a support question for LibreOffice, and how they
use prompts for parameters and set parameters in a query. It seems they
unconditionally use a string setter on their statement object, but
disallow setting as string on a numeric type.
This would need to be fixed in LibreOffice
On 2019-09-20 12:16, Rustam rusta...@ukr.net [firebird-support] wrote:
> I am also looking for somthing like that. Typical task - inform
> clients about changes in some records: client need an record ID.
>
>> It's hardly compatible with the existing events architecture and
>> API, so
>> I'm still
ird server instead of using
Firebird Embedded, you don't need this, and it would mean that you
specified the wrong server type.
Also, your question is more suitable for the firebird-net-provider list,
at https://groups.google.com/forum/#!forum/firebird-net-provider
Mark
--
Mark Rotteveel
On 2019-09-18 06:46, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Hi
>
> your problem is that you have ascending index, which is not usable in
> descending queries. You need to create descending index and it then
> can be used in e.g. max queries. Ascending index is used i
On 2019-09-18 02:11, 'Andrew Zenz' and...@aimsoftware.com.au
[firebird-support] wrote:
> Firebird 2.5.7 (WI-2.5.7.27050)
>
> Just realised I 'should' be using 2.5.8, but on a server running
> WI-V2.5.8.27089 it still uses NATURAL.
Be aware, the latest version of Firebird 2.5 is 2.5.9, not 2.5.
On 2019-09-17 09:25, Andrea Raimondi andrea.raimo...@gmail.com
[firebird-support] wrote:
> Hello!
>
> Just a quick q to try to figure out if it's worth for me to use it as
> the basis of a greenfield, not-so-high priority, project I am working
> on.
>
> How unstable is FB4? Does it result in tab
nbackup, see
https://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/html/nbackup.html
Mark
--
Mark Rotteveel
7. In firebird.conf, what is the setting for Providers?/
>
> *#Providers = Remote,Engine12,Loopback
> *But i also tried only:*
> *
> *#Providers = Engine12*
When it is prefixed with a # it is a comment, if you want to try with
Providers = Engine12, then you need to remove the #.
Mark
--
Mark Rotteveel
ifferent fbclient.dll.
See https://stackoverflow.com/q/53817952/466862
You could use sysinternal procmon to check which files actually get
loaded and used.
In firebird.conf, what is the setting for Providers?
--
Mark Rotteveel
On 2019-08-30 04:33, Richard Damon rich...@damon-family.org
[firebird-support] wrote:
> On 8/29/19 3:14 PM, 'Alan McDonald' a...@meta.com.au [firebird-support]
> wrote:
> numeric(18, 3) will use a double for its internal representation, but I
> would think it should still work. It might make more
On 2019-08-29 13:06, emou...@yahoo.fr [firebird-support] wrote:
> Hello,
>
> In theory, if I create a Firebird database with IBExpert under
> MS-Windows, is it then possible to use it with a Linux application
> (written in Lazarus), giving it all the right rights, ie without going
> through an IBE
ould change the page buffer settings of your database.
Mark
--
Mark Rotteveel
On 2019-08-27 14:31, 'Check_Mail' check_m...@satron.de
[firebird-support] wrote:
> we are using firebird 3.0.1 Superserver 32 Bit on a Windows Server
> 2008 32 Bit. Currently we have all 60 days the problem, that our
> Applications works not well, the firebird-process uses almost 2GB of
> RAM and
On 2019-08-26 14:36, Róbert Sisa robert.s...@dyntell.com
[firebird-support] wrote:
> Hi All,
>
> I have a problem with Firebird 3.0.4. When i run this query:
>
> SELECT 0 FROM MON$ATTACHMENTS
>
> the result set contains 94 records and it run for 1.2 second. It cause
> performance problems in my
On 2019-08-12 11:53, 'Check_Mail' check_m...@satron.de
[firebird-support] wrote:
> Hello,
>
> I have created a CTE in a stored prodedure which gives me all terms of
> the next days, for example:
>
> 01.10.2019 Meeting with..
>
> 01.10.2019 Exkursion
>
> 02.10.2019 Termin
>
> 04.10.2019
On 2019-08-12 10:55, Svein Erling Tysvær setys...@gmail.com
[firebird-support] wrote:
> I certainly agree with you that if EXISTS returns false, then NOT
> EXISTS should return true. It could make some sense if both EXISTS and
> NOT EXISTS returned (though it should be documented somewhere),
> bu
e mail
server of your provider.
Mark
--
Mark Rotteveel
There is a dedicated mailing list for Firebird and Python:
firebird-pyton. You might want to ask your question there. You can
subscribe by sending an email to
firebird-python-subscr...@yahoogroups.com.
Mark
On 2019-08-06 15:25, Aldo Caruso aldo.car...@argencasas.com
[firebird-support] wrote:
On 2019-08-05 15:58, 'Zoran' zoran...@gmail.com [firebird-support]
wrote:
> What Dimitry said, or you can try this:
>
>
>
>
>
> function _GetAliasDBFName(alias): string;
>
> var
>
> sl: TStringList;
>
> begin
>
> result := '';
>
> sl := TStringList.Create;
>
> try
>
On 2019-08-05 11:56, Zsazsi m-zs...@freemail.hu [firebird-support]
wrote:
> Hi Everyone!
>
> Can You recommend a simple workaround on the new LOCALTIME variable
> when the very same name is used as column name in a table?
Either rename the column, or use quotes around the column name. The
latte
On 2019-07-29 05:49, Geoff Worboys ge...@telesiscomputing.com.au
[firebird-support] wrote:
> Can anyone explain why the following example gives inconsistent
> results. The first two I consider correct (rounded up to 8.42),
> the last four I consider incorrect (rounded down to 8.41).
>
[..]
>
>
On 2019-07-18 14:26, 'Zoran' zoran...@gmail.com [firebird-support]
wrote:
> Hi András
>
> I did that already. This is happening very seldom, so I have to wait.
>
> I suspect some disk sectors are (going) bad and this could be a
> hardware
> problem.
It is unlikely that bad sectors would result
On 2019-07-15 13:49, 'stwizard' stwiz...@att.net [firebird-support]
wrote:
> 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.
Why are you still using 2.5.4? The latest 2.5 is 2
On 2019-07-12 15:15, Scott Morgan bl...@blueyonder.co.uk
[firebird-support] wrote:
> Are NULLs considered values for unique constraints on a table?
>
> e.g.
>
> CREATE TABLE blah (
> col1 INT NOT NULL,
> col2 INT,
>
> CONSTRAINT unq_blah UNIQUE(col1, col2)
> );
>
> INSERT INTO blah (col1
has this) I can
> still only login to the database with sysdba.
Which version of Firebird are you using, and what error do you get?
Mark--
Mark Rotteveel
king how to login? There is no difference between
logging in as SYSDBA or as a normal user.
Mark
--
Mark Rotteveel
On 2019-06-24 21:15, Arthur Zubarev arthur.zuba...@hotmail.com
[firebird-support] wrote:
> Golang 64 bit.
>
> Package nakagami/firebirdsql
>
> Conn str: sysdba:pwd@localhost/c://test.fdb
On https://github.com/nakagami/firebirdsql/issues/84, Hajime suggested
that you should use sysdba:pwd@loc
desired (or sufficient) scale
b.PR_EAT_T-b.PR_EAT_T* cast(b.P_TV_E /(100+b.P_TV_E) as numeric(18,2))
etc...
--
Mark Rotteveel
On 2019-06-12 12:59, Massimo Fazzolari reinhardt1...@gmail.com
[firebird-support] wrote:
To unsubscribe, send an email to
firebird-support-unsubscr...@yahoogroups.com
Mark
On 2019-06-06 21:37, Gabor Boros mlngl...@bgss.hu [firebird-support]
wrote:
> Hi All,
>
> I need to know all stored procedure variable names from a (2.5)
> database. I not see these in system tables like parameters or fields.
> But I see these with a text editor. For example...
>
> Create a new
` will have value 0.
If that is not your use case, please show a reproducible example so we
understand what you mean.
Mark
--
Mark Rotteveel
nce improvement by any newer
>> version, or different server implementation here?
>
> Likely TRUNCATE TABLE ... in Firebird 4.0 comes to rescue here:
Truncate table (CORE-2479) isn't implemented yet, so it is unsure this
will land in Firebird 4.
Mark
--
Mark Rotteveel
ing the external table. The first insert will recreate the file
(empty). Just be aware you can't have constraints or indexes on it.
Mark
--
Mark Rotteveel
from the table. You may want to consider dropping the table
entirely and recreating it. Alternatively, switch to SuperServer and set
its garbage collection policy to background (I believe this was
introduced in Firebird 2.0 or 2.1, so won't help with Firebird 1.5).
Mark
--
Mark Rotteveel
eck-and-repair-security-database" tool?
The security database is a normal Firebird database. You can check and
(attempt to) repair it with gfix just like any other Firebird database.
Make sure to keep a copy of the security database as backup.
--
Mark Rotteveel
'users') don't exceed their allowed access. But having sufficient
access to the server itself (either Firebird or the underlying
filesystems) allows you to circumvent that.
Mark
--
Mark Rotteveel
cision to do so.
Mark
--
Mark Rotteveel
has to
> be 32 bit.
It sounds like your code is attempting to use Firebird Embedded instead
of Firebird Server. Please provide more details about your configuration
and your connection setup.
Mark
--
Mark Rotteveel
ed
> originally? Need to find the best match possible while maintaining the
> original layout of text.
>
--
Mark Rotteveel
current snapshot 3.0.5 first of all.
It is not a good idea to use snapshots for production work. If this is a
known and breaking problem, then maybe 3.0.5 needs to be finished and
released.
Mark
--
Mark Rotteveel
et on how to handle
> this? I think I'm simply looking at creating a new empty UTF8 copy of
> the database and pumping over from the NONE version?
Not that I'm aware of. Creating a new database and pumping the data is
the best approach. Make sure to verify your migration process
27;t prompt for a
username and password.
Mark
--
Mark Rotteveel
back the transaction."
>
> On the other hand I made some tests using the debugger: I stopped the
> program before committing the transaction and I did not find any
> modified data in the database.
>
> I am confused.
The data isn't committed, so it isn't visible to any other transaction.
If a connection is closed with an active transaction, the transaction
will eventually be rolled back by Firebird. See also "“Dead”
transactions" in the Firebird book.
Mark
--
Mark Rotteveel
e firebirdsql:oo:
The firebirdsql:oo: sub-protocol addresses some problem with metadata
when used with LibreOffice/OpenOffice.org.
Mark
--
Mark Rotteveel
ar more likely scenario.
In the future, I recommend you shutdown the database using gfix before
renaming.
Mark
--
Mark Rotteveel
iles and the database.config were not modified again
>
> Any advice or experience with a similar situation?
Was it a Linux system, did you rename the database file while any
Firebird process was still connected to that database? If so, those
processes will continue to use the old database.
Mark
--
Mark Rotteveel
On 2019-05-07 03:08, Jim McNamara robol...@yahoo.com [firebird-support]
wrote:
> Hi dimitry-
> I got your email re: FB not supported in MinGW. I like that
> environment.
> In the short term I have read there is support for postgresql in
> MinGW. I will try that for now. If I find myself in Linux a
To unsubscribe, see the instructions in the footer:
On 2019-05-07 08:26, Brian Dunstan brian.duns...@health.telstra.com
[firebird-support] wrote:
ebird-3.0.4/Firebird-3.0.4.33054-0/gen'
>
> make: *** [Makefile:6: firebird] Error 2
>
>
> I got by the errors libdl.a not found and tommath not found by
> installing the right stuff.
>
> I don't know what I am reading in the makefile at those lines.
>
>
> thnx for any ideas I can use to troubleshoot.
> roboloki
--
Mark Rotteveel
scratch,
> will be gratefully received.
You're not providing us with information that can even help us come
close to understanding your problem. You will need to provide more details.
Mark
--
Mark Rotteveel
irebird.conf setting ServerMode = Classic or SuperClassic, you can
connect to the same database from multiple processes (you just need to
make sure that all processes share the same lock files, although that
should happen by default).
Mark
--
Mark Rotteveel
very high, maybe even earlier).
In Firebird 3 the transaction id was changed to a 48 bit unsigned
integer (or max 281,474,976,710,656). So if you want more breathing
room, consider upgrading to Firebird 3.
Mark
--
Mark Rotteveel
?
As far as I know the Windows will install it with the default name, so
not with 'Firebird 3' in the name, but I haven't used the installer in a
while.
Mark
--
Mark Rotteveel
e service points to the firebird.exe because that is the
server executable. instsvc is only a tool to install the service
(instsvc => INSTall SerViCe)
Mark
--
Mark Rotteveel
s), followed by a forced shutdown if that fails.
Mark
--
Mark Rotteveel
nged and why).
Please report it in the tracker. As far as I can see this is a bug and
regression compared to Firebird 2.5, and otherwise one of the core
developers will be able to tell if this was an intentional change.
Mark
--
Mark Rotteveel
ml#fblangref25-transacs-settransac
--
Mark Rotteveel
n use
alter user SYSDBA set password 'new password' using plugin Srp;
alter user SYSDBA set password 'new password' using plugin
Legacy_UserManager;
Or consider using drop user SYSDBA using plugin Legacy_UserManager to
only retain the Srp SYSDBA.
Mark
--
Mark Rotteveel
On 2019-04-11 20:03, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 11.04.2019 18:02, Anil anil.muja...@gmail.com [firebird-support] wrote:
>> It seems that the DB creation on Windows is resulting in an invalid DB
>> file.
>
>Yes. Because you didn't put all necessary files
rent topics to start
a new but unrelated topic. Write a new message to create a new topic (or
reply to your existing thread of the 30th of March).
--
Mark Rotteveel
reate it for Srp. If a user exists for both plugins, consider
dropping them for the other (prefer to retain the Srp user).
And when using ALTER/CREATE/DROP consider always using the USING PLUGIN
clause, so you are sure you are handling a user for the right plugin.
Mark
--
Mark Rotteveel
n, and I don't know how to fix it :
> https://bugzilla.redhat.com/show_bug.cgi?id=1636177
Has any progress been made on the investigation mentioned in that ticket?
Mark
--
Mark Rotteveel
On 2019-04-05 12:22, LtColRDSChauhan rdsc1...@gmail.com
[firebird-support] wrote:
> Hello,
>
> 1. The following connection string works:
>
> /home/ubuntu_user/Documents/Sample.FDB
>
> 2. While following connection strings fails:
> Ubuntu_Machine:/home/ubuntu_user/Documents/Sample.FDB
>
> local
ould mean that libfbintl.so is
inaccessible or missing.
Which Linux distribution do you use, and how did you install Firebird?
Mark
--
Mark Rotteveel
build a webservice that replaces
your direct database access.
Building a webservice to replace direct database access is an extremely
broad topic, where accessing the Firebird database is probably the least
of your worries.
In any case, your question is quite vague to actually answer. You may
On 2019-03-12 13:13, Michal Kurczabinski michk...@gmail.com
[firebird-support] wrote:
> I forgot about very useful feature lile FILTER on window functions
> select some_col, count(other_col) over() FILTER ( where other_col >
> soime_val) Maybe in FB 4.0 it might be implemented
FILTER has been
eally wrong without clear
evidence is not really constructive.
Mark
--
Mark Rotteveel
TABASE
See also
https://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-functions-scalarfuncs.html#fblangref25-functions-workcontext
Mark
--
Mark Rotteveel
Compression = true
}.ToString();
using (var connection = new FbConnection(connectionString))
{
connection.Open();
Console.WriteLine(connection.ServerVersion);
}
Mark
--
Mark Rotteveel
sure this can be taken as an indication that wire compression is
enabled or not. In Firebird 3, to determine this you can check the
isc_database_info item isc_info_firebird_version; which is exposed in
Firebird ado.net on FbConnection.ServerVersion.
For example, when compression is not enabled, it will return:
WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13
When it is enabled, it will return:
WI-V3.0.4.33054 Firebird 3.0/tcp (Ramona)/P13:Z
(Z for zlib)
Mark
--
Mark Rotteveel
me]));
> GetUniqueStatisticsStatement.Add('ORDER BY RDB$STATISTICS DESC');
>
I don't know Delphi, but this looks like something that is vulnerable to
SQL injection. You might want to learn how to use parameters to avoid
introducing security issues in your application.
Mark
--
Mark Rotteveel
;MEMPAY1'.
If you want to filter on table and index name, you need to add a
condition in the WHERE clause, so:
where RDB$RELATION_NAME = 'MEMPAY1'
and RDB$INDEX_NAME = 'M1ID1'
and (RDB$SYSTEM_FLAG is null or RDB$SYSTEM_FLAG = 0)
Mark
--
Mark Rotteveel
On 2019-02-26 18:48, Robert Tulloch tult...@hughes.net
[firebird-support] wrote:
>> I don't have InterBase 6, but I tried on Firebird 1.5, and I have
>> to use
>> `RDB$SYSTEM_FLAG IS NULL` for your query to return non-system
>> indexes,
>> and that is because the flag is 1 for system, and null for
ve that was eventually fixed in Firebird 2.0 or 2.1.
Mark
PS Why even bother with a 19 year old version though?
--
Mark Rotteveel
rn 0.
> Does any one know why and how to solve this?
Without a reproducible case, it is not really possible to answer this,
but my first guesses would be:
- Different database
- The session in IBExpert produced the data, and it wasn't committed
Mark
--
Mark Rotteveel
s of tables.
It is possible it has NULL instead of 0. So try `RDB$SYSTEM_FLAG = 0 OR
RDB$SYSTEM_FLAG IS NULL`
Or, just query without the condition and check what the actual value of
RDB$SYSTEM_FLAG is.
Mark
--
Mark Rotteveel
s the "Your user name and
password are not defined." error without the reference to the
compatibility chapter).
Mark
--
Mark Rotteveel
101 - 200 of 1341 matches
Mail list logo