On 25-11-2020 10:13, 'River~~' river14ap...@gmail.com [firebird-support]
wrote:
[..]
> I am also interested to know if you find my syntax works on v2.5, if
> you still have it installed to test it? Please don't go to the trouble
> of re-installing it just to test it.
>
> It is arguable that v3
On 13-10-2020 18:42, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz
[firebird-support] wrote:
>
>
> Support native JSON datatype for columns as MySQL / PostgreeSql
>
> Some idea when this feateures will be scheduled?
> Or we are not be interested on it?
There is a ticket in the tracker:
The firebird-support Yahoo Group has moved to Google Groups at
https://groups.google.com/d/forum/firebird-support. Please subscribe and
post your question there.
Mark
On 2020-07-28 15:23, hamacker sirhamac...@gmail.com [firebird-support]
wrote:
> If I try in FB3 (latest version):CREATE
>
On 25-06-2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu
[firebird-support] wrote:
> Is it possible to create databases on a 3.0.5 server with a user other
> than sysdba?
> when i try in flamerobin create a database with another user it gives me
> the following error:
>
On 26-06-2020 21:08, 'Ismael L. Donis Garcia' sli...@natio.co.cu
[firebird-support] wrote:
> I don't know if I will be such a novice, but I can't find the language
> reference manual for firebird 3
It is documented in the release notes:
You have sent your email to the old list, please post to the new list at
firebird-supp...@googlegroups.com (or
https://groups.google.com/d/forum/firebird-support).
If you're not subscribed yet, you can do it on above link, or by sending
an email to firebird-support+subscr...@googlegroups.com
The Firebird-support mailing list has moved from Yahoo Groups to Google
Groups, https://groups.google.com/d/forum/firebird-support (or subscribe
by emailing to firebird-support+subscr...@googlegroups.com and confirm
by replying to the confirmation request). Could you please subscribe to
the
On 05-05-2020 02:25, DougC d...@moosemail.net [firebird-support] wrote:
> I tried to use the new google group and have it send you an invite to
> join the group. What Google responded with was:
>
> Some email addresses cannot be added to this group because their
> accounts are disabled
On 2020-05-04 10:34, Karol Bieniaszewski liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Hi
>
> How can i read Next Attachement ID?
>
> I know that i can read it by gstat -h but how to read it from
> connection?
>
> Is there something simple like for OAT – read from MON$DATABASE or
>
On 03-05-2020 10:39, Karol Bieniaszewski liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> I have joined but i cannot change name to show instead my email name.
>
> I have followed hint on the group to go to settings – but to change this
> settings i must login. I do not have google
On 02-05-2020 11:38, Lester Caine les...@lsces.uk [firebird-support] wrote:
> On 02/05/2020 00:29, Helen Borrie hele...@tpg.com.au [firebird-support]
> wrote:
>> Unfortunately we cannot migrate the current Yahoo! subscribers, and you will
>> need to resubscribe yourself, in one of two ways:
>
>
On 2020-05-01 02:20, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
> The firebirdsql.org site lists new Google groups to replace the yahoo
> firebird-support and firebird-general lists, but the links don't work -
> I get permission denied errors trying to visit them.
>
> Are
On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com
[firebird-support] wrote:
> I always tend to do back / restores not only in this migration but on
> a regular basis. I’m maybe a little on the paranoid side. :)
> I have noticed some extra lines in the restore log for FB3 (this
On 18-04-2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support]
wrote:
>
>
> Yes sorry, this is from Linux. Since I'm a Linux Enthusiast . I did that
> script, but it did produce errors.
>
> http://www.firebirdfaq.org/faq141/ This is the backup script I used.
>
> This page I used
On 17-04-2020 13:35, Nick Upson nick.up...@gmail.com [firebird-support]
wrote:
> I've had a similar issue when the database code was looking for custom
> UDF's that had not been installed on the destination, in some ways that
> can appear as corruption even though it isn't
In Firebird itself
On 18-04-2020 12:19, Shane delphi_ric...@yahoo.co.uk [firebird-support]
wrote:
> The scenario that I've setup is Opensuse is the main OS. I'm running
> Windows XP on a VirtualBox. So within Windows XP I communicate to the
> Linux OS through samba, copying to the folder the database is running.
On 11-04-2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> Hi @all!
>
> I'm trying to implement some sort of user manager into an app and want
> to use the firebird-users and roles as user and authentification
> source (using FB 3).
>
> Most of it works perfectly. There's just
On 2020-04-09 18:05, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl
> [firebird-support] wrote:
>> Hi
>>
>> Simply replace security3.fdb by ine from the zip install and
>> initialize sy
On 2020-04-09 09:53, liviuslivius liviusliv...@poczta.onet.pl
[firebird-support] wrote:
> Hi
>
> Simply replace security3.fdb by ine from the zip install and
> initialize sysdba
Doing that will lose all other users in the security database, so that
is not a good idea.
Instead, stop Firebird
On 04-04-2020 13:01, 'Stellarancia.com' ni...@stellarancia.com
[firebird-support] wrote:
> No, there is not a trigger.
>
> You say than the error is referred to another part (with mistaken value)
> of the entire script... but the compiler reports me the part that
> (maybe) run ok?!? How this is
On 04-04-2020 10:49, 'Stellarancia.com' ni...@stellarancia.com
[firebird-support] wrote:
> He,
> I've an error that I don't undestrand.
> I use Delphi 7 environment to create my applications, Zeos components
> for connections and Firebird 2.5 Superserver for database management.
> To register the
On 26-03-2020 11:37, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 26.03.2020 11:35, Tommi Prami tommi.pr...@suonentieto.fi [firebird-support]
> wrote:
>> Form Embarcadero marketing matriel
>
> Already was discussed here a couple of months ago. Look into archives.
Which
On 2020-03-25 13:24, Gregor Kobler gregorkob...@yahoo.com
[firebird-support] wrote:
> Hello Mark
>
> Yes I am aware of that, but I have no experience with the snapshots.
> How do I make the current snapshot work. I run the file
> "Install_service.bat". The Firebird service is running, but when I
On 2020-03-24 10:47, Gregor Kobler gregorkob...@yahoo.com
[firebird-support] wrote:
> Hello
>
> I try a little bit with the FB4 beta 1
>
> two errors i got
> 1. When i try to connect with my 64Bit program and using the
> fbclient.dll (64Bit) my program crashes! when i use the 64bit dll from
>
On 22-03-2020 03:06, Audio Buff npage@gmail.com [firebird-support]
wrote:
> During the install of Sam Broadcaster, there are a few database options,
> Firebird being named as the most simple to get started. I used the Firebird
> version from the official archive, the latest version.
> When
The problem is that the order of clauses in your create database
statement is wrong. The USER and PASSWORD clauses must
follow *immediately* after the `CREATE `. See also [1].
I'm unsure why this doesn't produce a different error though. As a
secondary problem, in a create database clause,
On 13-03-2020 14:49, Jorge Andres Brugger jorge.brug...@gmail.com
[firebird-support] wrote:
> Mariuz's Ubuntu repository contains version 3.0.5.33100 and was released
> in October 2019. The official version on the Firebird website is
> 3.0.5.33220, released in January 2020. This is ok in terms
This sounds like a bug to me. Can you create bug report in the tracker
at http://tracker.firebirdsql.org/browse/CORE
Mark
On 09-03-2020 03:50, FSPAPA INCA Team i...@foodstuffs-si.co.nz
[firebird-support] wrote:
>
>
> Hi – I have another question re user mapping…
>
> If I create a new
On 2020-03-10 22:04, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> 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.
>
On 2020-03-10 20:14, Andrei Luís compuvale.softw...@gmail.com
[firebird-support] wrote:
> Hummm, I think Dimitry is right. I made some tests here on client
> side:
>
> server IP: 10.0.2.2
> path: d:\database.fdb
>
> Using connection string: 10.0.2.2:d:\database.fdb Correct IP and
> correct
On 10-03-2020 17:44, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 10.03.2020 15:57, Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
> wrote:
>> On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com
>> [firebird-support] wrote:
>> >
On 10-03-2020 15:46, Andrei Luís compuvale.softw...@gmail.com
[firebird-support] wrote:
> No, there wasn't. I copied fbclient.dll and firebird to the application
> folder. Still the same!
Well, as far as I know, this should work. Is your Windows 32 bit or 64
bit, and is your application 32 bit
On 10-03-2020 15:40, Andrei Luís compuvale.softw...@gmail.com
[firebird-support] wrote:
> Just did that. Still the same.
Check if your client application has its own fbclient.dll, and put a
firebird.conf in the same directory as that fbclient.dll.
Mark
--
Mark Rotteveel
On 10-03-2020 15:33, Andrei Luís compuvale.softw...@gmail.com
[firebird-support] wrote:
>
>
> Server side
> fbclient.dll = C:\Program Files (x86)\Firebird\Firebird_2_5\bin and
> c:\Windows\SysWOW64
> firebird.conf = C:\Program Files (x86)\Firebird\Firebird_2_5
>
>
> Client side
>
On 10-03-2020 15:21, Andrei Luís compuvale.softw...@gmail.com
[firebird-support] wrote:
> Sorry for my lack of infos, I read your previous message before post my
> message here. I'm testing this in the my dev machine, I configured
> ConnectionTimeout in the firebird.conf file in the physical
On 10-03-2020 14:41, Andrei Luís compuvale.softw...@gmail.com
[firebird-support] wrote:
> I'm having the same problem. Already set ConnectionTimeout = 5 in
> firebird.conf, restarted the FB service, and the connect try is going so
> far from that. I'm using FB 2.5. Is there anything else to
On 2020-03-06 04:46, FSPAPA INCA Team i...@foodstuffs-si.co.nz
[firebird-support] wrote:
> Aha, you've got a typo!
>
> In your create mapping statement (and verified by the output of show
> mapping), you have "WINSSPI" instead of "WIN_SSPI".
> I encountered the same issue when I accidentally
On 2020-03-05 13:38, 'Mathias Pannier (unitel)' pann...@ubsysteme.de
[firebird-support] wrote:
> I can’t get it to work…
>
> The user “MYDOMAIN\ADMINISTRATOR” is a member of the AD group
> “MYDOMAIN\MY_GROUP”
>
> ROLE_TEST was created using this statement: CREATE ROLE ROLE_TEST;
>
> The
On 02-03-2020 18:24, 'm...@spectrumpacsold.com' m...@spectrumpacs.com
[firebird-support] wrote:
>
>
> Hello, why do we keep getting so many copies of this email? Thanks.
Looking at the headers of the emails, Yahoo Groups is repeatedly sending
the emails. According to the headers, it was
On 01-03-2020 07:07, Pól Ua Laoínecháin lineh...@tcd.ie
[firebird-support] wrote:
> TL;DR - I want to install FB without being the root or firebird user.
> Tried some stuff - explained below - didn't work. Anybody got any
> ideas?
Your question about modifying the build of Firebird would
On 19-02-2020 11:59, 'Mathias Pannier (unitel)' pann...@ubsysteme.de
[firebird-support] wrote:
> Firebird has no limit. But Windows Sockets.
>
> http://www.firebirdfaq.org/faq292/
That is actually a limitation in Firebird SuperServer and SuperClassic
on Windows, and in Firebird 3 and 2.5.3 it
On 28-02-2020 05:13, FSPAPA INCA Team i...@foodstuffs-si.co.nz
[firebird-support] wrote:
> I'm also using Firebird 3 (3.0.4), with a new test database containing its
> own security database.
>
> The setup is similar:
>
> create global mapping trusted_auth using plugin win_sspi from any user to
On 28-02-2020 20:11, Roberto Vieweg jjw.roberto.fireb...@gmail.com
[firebird-support] wrote:
> Is possible to use the SET BIND feature
> (https://github.com/FirebirdSQL/firebird/blob/master/doc/sql.extensions/README.set_bind.md)
> from Firebird 3 to remap the datatype of a count statement from
On 28-02-2020 21:33, Roberto Vieweg jjw.roberto.fireb...@gmail.com
[firebird-support] wrote:
> The problem of use CAST, is the result of the same work to convert the
> TIntegerFields, so as so is to much work!
>
> I cannot use SET BIND? This command really exists?
You cannot use it in Firebird
On 2020-02-26 19:41, hamacker sirhamac...@gmail.com [firebird-support]
wrote:
> When I started my test, I turn off my app.
>
> And do update(and select) using only ISQL tool (IBExpert) and
> dbweaver.
> in both I had to configure select to show float using mask
> (0.##..), so the number can
On 2020-02-26 19:07, hamacker sirhamac...@gmail.com [firebird-support]
wrote:
> Hi All,
>
> I do this update:
> UPDATE CV SET
> perc_lucro=42.503064336972848
> WHERE (id_cv=57528)
>
> Then I do a select and 'perc_lucro' was change to 42,5030643369728
> after updated, two last numbers
On 2020-02-26 06:22, Matthias Winkler spmm...@gmail.com
[firebird-support] wrote:
> Hello Firebird-Group,
>
> With our device we recalculate statistics ALWAYS when booting up the
> system. Now the DB grows bigger this can now take more than 10 minutes
> and delays
> the time until we can really
On 13-02-2020 15:11, 'Martin, Nicole (UK, Yeovil)'
nicole.mar...@baesystems.com [firebird-support] wrote:
> I have a feeling I have been added to a group that isn't right as the subject
> doesn't match what I am asking in my email?
This is the firebird-support mailing list for community support
On 2020-01-30 16:02, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 27.01.2020 19:23, Daniel Wenzel danielwenz...@hotmail.com
> [firebird-support] wrote:
>> So my question is, there's a way of modifying SQLLEN of Firebird ODBC
>> driver to match
>> unixODBC configuration?
>
>
On 2020-01-24 14:39, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 24.01.2020 14:29, Matthias Winkler spmm...@gmail.com [firebird-support]
> wrote:
>> I see the very same issue with firebird 3.0.4. Any ideas?
>
>You made nested loop on 18000*18000 records with sorting on
On 2020-01-24 13:29, Matthias Winkler spmm...@gmail.com
[firebird-support] wrote:
> Hello,
>
> With Firebird 2.1.7 this statement freezes my firebird server
> completely. Firebird will
> take 100% CPU.
>
>> select first(8) ID from TBL_TEST
>> where ID not in (select first(2) ID from TBL_TEST
On 2020-01-14 00:40, 'Andrew Zenz' and...@aimsoftware.com.au
[firebird-support] wrote:
> I have tried various iterations of it, as a BYTE and as Pablo Sanchez
> suggests in a later response, a CSTRING, eg:
>
> spb_buffer BYTE,DIM(128)
>
> or
>
> spb_buffer CSTRING(128)
>
> As
On 13-01-2020 16:36, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> Please see my question here:
> https://dba.stackexchange.com/questions/257259/is-it-safe-to-risk-multiple-firebird-nbackup-l
>
> Quoting here, but wish you will reply at the site, if acceptable to
On 2020-01-09 23:42, Hugo Eyng hugoe...@msn.com [firebird-support]
wrote:
> Hello.
>
> Win10 64 and Win7 32
>
> FB 2.5 32bits
>
> When I execute "select current_time from RDB$Database" FB returns 1
> (one) hour more then the current time.
>
> Did somebody faced this troble?
Sounds like the
On 2020-01-07 19:49, hamacker sirhamac...@gmail.com [firebird-support]
wrote:
> There is a SEC$DESCRIPTION field on security users table, but
> CREATE/ALTER USER command does not any parameter to change it, is it
> correct?
Since Firebird 3, you can use:
COMMENT ON USER IS ''
This
On 05/01/2020 15:55, John M buff...@gmail.com [firebird-support] wrote:
>> > My DB is very small at < 200MB. Is it better to upgrade to FB 2.5.9
>> > before the win upgrade? If so, what is the best way to do this upgrade?
>> >
>> > I have spent several hours already googling answers, but none I
On 04/01/2020 23:04, John M buff...@gmail.com [firebird-support] wrote:
> I'm have an very old app that is using FB 2.5.2 on windows 7. As many
> know we are being compelled to upgrade to win 10. Will the win 10
> upgrade break during this upgrade? If so, what is the best way to avoid
> this
On 02/01/2020 16:31, Kevin Stanton kevin.stan...@rdb-solutions.com
[firebird-support] wrote:
> The error was:
>
> Gbak error: I/O error for file “c:\fbThe system cannot find file specified.”
> Gbak error: Error while trying to open file.
> Gbak error: The system cannot find the file specified.
On 31/12/2019 12:40, Nagy Szilveszter nagy_szilvesz...@yahoo.com
[firebird-support] wrote:
> Is there a way to set _connection timeout_ for firebird _at client side_?
[..]
> At server side there is a ConnectionTimeout parameter, but it does not
> help me in this case (when i try to connect to an
On 31/12/2019 18:27, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> Gfix didn´t work even using it as you explained.
Please be more specific than "didn't work". What happened, did you get
an error, did gfix find nothing wrong? What was the gfix output?
Mark
--
Mark Rotteveel
On 2019-12-30 17:57, Germán Balbi bal...@yahoo.com [firebird-support]
wrote:
> Hi.
> I have this problem in FB 2.5
>
> with x as (
> SELECT *
> FROM tbl_x1
> JOIN tbl_fk1 ON cond_1
> WHERE cond_w1
> UNION
> SELECT *
> FROM tbl_x1
> JOIN tbl_fk1 ON cond_2
> WHERE cond_w2
> )
>
>
On 27/12/2019 20:49, Hugo Eyng hugoe...@msn.com [firebird-support] wrote:
> FB 2.5.7
> Windows 10 64 bits
> Page size 4096
I'd suggest upgrading to 2.5.9 and see if that fixes the problem. Both
in 2.5.8 and 2.5.9, bugs with gbak were fixed. Those bug fixes don't
match the description of this
On 20/12/2019 16:43, Steve Naidamast blackfalconsoftw...@outlook.com
[firebird-support] wrote:
> I am curious regarding your suggestion to use Firebird Server instead of the
> embedded edition.
>
> Is there a way to silently install the Firebird Server without any user
> intervention during my
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 starting to
> implement in my project) and if not, is there expected to be at
To unsubscribe, send an email to
firebird-support-unsubscr...@yahoogroups.com
Mark
On 2019-12-18 16:34, David Wurdeman david.wurde...@mvpmt.com
[firebird-support] wrote:
> Please unsubscribe me from this group
>
> David A. Wurdeman
>
> Predictive Maintenance Technologies
>
> 914 East 17th
On 2019-12-17 15:36, David Wurdeman david.wurde...@mvpmt.com
[firebird-support] wrote:
> Thank you for the reply
>
> We use an application called Ascent, which is used to analyze
> vibration data from industrial machines. It stores its data in .fdb
> files. These files can either be on the
On 2019-12-16 22:00, David Wurdeman david.wurde...@mvpmt.com
[firebird-support] wrote:
> We have an application that uses Firebird to open .FDB databases, that
> are stored on a shared directory on a server.
Database should be 'shared' through a Firebird server instance. Users
connect to the
On 14/12/2019 06:13, Hugo Larson hugo.lar...@yahoo.com
[firebird-support] wrote:
> Is it possible to use wildcard somehow like this.
>
> SELECT * FROM PRODUCT
> WHERE PRODUCT.ID IN (:param)
>
> param will be a list or IDs or a wildcard.
> % does not work.
> Goal is to get all PRODUCT with
On 13/12/2019 19:07, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> Is a field I create, or is it part of all records?
It is a field you create. Which is why I wrote "Where is the
table in question, and is a suitable column (eg a timestamp)
to determine what the newest record
On 13/12/2019 16:48, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> One table contains history. The old history is never replaced. New
> history is added. What is relevant is the most recent history. Is there
> a way to find the newest records without the KeyID?
Yes, you do
On 2019-12-13 12:48, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> I added the KeyID so I could sort from newest to oldest. Was it
> necessary to add this KeyID, or is there another way to find the
> newest records without the KeyID?
That depends on what you're trying to achieve,
On 2019-12-13 08:14, Kjell Rilbe kjell.ri...@marknadsinformation.se
[firebird-support] wrote:
> Den 2019-12-12 kl. 22:36, skrev Clyde Eisenbeis cte...@gmail.com
> [firebird-support]:
>> Marcin, Minor tweak => works! I also added DESC to retrieve the
>> newest records using the field key name
On 2019-12-12 19:59, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> This finds all records:
> ``
> "SELECT * FROM " + stTableName
>
> ``
>
> This does not work:
>
> `` "SELECT
On 09/12/2019 09:05, Nikolay Marinov kok...@yahoo.com [firebird-support]
wrote:
> using WIN1251 , this query works fine in FB 2.5
>
> select '123' as "Това е едно дълго име на колона" from rdb$database;
>
> under FB 3.0 it doesn't:
> can't format message 13:198 -- message file
>
On 06/12/2019 17:41, David Wurdeman david.wurde...@mvpmt.com
[firebird-support] wrote:
> I opened the port, and now I can connect to the databases.
>
> However now I’m getting an error when connecting. It says that the
> database is already open (with the IP address of the connecting
>
On 2019-12-03 23:20, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 03.12.2019 22:28, nvat...@yahoo.com [firebird-support] wrote:
>> I see that NoNagle can be Enabled on the server by setting True in the
>> Firebird Server Config file.
>
>On contrary, it can be Disabled
On 29-11-2019 22:52, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> The fstName is the column title, not the value. I'm using embedded
> Firebird.
That you're using Firebird Embedded doesn't matter, it works exactly the
same as Firebird Server for queries. The problem is that
On 25-11-2019 15:25, Roberto Vieweg jjw.roberto.fireb...@gmail.com
[firebird-support] wrote:
> The problem was the "time" between perform the SHUTDOWN and the VALIDATION.
>
> I just add a 1 second "sleep" between the shutdown and validate, and it
> works!
>
> FBMaintenanceManager mgr = ..
On 25-11-2019 13:52, Roberto Vieweg jjw.roberto.fireb...@gmail.com
[firebird-support] wrote:
> I'm trying to use Jaybird to validate a database before start the
> update process of my database definition.
>
> This validation is necessary to prevent the update of a corrupted database.
What is
On 22-11-2019 20:27, Alexandre Vinhaes - Tecnico - Tecnologia
alexandre.vinh...@cipa.com.br [firebird-support] wrote:
> Version 3.0.4 MOD is not custom function..it is a built-in function.
Then as far as I know you shouldn't need to grant anything. I don't
think you even can grant anything
On 22-11-2019 15:10, Alexandre Vinhaes - Tecnico - Tecnologia
alexandre.vinh...@cipa.com.br [firebird-support] wrote:
> I have a problem here during an update statement that call the function
> MOD. Althougt I have done related grant command "grant execute on
> function MOD to users1" the erro
On 2019-11-22 11:02, Alan J Davies alan.dav...@aldis-systems.co.uk
[firebird-support] wrote:
> Hi all, is it possible to update a table when the current_date in
> rdb$database changes to the next day?
>
> I need to reset a delivery counter to 0 in all the orders on a system.
> I can presently do
On 2019-11-21 20:29, Roberto Vieweg jjw.roberto.fireb...@gmail.com
[firebird-support] wrote:
> Full stack
>
> java.sql.SQLException: Unable to complete network request to host
> "127.0.0.1". [SQLState:08006, ISC error code:335544721]
> at
>
On 2019-11-18 21:32, mlcvi...@yahoo.fr [firebird-support] wrote:
> Hello,
>
> I have Firebird 2.58 32 bit version in the C:\Program Files
> (x86)\Firebird\Firebird_2_5
We're not talking about your Firebird server install, we're talking
about client libraries fbclient.dll or gds32.dll, and
On 2019-11-17 12:22, jerz...@o2.pl [firebird-support] wrote:
> On Sat, 16 Nov 2019 10:29:44 +0100, Mark Rotteveel
> m...@lawinegevaar.nl [firebird-support] wrote:
>> Because it is hard to do. A lot of internals in Firebird and its
>> clients
>> rely on this maximum size
On 16-11-2019 09:33, jerz...@o2.pl [firebird-support] wrote:
>
>>> But only for FB 2.5, not for FB3!
>>> My question was about FB3. Where is info about new versions?
>
>> In Release Notes for these versions.
>> Maximum size of record was not changed.
>
>
> This is a very big
On 2019-11-14 23:47, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> Doesn't the page size definition as per a database depend on one
> designs their database tables and how such tables will be used?
The page size doesn't restrict or limit your database design, with the
exception of
On 2019-11-15 00:12, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> Thanks for clarifying! This is very useful info, especially the
> ibexpert.net [1] site.
>
> Is there a Firebird site that provides details such as CHAR and
> VARCHAR max sizes, pageSize size options, etc.?
Most
On 14-11-2019 19:02, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 14.11.2019 18:01, blackfalconsoftw...@outlook.com [firebird-support] wrote:
>> However, the PDF language manual I have for version 2.5 does in fact state
>> the following...
>>
>>
>> "A fixed-length character
On 14-11-2019 18:01, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> 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
On 14-11-2019 17:06, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> What do you mean I am wrong? I have merely re-iterated how all database
> engines I have worked operate.
Telling us how other engines work is not very relevant when discussing
Firebird, and when the **internal
On 2019-11-14 03:40, Richard Damon rich...@damon-family.org
[firebird-support] wrote:
> On 11/13/19 9:51 AM, blackfalconsoftw...@outlook.com [firebird-support]
> wrote:
>>
>> Thank you Anne, for your succinct comments regarding the differences
>> between the efficiencies of a CHAR and VARCHAR
On 2019-11-13 17:37, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> 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
On 2019-11-13 15:51, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> 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
On 2019-11-13 18:42, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> 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
>
On 2019-11-12 23:06, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
> As I understand, the FbConnection.CreateDatabase max pageSize for
> VARCHAR is 8191. Does the page size change to less than 8191 if the
> VARCHAR is less?
>
> What is the max pageSize for CHAR?
Page size is about
On 12-11-2019 10:31, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
> 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:
&g
On 12-11-2019 13:37, Michal Kurczabinski michk...@gmail.com
[firebird-support] wrote:
> Is this old bug from FB 2.5.x or some kind of feature ?
>
> This still exists in FB 3.x
It would be helpful to also describe the problem, and not only let
people execute a query and try to guess what
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:
1 - 100 of 804 matches
Mail list logo