Hello River
Thanks for your suggestion but I need to use UPDATE OR INSERT.
I know that an INSERT without an IDENTITY column will work well. That's not
the problem.
But I never use INSERT, I always use UPDATE OR INSERT.
And with an IDENTITY column it is impossible to use UPDATE OR INSERT
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
hi Walter
Try
INSERT INTO mytable(column2) VALUES (12345)
In other words, do not try to insert the column you want to be
auto-generated. The database engine will notice that you are inserting
only a subset of the columns, and SHOULD use the default values for
the missing columns, which would
Hello Daniel
Yes, I agree with you, IDENTITY columns are useless for me, so I quit using
them. Maybe for a log table or something so can serve, but for normal work
they are useless.
I had returned to the old and well suitable practice of generator/trigger,
so with a short stored procedure I can
I experimented with IDENTITY fields myself - based on my experience and
some older comments here I quit using them. I think they are presently
suitable for "quick" tables - something that will be append only like a log.
If you're looking for more advanced features, like supporting UPDATE OR
Hello Herman
I had used UPDATE OR INSERT for several years in several hundred of tables.
No problem...with Firebird 2.5.x
But with Firebird 3.0.x I can not make it work.
If I write the identity column, doesn't work. If I don't write the identity
column, doesn't work.
Thank you very much for
Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente'
sistemas2000profesio...@gmail.com [firebird-support]:
I use firebird3 from libreoffice base, not directly, but in that way I
can make (and have done) such insert stattements.
CREATE TABLE MYTABLE (
COLUMN1 INTEGER GENERATED BY
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:
I think this behaviour is consistent with the ANSI standard. The double
quotes are necessary (if my memory serves me correctly) if there are
characters in the user name that are not letters numbers and underscores.
Maybe hyphens/minus are allowed also. But it's the dot that is annoying the
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
>
28.07.2020 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> I think that double quotes are used only if you want case sensitive
They are required for any SQL identifier that contains non-allowed
characters.
--
WBR, SD.
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:
>
Thank you, I will follow your instructions.
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message -
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
To:
Sent: Friday, June 26, 2020 3:34 PM
Subject: Re: [firebird-supp
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:
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
https://firebirdsql.org/en/reference-manuals/
Google Translate can help you read it.
--
WBR,
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message -
From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]"
To:
Sent: Thursday, June 25, 2020 3:18 PM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on
se
25.06.2020 20:50, 'Ismael L. Donis Garcia' sli...@natio.co.cu
[firebird-support] wrote:
> And how do I assign the pre-benefits to the user that I am going to use to
> create the database?
Using "GRANT" statement as described in Language Reference.
--
WBR, SD.
pport]"
To:
Sent: Thursday, June 25, 2020 11:07 AM
Subject: Re: [firebird-support] error when trying to open databases 2.5 on
server 3.0.5
> 25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu
> [firebird-support] wrote:
>> Is it possible to open database
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
Release Notes
"New ODS Number
Firebird 3.0 creates databases with an ODS (On-Disk Structure) version of 12.
In the initial release, a database
with an older ODS cannot be opened by Firebird 3.0. In order to work with a
database with an older ODS it will
be necessary to make a backup using gbak
25.06.2020 16:46, 'Ismael L. Donis Garcia' sli...@natio.co.cu
[firebird-support] wrote:
> Is it possible to open database 2.5.9 on servers 3.0.5?
No.
> Is it possible to create databases on a 3.0.5 server with a user other than
> sysdba?
Yes, but appropriate privilege must be granted to
24.06.2020 14:20, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> the issue is not resolved. Now it complains the database does not exist.
That's another issue. Check that path and name of database are right.
--
WBR, SD.
On Wed, 24 Jun 2020, 4:47 pm Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support], wrote:
> 24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > the Process Explorer reports the dll as under :
> >
> > D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll
24.06.2020 13:14, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> the Process Explorer reports the dll as under :
>
> D:\Program Files\Firebird\Firebird_3_0\WOW64\fbclient.dll
That's the problem. This library must not be used from this place but copied
into
On Wed, Jun 24, 2020 at 2:10 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > Use Process Explorer to find out which exactly fbclient.dll is
> loaded.
> >
> > I do not find
24.06.2020 03:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> Use Process Explorer to find out which exactly fbclient.dll is loaded.
>
> I do not find fbclient.dll listed in the Task Manager of the client Windows
> machine when i
> attempt to connect to the Firebird
On Tue, Jun 23, 2020 at 9:53 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > I have not set any environment variable.
> >
> > But I do have Firebird 3..0 installed on the client Windows
23.06.2020 18:07, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> I have not set any environment variable.
>
> But I do have Firebird 3..0 installed on the client Windows machine, to this
> the
> flamerobin connects without issues.
Use Process Explorer to find out which
On Tue, Jun 23, 2020 at 9:12 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA'
> password 'myPassword';
>
>I see.
23.06.2020 17:35, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> connect "192.168.0.2:/home/ubuntuUser/Firebird/MYDB.FDB" user 'SYSDBA'
> password 'myPassword';
I see. Normally Firebird client library cannot find plugins and don't try to
use them.
Is environment variable
On Tue, Jun 23, 2020 at 8:27 PM Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > Do not use embedded mode.
> >
> > I am not using embedded mode.
>
>Show connection string.
>
connect
23.06.2020 16:08, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> Do not use embedded mode.
>
> I am not using embedded mode.
Show connection string.
--
WBR, SD.
On Tue, 23 Jun 2020, 7:37 pm Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support], wrote:
> 23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support]
> wrote:
> > But when I try to connect using Flamerobin, i get the message:
> >
> > Error loading plugin Engine12
> > Module
23.06.2020 14:46, LtColRDSChauhan rdsc1...@gmail.com [firebird-support] wrote:
> But when I try to connect using Flamerobin, i get the message:
>
> Error loading plugin Engine12
> Module d:\Program Files\Firebird_3_0\plugins/Engine12 exists but can
> be loaded
> unknown Win32 error 193
Flame
I'm jumping in late on this one, but I'm wondering if you could implement a
single database that all users share but they are restricted to seeing only
their own data. I know it isn't the question you asked, but I believe that
many rows are more easily handled than many databases.
I'm glad you
27.05.2020 13:29, 'Olaf Kluge' olaf.kl...@satron.de [firebird-support] wrote:
> what function can I take instead of the isc_expand_dpb?
There is no replacement for this function. You must use the same allocation
function
that was used for original DPB which depends on the host language.
--
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
27.05.2020 12:51, 'Check_Mail' check_m...@satron.de [firebird-support] wrote:
> The name of the function is /*isc_expand_dpb*/
This function is deprecated since Firebird 1.0.
--
WBR, SD.
You need to move this question to mailto:firebird-supp...@googlegroups.com
See https://groups.google.com/d/forum/firebird-support
On Wed, 13 May 2020 16:39:15 -0400 Roberto Vieweg
jjw.roberto.fireb...@gmail.com [firebird-support]
wrote
Hi.
I have a environment with 150
Assunto: Re: [firebird-support] Firebird x CentOS 7
Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
>
> About:
>
> "According to Fedora packaging rules, firebird service is not started
> automatically. You need to start it
Le 11/05/2020 à 21:26, Hugo Eyng hugoe...@msn.com [firebird-support] a
écrit :
> Hello Mr. Makowski,
>
> About:
>
> "According to Fedora packaging rules, firebird service is not started
> automatically. You need to start it, as root :
> systemctl start firebird-superserver.service
> If you
om em nome
de Philippe Makowski pmakow...@ibphoenix.fr [firebird-support]
Enviado: sábado, 9 de maio de 2020 12:18
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] Firebird x CentOS 7
Hugo Eyng hugoe...@msn.com [firebird-support] a écrit le 08/05/2020 à
21:07 :
> Dear Fr
Hugo Eyng hugoe...@msn.com [firebird-support] a écrit le 08/05/2020 à
21:07 :
> Dear Friends,
>
> Where can I find a good tutorial to learn how to install FB 2.5.9 ( or
> higher) in CentOS 7?
>
> If anyone already installed and used FB in this SO: what the best option:
> 1-superserver,
Thank you for spelling that out - my deductive powers are weak. ;(
Best regards
On 6/05/2020 8:04 pm, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support]
> wrote:
>> It just shows
>>
>> Firebird SQL
06.05.2020 12:01, Tony Christiansen t...@adegroup.com.au [firebird-support]
wrote:
> It just shows
>
> Firebird SQL Server (32 bit)
> - Firebird Server - DefaultInstance
>
> No mention of the mode that I can see.
You should also read documentation about differences between the modes.
It just shows
Firebird SQL Server (32 bit)
- Firebird Server - DefaultInstance
No mention of the mode that I can see.
On 6/05/2020 7:28 pm, Dimitry Sibiryakov s...@ibphoenix.com
[firebird-support] wrote:
> 06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support]
> wrote:
>>
06.05.2020 01:41, Tony Christiansen t...@adegroup.com.au [firebird-support]
wrote:
> Is there a way to check what mode FB v3.0 server is running in?
Windows Task Manager.
--
WBR, SD.
Thanks Dimitry
We have changed to 64-bit FB and it has significantly reduced the errors
so I suspect it was RAM etc resource related.
I will check firebird.log for more info.
Is there a way to check what mode FB v3.0 server is running in? Is the
only way to look at servermode in
04.05.2020 06:57, Tony Christiansen t...@adegroup.com.au [firebird-support]
wrote:
> My application (Delphi using IBX) has started randomly raising
> exceptions "Error writing data to the connection" when the user queries
> their database.
What is in server's firebird.log at this timestamp?
“so I guess this account is bonded to some google email account”
When you subscribe it asks you to confirm an e-mail address you want associated
with the group. I hardly every use my gmail account, so linked it to the same
e-mail as the yahoo one and getting notifications come through.
But,
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
Pablo-
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 or are blocked from Google Groups.
So Google does not like your email address
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 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 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:
The other problem with pigging Google is their drive to make us use a
Gmail account.
OK, so the last change was successful: The +0 as suggested by Set works.
The query now uses the faster query plan through the entire batch (at
least it still does after 1769 chunks.
Many thanks for all your input! I still think it would be interesting
with some theories about why the engine
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
Sorry Carlos - I read that wrong. Thought you were asking if the script could
be run with isql.
Cheers,
Kevin
> On Apr 30, 2020, at 8:04 AM, 'Carlos H. Cantu' lis...@warmboot.com.br
> [firebird-support] wrote:
>
> Step 1 is better if you are going from dialect 1 to 3, mostly due to
>
irebird-support]
Subject: Re: [firebird-support] Timestamp in different regions
Hello Zoran
Witch Component do you useing in Delphi FireDAC?
Are you shure, that that your clients uses the right client-library
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5
What FB Version do
similar problem.
Regards
Zoran
From: firebird-support@yahoogroups.com
Sent: Thursday, April 30, 2020 11:35 AM
To: 'Zoran' zoran...@gmail.com [firebird-support]
Subject: Re: [firebird-support] Timestamp in different regions
Hello Zoran
Witch Component do you useing in Delphi
Great - thanks Mark. I only need FR just for that, simple queries and the
occasional update/delete sql.
> On Apr 30, 2020, at 9:09 AM, Mark Rotteveel m...@lawinegevaar.nl
> [firebird-support] wrote:
>
> On 2020-04-30 17:42, Kevin Stanton kevin.stan...@rdb-solutions.com
>
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
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 is true even
on a completely new FB3 database):
gbak:fixing views dbkey length
gbak:updating
Hello Zoran
Witch Component do you useing in Delphi FireDAC?
Are you shure, that that your clients uses the right client-library
fbclient.dll or GDS32.dll? Means FB 3.0.5 should use fbclient from V3.0.5
What FB Version do you use?
Best Regards
Gregor
Sent from Yahoo Mail. Get the app
Thankfully I moved from D1 to D3 many years ago.
So now just need to get to FB3.
Cheers,
Kevin
> On Apr 30, 2020, at 7:37 AM, 'Jason (PN)' ja...@jac2.co.uk [firebird-support]
> wrote:
>
> Hi Kevin,
>
> Can I ask what dialect you are going from and to?
>
> Sorry I don’t have an
30.04.2020 17:30, 'Zoran' zoran...@gmail.com [firebird-support] wrote:
> What I was hopping for is if someone with Delphi background can shed some
> light on Delphi
> handling this situation.
Usually such situations are handled by debugging. You use debugging version
of VCL and
RTL, enable
Thank you, Karol.
Probably not FB message. I guess it’s coming from Delphi. It happens right
after I execute ‘qry.Open;’ statement.
What I was hopping for is if someone with Delphi background can shed some light
on Delphi handling this situation.
From:
Step 1 is better if you are going from dialect 1 to 3, mostly due to
the difference in the numerics internal storage.
I see no problem with any of the approaches.
I would add that, imho, step 4 in process 2 is not really necessary,
unless you want to reset the metadata versions count of the
Hi Kevin,
Can I ask what dialect you are going from and to?
Sorry I don’t have an opinion on P1 vs P2. Do you know why P1 is recommended
over P2?
As you may have guessed, I have this same thing to do 1.5.6 D1 -> ?.
Thanks,
Jason
From: firebird-support@yahoogroups.com
Sent: 30
Are you using EPEL package ?
or Firebird project binaries ?
There is a compilation issue in Epel package since 2.5.8, and nobody
understand exactly what
fbintl from 2.5.7 package is ok
cf https://bugzilla.redhat.com/show_bug.cgi?id=1636177
and http://tracker.firebirdsql.org/browse/CORE-5925
but
This is a known problem with the EPEL rpms.
Workarounds include using the rpm packages for superclassic, which don't
have the problem, or installing the project-provided rpms (which install
under /opt). It *might* also work if you replace that specific file with
the one from the EPEL rpm from
29.04.2020 15:40, 'P-Soft - Fabio Codebue' f.code...@p-soft.biz
[firebird-support] wrote:
> Can't load INTL module '/usr/lib64/firebird/intl/fbintl.so'
>
> Some ideas?
Check dependencies using ldd.
--
WBR, SD.
I don't know why things slow down, Kjell, if the batch job updates records,
I guess it could be related to there being lots of versions of some records
and that garbage are only collected after your application ends (it sounds
plausible if transactions are still open when you "Stopping the batch
Excellent! Thanks!
Feel free to anser that in StackOverflow too (link below). If not, I
will do it myself after testing it and mark my own answer as the correct
one.
Regards,
Kjell
Den 2020-04-22 kl. 10:08, skrev 'Paul Beach' pbe...@mail.ibphoenix.com
[firebird-support]:
>
> MON$TABLES ->
MON$TABLES -> MON$BACKUP_STATE -> 0 - Normal, 1 - Stalled, 2 - Merge.
Regards
Paul
-Original Message-
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 22 April 2020 09:56
To: Firebird Forum
Subject: [firebird-support] How to inspect nbak state of a
18.04.2020 18:56, Shane delphi_ric...@yahoo.co.uk [firebird-support] wrote:
> But Like I said Errors where produced with restoring, like size error
A new feature for you to learn: copy-paste from console window to mail
client.
--
WBR, SD.
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
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 for the restore string
http://www.destructor.de/firebird/gbak.htm. But Like I said Errors where
For gbak on a windows machine:
"c:\Program files\Firebird\Firebird_2_5\bin\gbak" -c -v -user SYSDBA
-pas masterkey backupfilename.fbk targetfilename.fdb
-c to create a new file
-v to be verbose and show on screen what's happening
- user and password
Op 18-04-2020 om 17:58 schreef Shane
The Firebird version was not tampered with in this fault. Although
what's I thought was strange is the support person uninstalled Firebird
then re-installed. I never saw him going to Microsoft service file to
stop Firebird.
Could someone give me the script to restore a .fbk file. I kept on
Actually I meant the Firebird Server version. Are they the same on Linux
and Windows?
GBak is designed to make a backup on the fly, even with many users
connected and using the database. No need to shut down.
Make sure the gbak-restore creates a new file and does not write into an
existing
I agree with the version, as the company comes out with different
version of there client software, that does an update change.
The other part of not switch off the Firebird before copying would
create a fault even though no one was working on the database?
Because I did try making sure the
In your description you did not include a step to shutdown the server or
database on Windows before copying it to Linux. Did you do that?
Doug C.
On Fri, 17 Apr 2020 05:21:03 -0400 Shane delphi_ric...@yahoo.co.uk
[firebird-support] wrote
I've been dealing with this company
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
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
--
Nick
On Fri, 17 Apr 2020 at 12:15, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support] wrote:
>
>
>
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.
Maybe there is a version issue? If you can connect to the restored database
through Flamerobin and browse the tables, then there's probably nothing wrong
with the database. But if the clientprogram and it's library expect a certain
version and the version is different, they may respond with a
Thank you very much for the quick reply.
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. I
do the systemctl stop to Firebird on the
Shane,
AFAIK, ALWAYS use a Backup/Restore cycle when moving a Firebird database
from one computer to another, especially from one OS to a different OS.
Use the Gbak tool on the original machine to create a backup file.
Use the GBak tool on the target machine to restore the backupfile to a
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
11.04.2020 11:41, Lukas Gradl fireb...@ssn.at [firebird-support] wrote:
> Now I'd love to use the transaction-mechanism for giving the user of
> my app a possibility to revoke the changes made.
>
> Can this be achived somehow?
User management is outside of database and performed in an
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 sysdba
>
> Doing that will lose
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
09.04.2020 06:47, Andrea Raimondi andrea.raimo...@gmail.com [firebird-support]
wrote:
> What I'd like to do is to reset the pw to something known
Connect to any database in embedded mode with user name SYSDBA (without
password) and
use ALTER USER query.
--
WBR, SD.
HiSimply replace security3.fdb by ine from the zip install and initialize
sysdbaRegards,Karol Bieniaszewski
null
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
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 possible?
Ok, print the script and study it.
Antonio Bianca
Il 04/04/2020 10:57, Mark
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
Thank you for your reply, Lester.
I came across CTE during my research, but wasn't sure it was the right thing
for this case. Looked more detailed into it and came up with this:
with TOTAL_STOCKS as (
select PRODUCTID,
STORAGE_AREA_ID_SOURCE,
sum(AMOUNT) as TOTAL_STOCK
from
On 02/04/2020 08:12, Patrick Marten patrick_mar...@yahoo.com
[firebird-support] wrote:
> There was an other procedure that took long, and I was able to
> drasticaly improve it by adding one multi-segment index, but all my
> attempts to do the same in the case above didn't have much impact so
1 - 100 of 10121 matches
Mail list logo