Thank you.
Perhaps I have to recreate the Database with FB 3.0.5?
Can You show me Your Create Mapping Statement?
Does You access your database with Your Windows Account AND the Firebird ROLE?
Regards
Mathias
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Thanks. I know this issue. After I found this issue I have updated from 3.0.4
to 3.0.5 but the problem is the same.
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Sonntag, 1. März 2020 21:07
An: firebird-support@yahoogroups.com
Betreff:
HiWithout analysis i can only advice to create descending index.Create
descending index ixd_mytable__timestamp on mytable(timestamp)Regards,Karol
Bieniaszewski
null
Hi again Mathias – just confirming that upgrading from 3.0.4 to 3.0..5 resolved
this issue for me.
Before (Firebird 3.0.4):
PS C:\Users\PGMRSD1> c:\apps\firebird\isql.exe localhost/3051:foo
Database: localhost/3051:foo, User: FOODSTUFF\PGMRSD1
SQL> select current_user, current_role from
Hello,
I guess this is another beginners question:
I have a table with 300`000 entries.
Each row has a separate field TIMESTAMP with its creation data.
Now, I query the latest 100 hundred using:
select first(100) X, Y, TIMESTAMP
from MY_TABLE
order by TIMESTAMP DESC -- order by takes all the
02.03.2020 23:15, Robert martin r...@chreos.com [firebird-support] wrote:
> Obviously this doesn't
> work if your dfms are binary.
Single line of CMD code:
for /r %i in (.) do convert %i
--
WBR, SD.
I have dealt with this before on large projects (FB 2.0 / 2.5). Its not
really a big deal. Just do a (text) search through your .dfm
(form/datamodule) files for the field and edit the text files to change
the data type to the correct version. You can even automate the process
as required.
I think this isn't only my "pain".
I good solution here will be a configuration for legacy systems, like
Authentication legacy.
Em seg., 2 de mar. de 2020 às 06:13, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] escreveu:
>
>
> On 28-02-2020 20:11, Roberto Vieweg
Hi Mathias – I've found a relevant issue… it contains all the keywords you'd
think to search for but eventually I found it in the changelog by searching the
source for "mapping":
http://tracker.firebirdsql.org/browse/CORE-5639
It is marked as resolved in 3.0.5, I'm hoping to test this out today
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
> Hello,
>
> ok, I guess I need to create a DESC index on TIMESTAMP of MY_TABLE.
> I could verify this speeds it up from 1 minute to 1 second.
> This works as long as MY_TABLE is a real table.
> But now MY_TABLE is actually a View.
>
> Can I created a index on a view with firebird?
No, but an
It is not whole true.It is developer choice to use persistent fields or not.I
do not see any benefit to use persistent fields and because of this i have not
problem with count in my Delphi applications. I have reported the possible
problem few years ago when fb3 beta was in action. But this was
Hello,
ok, I guess I need to create a DESC index on TIMESTAMP of MY_TABLE.
I could verify this speeds it up from 1 minute to 1 second.
This works as long as MY_TABLE is a real table.
But now MY_TABLE is actually a View.
Can I created a index on a view with firebird?
BR
Matthias
On Mon,
Nice to know. I thought it was an OS limitation.
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Sonntag, 1. März 2020 18:28
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] Scalability of connection numbers of
client-server
Hello, why do we keep getting so many copies of this email? Thanks.
�
From: firebird-support@yahoogroups.com
Sent: Friday, February 28, 2020 3:33 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] How to "remap" the count datatype from BIGINT
to INTEGER in firebird 3
I also do not have Windows 2016 Server nor VMware. I put development down for
few years, just reviewing and picking it back up. Just trying to get a feel
for the work and to talk about what I am doing and to get introduced. Pardon
the Iron oxide. I agree, if it works one Windows 2019, then
29.02.2020 09:38, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote:
> I'm surprised that there is no automatic
> coercion within Delphi.
DB VCL has some dumb parts because it was designed for using with BDE only.
--
WBR, SD.
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
20 matches
Mail list logo