ort] error when trying to open databases 2.5 on
server 3.0.5
> 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 fir
ases 2.5 on
server 3.0.5
> 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 "GR
quot;
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 2.5.9 on
Is it possible to open database 2.5.9 on servers 3.0.5?
when I try to open it with flamerobin it gives me the following error:
Context:Database::Connect
Message:isc_attach_database failed
SQL Message:-820
wrong or obsolete version
Engine Code :335544379
Engine Message:
unsupported on-disk struct
Automated constructions of Linux snapshots are not being made since day 11.
Who could review this?
Best Regards
--
Ismael
I personally do not like it because it depends on Java, I like Flamerobin much
more which I will try to see if its development is resumed.
Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
Web Site: http://www.sisconge.byethost15.com/
- Original Messa
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.
Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message -
Because you do not try disabling automatic updates. The truth is that I do not
plan to enable that option ever, I do not like that the system is updated
automatically because it takes away the possibility of knowing that it is being
updated
I have always installed from source code without any pr
You should ask this question in the list of debian, or to the memos for my
understanding is the most appropriate
Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan
- Original Message -
From: pab...@adinet.com.uy [firebird-support]
To: firebir
I'm running Firebird 2.5.8 on Devuan Jessie with ext4 and works very well
Best Regards
--
Ismael
Devuan User : http://distrowatch.com/table.php?distribution=devuan
>- Original Message -
>From: Omacht András aoma...@mve.hu [firebird-support]
>To: firebird-support@yahoogroups.com
>Sent: Th
Sorry for the off topic, but I have a doubt that maybe some of you can clarify
I was reading Firebird 4.0 Release Notes and I found the following note:
Tracker ticket CORE-5238
On Linux, Firebird 4 uses the same network listener process (Firebird) for all
architectures. For Classic, the
main (lis
Solved
Best Regards
--
Ismael
Devuan User : http://distrowatch.com/table.php?distribution=devuan
- Original Message -
From: 'Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]
To: Firebird Support
Sent: Wednesday, June 07, 2017 3:55 PM
Subject: [firebi
Download FirebirdCS-2.5.7.27050-0.i686.tar.gz from the official Firebird site
When installing it on a Pc with Devon 1 32 bit the service is not executed.
Previously I had installed xinetd
How could you solve this problem?
>From what I see the installed does not recognize this operating system.
select itemnr count(dateused) from table group by itemnr
Best Regards
| ISMAEL |
- Original Message -
From: 'Stef' s...@autotech.co.za [firebird-support]
To: firebird-support@yahoogroups.com
Sent: Thursday, March 02, 2017 11:36 AM
Subject: [firebird-support
In Windows
gbak -b -t -user SYSDBA -pas adminpassword C:\database\database.fdb database.fbk
In Linux
gbak -c -user SYSDBA -pas adminpassword /var/lib/firebird/2.5/data/database.fbk
/var/lib/firebird/2.5/data/database.fdb
Saludos
| ISMAEL |
- Original Message ---
>- Original Message -
>From: hv...@users.sourceforge.net [firebird-support]
>To: firebird-support@yahoogroups.com
>Sent: Tuesday, July 12, 2016 3:40 PM
>Subject: [firebird-support] Re: Triggers on table MON$ATTACHMENTS
>
>> ---In firebird-support@yahoogroups.com, wrote :
>>
>> I can creat
>- Original Message -
>From: hv...@users.sourceforge.net [firebird-support]
>To: firebird-support@yahoogroups.com
>Sent: Tuesday, July 12, 2016 3:40 PM
>Subject: [firebird-support] Re: Triggers on table MON$ATTACHMENTS
>
>> ---In firebird-support@yahoogroups.com, wrote :
>>
>> I can creat
I can create triggers in the MON$ATTACHMENTS table?
I use Firebird 2.5.6 with flamerobin
I want to do something like "After Delete"
delete from table1 where con = old.MON$ATTACHMENT_ID
Best Regards
| ISMAEL |
Message -
From: 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]
To: Firebird Support
Sent: Wednesday, May 04, 2016 12:22 PM
Subject: [firebird-support] install firebird 3 in "devuan"
When I try to install firebird 3 in devuan system does not recognize
When I try to install firebird 3 in devuan system does not recognize me and
therefore not copy me the script to the folder /etc/init.d
Could someone fix this?
Couldn't autodetect linux type. You must select
the most appropriate startup script in /opt/firebird/misc
and manually register it in your
>- Original Message -
>From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
>To: firebird-support@yahoogroups.com
>Sent: Tuesday, April 26, 2016 9:38 AM
>Subject: Re: [firebird-support] conect flamerobin with Firebird3
>
>On 2016-04-26 14:10, 'I
which authentication method you are using on the server?
Test with:
Legacy Authentication
If you do not intend to use SRP encrypted log-ins right away and want to use
the security database—security3.fdb— as you have done in previous Firebird
versions, proceed as follows:
Using a text editor, ope
@yahoogroups.com
Sent: Tuesday, April 26, 2016 9:38 AM
Subject: Re: [firebird-support] conect flamerobin with Firebird3
On 2016-04-26 14:10, 'Ismael L. Donis Garcia' sli...@citricos.co.cu
[firebird-support] wrote:
> Create a firebird 3 bd in another user who is not sysdba
> a
He does not work with the library version 2.5, but already configured to work
with her.
If I delete the SYSDBA role if I connect to the database, but do not want to
eliminate that role.
If I remove the role SYSDBA when connected and once connected beyond the role I
think again you still connec
Create a firebird 3 bd in another user who is not sysdba
and create a role called sysdba without permission
and when I try to connect from flamerobin you give me the following error
message
*** IBPP::SQLException ***
Context: Database::Connect
Message: isc_attach_database failed
SQL Message : -9
As I can install firebird 3 RC2 superclasic in linux?
I want to try it on devuan, I do not know as installing superclasic.
Best Regards
| ISMAEL |
as I can install firebird 3 superclasic in linux?
I want to try it on devuan
Best Regards
| ISMAEL |
anyone knows when it will release version 2.5.3
Best Regards
| ISMAEL |
SELECT CAST(CURRENT_TIMESTAMP as DATE) || ' ' || EXTRACT(HOUR FROM
CURRENT_TIMESTAMP) || ':00:00' as date1
FROM RDB$DATABASE
Best Regard
| ISMAEL |
- Original Message -
From: Mark Rotteveel
To: firebird-support@yahoogroups.com
Sent: Tuesday, February 11, 2014
Hi
I want to install FB 3.0 alpha2 in Linux debian 7.3, that the tools of
administration recommend me to try the new characteristics owed.
Best Regards
| ISMAEL |
For my understanding migration is very fast.
Only for proofs and getting up to date weekly from the snapshow
BestRegards
| ISMAEL |
- Original Message -
From: Fabiano - Desenvolvimento SCI
To: firebird-support@yahoogroups.com
Sent: Tuesday, January 14, 2014 10
Test.
I am not receiving the messages that I send to the list
Best Regards
| ISMAEL |
CREATE PROCEDURE FindSalesAmt
RETURNS (
price decimal(18,2),
id bigint,
description VARCHAR(90)
)
AS
BEGIN
FOR SELECT startprice, itemid, title from ebayrevisefile WHERE price > 20.00
INTO :price, :id, :description DO
SUSPEND;
END
END
Best Regards
| ISMA
Replace
SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS - '" &
Format(Readin(3), "#0") & "' "
for
SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS -" & Format(Readin(3),
"#0")
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Andy
Download from site official FirebirdCS-2.5.2.26536-0.RC1.i686.tar.gz or
FirebirdCS-2.5.2.26536-0.RC1.amd64.tar.gz
Best Regards.
=
|| ISMAEL ||
=
PD: It works to me to perfection
- Original Message -
From: reinier_olislagers
To: firebird-support@yahoogroups.com
I am trying to install Firebird 2.5.2 CS i386 RC1 in they Debian squeeze,
but it does not start. And I do not see the cause of the problem. Has
somebody had this problem?
Best Regards.
=
|| ISMAEL ||
=
Because order by desc?.
This would revert the order of the operations.
=
|| ISMAEL ||
=
- Original Message -
From: K Z
To: firebird-support@yahoogroups.com
Sent: Wednesday, September 12, 2012 2:28 PM
Subject: [firebird-support] How to create an calculated fiel
I had not put the END of the CASE
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Ismael L. Donis Garcia
To: Firebird Support
Sent: Monday, September 03, 2012 4:08 PM
Subject: [firebird-support] I need help to create trigger in Flamerobin and
SET TERM ^ ;
CREATE TRIGGER AFCONFI_AU FOR AFCONFI ACTIVE
AFTER UPDATE POSITION 0
AS
BEGIN
/* Trigger para registrar el control de actividades */
if (old.fechap <> new.fechap) then
begin
if (old.fechap < new.fechap) then
execute procedure pi_afact(new.idac, 'Realizó el cierre
add FOR to SELECT
SET TERM ^ ;
CREATE PROCEDURE SP(
TLek VARCHAR(15) CHARACTER SET NONE COLLATE NONE)
RETURNS(
PNAME VARCHAR(100) CHARACTER SET NONE COLLATE NONE)
AS
BEGIN
for Select Name FROM TBL1 Where (TLekName = :TLek) ORDER BY ID
Into :PName DO
SUSPEND;
END ^
SET TERM ^ ;
=
|| IS
As I could validate that an alone field of varchar(11) enabled numbers and
that these had 11 characters of length?
Best Regards
=
|| ISMAEL ||
=
select * from (select "TESTID", "NAME" from test
union select "TESTID", "NAME" from test) t order by upper(2)
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: roydamman
To: firebird-support@yahoogroups.com
Sent: Wednesday, June 27, 2012 12:22 PM
Subjec
Exist some program to replication automatic to database firebird in Linux?
Best Regards
=
|| ISMAEL ||
=
[Non-text portions of this message have been removed]
I use FB 2.5.1
When I hold a consultation of a filter-tipped board he returns a record with
void value to me. As I avoid this?
select sum(t.saldo) as saldo from table1 t where t.id=X
returns 1 record with value null
As I make in order that do not return records in this case?
Best Regards
You do not have install the library libstdc++5
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Lester Caine
To: firebird-support
Sent: Wednesday, May 09, 2012 6:50 PM
Subject: [firebird-support] [Firebird-general] Linux install problem
Of caus
March 2012 03:21, Ismael L. Donis Garcia wrote:
> **
>
>
> That operation does not give the precision that I need ( 6 digits after
> decimal point )
>
> SELECT 54311.999455*cast((1/1.01) as integer) as mount FROM
> MON$ATTACHMENTS r = 54311.999455
>
That operation does not give the precision that I need ( 6 digits after decimal
point )
SELECT 54311.999455*cast((1/1.01) as integer) as mount FROM MON$ATTACHMENTS
r = 54311.999455
54311.999455 / 1.01 = 54311,945143
Thank you for everything
=
|| ISMAEL ||
=
- Ori
FB 2.5.1 superclasic
SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount
FROM MON$ATTACHMENTS r
*** IBPP::SQLException ***
Context: Statement::Fetch
Message: isc_dsql_fetch failed.
SQL Message : -802
Arithmetic overflow or division by zero has occurred.
Engine Code: 335544321
Engi
Test with
select
...
from
tableA t
where
t. || :NameFile1 || like %'' || :keyword1 || %'' or t. || :NameFile2 || like
%'' || :keyword || %''
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: nathanelrick
To: firebird-support@yahoogroups.com
Sent: Fri
My responding:
ShellExecute 0, vbNullString, App.Path & "gbak -v -user -password xxx
IP/Port:"Database" "Bakup", App.Path, vbMinimizeNoFocus
Forgive for the question
=
|| ISMAEL ||
=
- Original Message -----
From: Ismael L. Donis G
As could database backup from application Visual Basic 6?
I use firebird 2.5.1 SuperClasic
Best Regards
=
|| ISMAEL ||
=
[Non-text portions of this message have been removed]
Install FirebirdCS-2.5.1.26351-0.amd64.tar.gz
Download it from the official place.
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Aldo Caruso
To: firebird-support@yahoogroups.com
Sent: Saturday, February 25, 2012 12:48 PM
Subject: Re: [firebird-suppo
Can some problem exist when creating 2 indexes of the same records?
CREATE UNIQUE INDEX FK_SCEMMES_A ON SCEMMES (IDAC,IDREG,NUMC);
CREATE UNIQUE DESCENDING INDEX FK_SCEMMES_D ON SCEMMES (IDAC,IDREG,NUMC);
I make it because I need values max
select max(m.numc) as numc from scemmes m where ((m.ida
Linux not.
Best Regards
=
|| ISMAEL ||
=
> - Original Message -
> From: "Michael Hieke"
> To:
> Sent: Monday, January 23, 2012 3:38 PM
> Subject: Re: [Flamerobin-devel] flamerobin 0.9.4 release
> Am 30.09.2011 20:15, schrieb Ismael L. Donis Ga
What differences there is between WIN1252 and ISO8859_1?
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Milan Babuskov
To: firebird-support@yahoogroups.com
Sent: Tuesday, January 10, 2012 5:07 AM
Subject: Re: [firebird-support] UTF8 in firebird ?
: Best raid configuration
Hi,
Someone in this forum said that raid 5 is bad for firebird server.
Regards,
Sugiarto
--- In firebird-support@yahoogroups.com, "Ismael L. Donis Garcia"
wrote:
>
> For my understanding I raid 5 or raid 0
>
For my understanding I raid 5 or raid 0
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Vander Clock Stephane
To: firebird-support@yahoogroups.com
Sent: Monday, December 26, 2011 12:37 PM
Subject: [firebird-support] Best raid configuration
Hello,
i need to set
In Visual C# 2005 (I think that in 2010 it be similar), adding reference to
FirebirdClient - ADO.NET 2.6.5 Data Provider
adding in the code of the form: using FirebirdSql.Data.FirebirdClient;
adding a DataGridView in the form with name data
later on the event Form_Load adding:
string connectionStr
In the trigger:
if (new.myfield is null) then
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Tetram Corp
To: firebird-support@yahoogroups.com
Sent: Thursday, November 03, 2011 1:04 PM
Subject: [firebird-support] Detecting default values
Hi,
SELECT *
FROM MON$ATTACHMENTS c WHERE c.MON$ATTACHMENT_ID <> CURRENT_CONNECTION
if row_count > 0 exists other user connect
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: jacobhavkrog
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 19, 201
tarball?
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ismael L. Donis
Garcia
Sent: Wednesday, October 19, 2011 12:15 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Debian install
I have always used the
I do not believe that that way be able to
You should make a stored procedure with:
SELECT 1 FROM T1 WHERE name = :imput_parameter
if (row_count = 0) then
INSERT INTO T1 (type, name, sysid, flag) values (1, :imput_parameter, 1, 0);
Best Regards
=
|| ISMAEL ||
=
- Original Me
||
=
- Original Message -
From: Tomasz Tyrakowski
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 19, 2011 12:26 PM
Subject: Re: [firebird-support] Firebird Program loses network connection
On 2011-10-19 15:22, Ismael L. Donis Garcia wrote:
> For me you sho
I have always used the packet taken down from the official place of firebird
without a hitch.
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: Rick Debay
To: firebird-support@yahoogroups.com
Sent: Wednesday, October 19, 2011 9:52 AM
Subject: [firebird-
For me you should check the logic of the program because that is long time for
a transaction.
try try
Transaction.StartTransaction;
Query.ExecSQL;
Transaction.Commit;
except on e:exception do
begin
.
Transaction.Rollback;
end;
end;
finally
Tra
- Original Message -
From: Thomas Steinmaurer
To: firebird-support@yahoogroups.com
Sent: Friday, October 14, 2011 12:40 PM
Subject: Re: [firebird-support] SS in Windows2008 x64
>> I have 1 server with Windows2008 x64 with 2 nucleuses of 4 CPU each one.
>>
>> As could configure the pr
I have 1 server with Windows2008 x64 with 2 nucleuses of 4 CPU each one.
As could configure the property CpuAffinityMask in a superserver 2.5.1 in
order that the 2 nucleuses work with the bigger possible number of CPU?
Best Regards
=
|| ISMAEL ||
=
"DRIVER=Firebird/InterBase(r) driver; UID=SYSDBA; PWD=masterke;
DBNAME=LocalHost:C:\VSO3\Utilities\FBUpdater\VSO3.fdb;
CHARACTERSET=CHARACTERSET_USED; DIALECT=DIALECT_USED;"
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: venussoftop
To: firebird-support@
Recently I installed the version 0.9.3.2188 of flamerobin and when I try to
create a trigger give me the following error. As much in Windows like in debian
squeeze.
In Windows -> Template "C:\Archivos de
Programa\FlameRobin\sys-templates\create_trigger.template" not found.
In Debian Squeeze ->
SELECT p.* FROM procedure_name(imput parameters, .) p
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: firebirdsql
To: firebird-support@yahoogroups.com
Sent: Saturday, September 17, 2011 1:35 PM
Subject: [firebird-support] execute stored procedure f
You could not substitute the consultation for:
select * from fond where typ=:typ and tridnaz like :text || '%' order by
tridnaz;
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: ma_golyo
To: firebird-support@yahoogroups.com
Sent: Thursday, September 08
At no time I have said that you should put it everything into 1 table, it is
absurd. You should analyze the design of her database.
Without knowing the design of the tables and the data that you need to obtain
cannot give a great help.
Best Regards
=
|| ISMAEL ||
=
- Origi
The question of million
If you do not know linux I recommend you ubunto
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: W O
To: firebird-support@yahoogroups.com
Sent: Monday, August 15, 2011 1:15 PM
Subject: [firebird-support] Which distribution Linux
: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing
On 11/08/11 16:27, Ismael L. Donis Garcia wrote:
> The join you should always avoid them,
> ...
> this not only you should apply it in firebird
> but in all the systems of SQL that you use.
I'm not sure
For my whole the problem that you have, is that you have a bad design in your
database.
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: red_october2009
To: firebird-support@yahoogroups.com
Sent: Thursday, August 11, 2011 11:31 AM
Subject: [firebird-su
The join you should always avoid them, if and when it is possible to use
filters where instead of join and besides you should try than the ones join
that you use use them with numerical fields since this comes for the way of
bringing about this instruction, this not only you should apply it in f
AM, Ismael L. Donis Garcia <
ism...@citricos.co.cu> wrote:
> I accomplish the following (I no if it will be OK )
>
> SET TERM ^ ;
> CREATE PROCEDURE P_NUM_REC (
> VCH_ENTIDAD VARCHAR(7),
> SIN_ALMACEN SMALLINT )
> RETURNS (
> INT_NREC INTEGER )
&g
I accomplish the following (I no if it will be OK )
SET TERM ^ ;
CREATE PROCEDURE P_NUM_REC (
VCH_ENTIDAD VARCHAR(7),
SIN_ALMACEN SMALLINT )
RETURNS (
INT_NREC INTEGER )
AS
BEGIN
/* Update the number of the reception */
select a.no_r from vtaconteo a where ((a.entidad = :vch_entida
78 matches
Mail list logo