Re: [firebird-support] Duplicate entries ...

[Ismael L. Donis Garcia]

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_entidad) and 
(a.almacen = :sin_almacen)) into :int_nrec;
  update vtaconteo set no_r = no_r + 1 where ((vtaconteo.entidad = 
:vch_entidad) and (vtaconteo.almacen = :sin_almacen));
  suspend;
END^
SET TERM ; ^

Regards
=
|| ISMAEL ||
=
  - Original Message - 
  From: Woody 
  To: firebird-support@yahoogroups.com 
  Sent: Friday, August 05, 2011 10:31 AM
  Subject: Re: [firebird-support] Duplicate entries ...



  From: "Lester Caine" 

  > I had a bit of trouble on a site yesterday which I'm not sure I understand 
  > ...
  >
  > The raw data is basically two tables, one with an entry using a generator 
  > value
  > key, and the second 'detail table' has a primary key of the same generator 
  > value
  > + a transact_no. The detail table is populated by a trigger on the master 
  > table,
  > when one field changes, the current state is stored in detail, and the 
  > master
  > entries updated. The trigger is just using a MAX+1 for the transact_no, 
  > and has
  > the primary key unique index, but in theory a user will be take several 
  > seconds
  > between each action on an individual ticket, and the times confirm that.
  >

  Generally, the second one to post and commit should get an error if the 
  primary key is duplicated. However, barring that, when I need something like 
  this I write a specific routine to insert a new record in an isolated 
  transaction so it can be posted and committed right away. It would then 
  return the transact_no, in your case, to the calling routine which would 
  just position itself to the new item. If an error occurs, it could return a 
  negative error code indicating what caused it or a generic -1 to indicate 
  failure.

  I do the same thing on a larger scale for table ID's where they need to be 
  in sequence. I usually create an ID table with 2 fields (ID_Type, Next_ID). 
  I use a separate transaction to read and set the next ID for whatever I 
  need. Mainly this is needed when an ID is required when creating a new 
  record for display, like a new work order, as opposed to an underlying, 
  non-useful ID where a generator can be used.

  I think you've been lucky up until now not running into any problems with 
  the way you're doing it now. I have dealt with people who leave for lunch or 
  even for the day without closing a form and saving information right away so 
  I try to make it as non-interfering as possible so it doesn't cause others 
  to have problems. It doesn't always work but it gets close. :-)

  HTH
  Woody 



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Duplicate entries ...

[Ismael L. Donis Garcia]

Although using superserver?

Regards
=
|| ISMAEL ||
=
  - Original Message - 
  From: Ann Harrison 
  To: firebird-support@yahoogroups.com 
  Sent: Friday, August 05, 2011 1:47 PM
  Subject: Re: [firebird-support] Duplicate entries ...



  On Fri, Aug 5, 2011 at 11:11 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 )
  > AS
  > BEGIN
  > /* Update the number of the reception */
  > select a.no_r from vtaconteo a where ((a.entidad = :vch_entidad) and
  > (a.almacen = :sin_almacen)) into :int_nrec;
  > update vtaconteo set no_r = no_r + 1 where ((vtaconteo.entidad =
  > :vch_entidad) and (vtaconteo.almacen = :sin_almacen));
  > suspend;
  > END^
  > SET TERM ; ^
  >

  It will get update conflicts and serialize whatever operations you're doing.
  If you don't mind unnecessarily serializing inserts and dealing with update
  conflicts, wonderful. Why not use a generator and the returning clause?

  Ann

  [Non-text portions of this message have been removed]



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing

[Ismael L. Donis Garcia]

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 firebird 
but in all the systems of SQL that you use.

Regards
=
|| ISMAEL ||
=
  - Original Message - 
  From: red_october2009 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, August 11, 2011 10:47 AM
  Subject: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing



  Hi Svein,

  Here is the PLAN that goes with that SQL. I should have included it in the 
first message.

  PLAN SORT (SORT (JOIN (S INDEX (IDX_JET_SAV_PNT5), L INDEX 
(IDX_JET_CHG_LOG3), F INDEX (UNQ_JET_FLD_NMS_2), T INDEX (UNQ_JET_TBL_NMS_1

  When I execute this the first time, it takes 9 seconds. I think the 6 second 
saving was only because I was re-executing it and FB kept a cache or something 
that helped out the subsequent executions.

  The 2 SORTs at the begining are probably what's killing my timings. Should I 
add an index some where to get rid of them?

  Thanks in advance for any help you can provide. This is the only remaining 
"slow point" in my application. (After 10 months of programming)



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing

[Ismael L. Donis Garcia]

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-support] Re: Stumped on SQL Indexing/Bad Plan-ing



  Here is some further info:

  I have been experimenting by eliminating JOINed tables, and fields that pull 
from tables in the JOIN.

  If I pull back only fields from s then the execution time is fast. As I add 
VARCHAR() fields from the JOINed tables, execution slows, but is still 
acceptable (< 2 seconds).

  However when I add BLOB SUB_TYPE 1 fields from the JOINed tables, it kills 
the response time... up to 9 seconds.

  Pulling back BLOB fields seems to be the hold up. However, I need those 
fields. Is there a way to make the blob fields in the query not so damaging to 
response time?



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing

[Ismael L. Donis Garcia]

If, if and when it is possible. What I say is that they should come true on 
numerical fields and avoiding more of 1 for table, this is possible with a good 
design of the database.

I carry a lot of years (more of 16) accomplishing base designings of data and I 
have it more than proven. And of something he can be sure and it is that I do 
not violate the rules of integrity and normalization.

Best Regards
=
|| ISMAEL ||
=
  - Original Message - 
  From: Norman Dunbar 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, August 11, 2011 11:50 AM
  Subject: Re: [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 I follow what you are saying, avoid joins? In a relational 
  database?

  Relational databases are built to perform joins, that's basically the 
  point, you design the database, normalising your data into separate 
  entities (which become tables) and when you run a query, you join these 
  various tables back together as required for that particular query.

  Some data warehouse systems do advocate de-normalisation, but that's 
  different from normal running of an RDBMS. (Plus, denormalisation has 
  been proven to reduce response times.)

  Of course, I might have misunderstood your original posting. In which 
  case, apologies.

  Cheers,
  Norm.

  -- 
  Norman Dunbar
  Dunbar IT Consultants Ltd

  Registered address:
  Thorpe House
  61 Richardshaw Lane
  Pudsey
  West Yorkshire
  United Kingdom
  LS28 7EL

  Company Number: 05132767


  

[Non-text portions of this message have been removed]

Re: [firebird-support] Which distribution Linux is best for use with Firebird?

[Ismael L. Donis Garcia]

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 is best for use with 
Firebird?



  Hello everybody

  For security reasons we want to save the databases in a partition with the
  Linux OS on them.

  That partition will be just for keep the databases, nothing more.

  We don't know Linux, but can learn the basics, if neccesary.

  Which distribution of Linux would be the best for that case?

  Thanks in advance.

  Walter.

  [Non-text portions of this message have been removed]



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing

[Ismael L. Donis Garcia]

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 ||
=
  - Original Message - 
  From: red_october2009 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, August 18, 2011 12:56 PM
  Subject: [firebird-support] Re: Stumped on SQL Indexing/Bad Plan-ing



  Just to close off this case, the final SQL that SET was looking at is 
"slow-ish" because it has to make at least 2 hits to the DB (maybe even 4?) 
because at least 2 of the fields are BLOB SUB_TYPE 1 fields, which I have 
learned require multiple hits to the DB. Without those fields included in the 
field list, the query is < 1s.

  I need to include those fields and the slower response time is tolerable if I 
explain it to my customer.

  -- Side note --

  During my 22 years of experience, I have had excellent response times ( < 1s) 
on all properly made queries, using multiple tables and JOINs of various kinds, 
on both/either VARCHAR() AND INTEGER fields, in any/all the major RDBMSs.

  To stuff everything in 1 table defeats the purpose of using an RDBMS. It's 
not "wrong", but, just not what RDBMS was intended for. 



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Re: Problem with compound index

[Ismael L. Donis Garcia]

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, 2011 1:57 AM
  Subject: [firebird-support] Re: Problem with compound index



  Hi!

  I found this also and reported it. This is a known bug :
  http://tracker.firebirdsql.org/browse/CORE-3052

  Unfortunatley still not fixed and no sign of doing it... :(

  --- In firebird-support@yahoogroups.com, "tomkrej"  wrote:
  >
  > Hi all, I have interesting problem with compound index.
  > 
  > I have records in one table divided in a groups by field TYP
  > and each record has its name field TRIDNAZ
  > 
  > TRIDNAZ is varchar(40) character set WIN1250 collation PXW_CSY
  > TYP is smallint
  > 
  > I had 2 indexes - on TRIDNAZ only, and on TYP, TRIDNAZ
  > 
  > And I have query 
  > 
  > select * from FOND where TYP = :typ and TRIDNAZ starting with :text order 
by TRIDNAZ;
  > 
  > when I set text = 'C' the result set was empty
  > when I set text = 'CA' the result set was filled with records starting with 
'CA' 
  > 
  > I can't found the reason why was 'C' empty.
  > 
  > I saw the plan and the server use compound index - TYP, TRIDNAZ
  > 
  > When I dropped it, server us TRIDNAZ only index and - wow - 'C' records 
exists.
  > 
  > I think there is some foult in compound index smallint + varchar(WIN1250) 
and characte C
  > It could be the reason that in Czech languague is 'Ch' one character not 
two.
  > 
  > When I change it to two separate indexes - TYP and TRIDNAZ
  > Server use both of them and works correctly.
  > 
  > Please correct this error - it is tested on 2.1 and 2.5 on windows
  > 
  > Tom
  >



  

[Non-text portions of this message have been removed]

Re: [firebird-support] execute stored procedure for select?

[Ismael L. Donis Garcia]

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 for select?



  How would I do this?
  EXECUTE PROCEDURE procedure (col1)
  SELECT col1 FROM test;



  

[Non-text portions of this message have been removed]

[firebird-support] Error in Flamerobin 0.9.3.2188

[Ismael L. Donis Garcia]

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 -> Template 
"/usr/share/flamerobin/sys-templates/create_trigger.template" not found.

Besides, In the version of Linux he does not show me the description of the 
exceptions that have an accentuated letter.

Best Regards
=
|| ISMAEL ||
=


[Non-text portions of this message have been removed]

Re: [firebird-support] Can no longer open database using connecstring but can from FlameRobin

[Ismael L. Donis Garcia]

"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@yahoogroups.com 
  Sent: Friday, September 23, 2011 9:49 AM
  Subject: [firebird-support] Can no longer open database using connecstring 
but can from FlameRobin



  Hi all

  Not sure what the problem is but all of a sudden in one application the FDB 
will not get connected when using a connectstring as below
  Driver={Firebird/InterBase(r) 
driver};Uid=SYSDBA;Pwd=masterkey;DbName=C:\VSO3\Utilities\FBUpdater\VSO3.fdb;

  This connectstring use to worked before now does not. This same FDB will open 
fine in FlameRobin.

  I am sure I am missing something all of a sudden because this is happening on 
2 computers but the third is working fine using the same connectstring. Other 
applications using same connectstring (except database path) are working fine 
on this same computer that is not connecting.

  Hope I was able to explain. Please advise.

  Thanks and regards
  Bhavbhuti



  

[Non-text portions of this message have been removed]

[firebird-support] SS in Windows2008 x64

[Ismael L. Donis Garcia]

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 ||
= 

Re: [firebird-support] SS in Windows2008 x64

[Ismael L. Donis Garcia]

- 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 property CpuAffinityMask in a superserver 2.5.1 in
>> order that the 2 nucleuses work with the bigger possible number of CPU?

>How many databases do you host on that server? Because with SuperServer 
>only one core per database can be used.

>Why aren't you using e.g. SuperClassic (or Classic) as it is more 
>SMP-friendly?

>With regards,
>Thomas Steinmaurer

I have 8 datababase.

Because until now I always have used SS, before I had 1 little server, now is 
that I can improve it.

Best Regards
=
|| ISMAEL ||
=


[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird Program loses network connection

[Ismael L. Donis Garcia]

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
Transaction.EndTransaction;
  end;

This should delay fractions of a second.

Best Regards
=
|| ISMAEL ||
=
  - Original Message - 
  From: Norman Dunbar 
  To: firebird-support@yahoogroups.com 
  Sent: Wednesday, October 19, 2011 3:27 AM
  Subject: Re: [firebird-support] Firebird Program loses network connection



  Morning all,

  > I have encountered a weird network problem and have no idea what might be 
the cause of it.
  As far as I'm concerned, all network problems are weird! ;-)

  > ...
  > Client connection path to the database is using TCP/IP
  > Situation: Client's program frequently shows
  > Error writing data to the connection
  > An existing connection was forcibly closed by the remote host
  That sounds to me as if the server end is killing the connection as 
  opposed to the connection being "lost" due to nnetwork problems or the 
  client end failing for some reason.

  > Client stated it happened after using the program for some time.
  > As testing, I tried saving couple of big transaction on the client computer 
and will encountered the same error. Note: Processing time for the transaction 
takes less then 3 mins.
  Is the transaction doing something CPU intensive, for example a huge 
  sort? If so, it's possible that there is no keep-alive on the network 
  and some configuration option on the server is killing off "dead" 
  connections.

  This is something I get occasionally with my Oracle database servers at 
  work. They are configured (and I know not how!) to drop dead connections 
  after a certain time. When the clients submits a huge CPU intensive 
  transaction, it runs and then because there's no network traffic, the 
  server assumes the connection has died and drops it.

  When the application tries to talk again to the server, it gets the 
  message that you are seeing - force closed by remote host.

  > ...

  > Testing on network so far shows it is stable.
  Probbaly because there is plenty of traffic during the test. You need to 
  have a connection initiate with the server and then, do nothing. 
  Possibly an SSH to the server could be made and then simply left alone 
  to see if it too dies? Of course, you need to try to get a response from 
  the server in order to know if it has died or not which means that you 
  have effectively reset the aliveness of the connection.

  > Perform test by pinging the server and then transferring file to the server 
while the program is running. Will get the same error above but ping and file 
transfer continue without hiccup.
  I think, but I'm not a network guru, that ping uses UDP which is not TCP.

  > Perform another test by having two program open. Only the program running 
the test above will crashed with error and the second program can continue 
being used without any problem.
  Do both programs run the same large transaction? What happens if both 
  do? I predict both will lose the connection. Also, when the client is 
  running the large transaction, what does Task Manager show for the 
  client app - I suspect Not Responding, but I might be wrong.

  And also, while the transaction is running, check the network traffic 
  (start->settings->Network and Dialup connections, double click on LAN 
  and see what's happening) - are you seeing sent/received clocking up 
  packet counts while the transaction is running - at the same rate as 
  before the transaction? Obviously there will be background traffic - 
  your email, other stuff, but you might get a clue. Maybe!

  > ...

  > Also suspected something is not right with the program but running the same 
test at my own office with lower end computer and much heavier transaction will 
not have any problem. I pretty much given up and not sure what so unique about 
this client network that keep getting this error.
  As I said, I'm not a network guru, but it does sound familiar. I suspect 
  that the server has been configured, somehow, to kill off dead 
  connections and your long running transaction is thought to be dead.

  When you did your test on the low spec machine, were you running exactly 
  the same transaction or a different one? Anything that talks across the 
  network while running is going to stay alive, anything that hits the 
  server for a long period of CPU, for example, is possibly going to be 
  dropped.

  I reapet, I'm not a network guru and I'm sure others will jump in and 
  assist you here, but the above may be worth considering.

  And finally, the following sage advice comes from the firebird.conf file:

  # Normally, Firebird uses SO_KEEPALIVE socket option to keep track of
  # active connections. If you do not 

Re: [firebird-support] Debian install

[Ismael L. Donis Garcia]

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-support] Debian install



  I'm running Debian 6.0 (squeeze) which has a package for FB 2.5.0. FB
  2.5.1, is only available for Debian sid (unstable).
  Is there any way to get FB 2.5.1 for a production system using Debian
  package management? Or must I install it using the packages from
  Firebird?

  Disclaimer: This message (including attachments) is confidential and may be 
privileged. If you have received it by mistake please notify the sender by 
return e-mail and delete this message from your system. Any unauthorized use or 
dissemination of this message in whole or in part is strictly prohibited. 
Please note that e-mails are susceptible to change. RxStrategies, Inc. shall 
not be liable for the improper or incomplete transmission of the information 
contained in this communication or for any delay in its receipt or damage to 
your system. RxStrategies, Inc. does not guarantee that the integrity of this 
communication has been maintained nor that this communication is free from 
viruses, interceptions or interference. 



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird Program loses network connection

[Ismael L. Donis Garcia]

No, I that is not the cause of the problem, but for my understanding 1 single 
transaction should not take so long, simply he should try to separate the 
transactions for self-actions and with it I believe that they avoid several 
types of problems.

Best Regards
=
|| ISMAEL ||
=
  - 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 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
  > Transaction.EndTransaction;
  > end;
  >
  > This should delay fractions of a second.

  Hmm... where do you draw this conclusion from? In my opinion, your 
  Query.ExecSQL can take an unspecified amount of time, depending on what 
  the actual query does. I've got a couple of apps, which execute stored 
  procedures in FB database (which in turn end up generating some hundreds 
  of thousands of new records) via EXECUTE PROCEDURE statements, which 
  take a good couple of minutes to complete. Of course there are worker 
  threads on the client side and such, but the client connection is 
  blocked until a procedure returns. So I wouldn't be so haste to blame 
  the client code.

  regards
  Tomasz

  >
  > Best Regards
  > =
  > || ISMAEL ||
  > =
  > - Original Message -
  > From: Norman Dunbar
  > To: firebird-support@yahoogroups.com
  > Sent: Wednesday, October 19, 2011 3:27 AM
  > Subject: Re: [firebird-support] Firebird Program loses network connection
  >
  >
  >
  > Morning all,
  >
  > > I have encountered a weird network problem and have no idea what might be 
the cause of it.
  > As far as I'm concerned, all network problems are weird! ;-)
  >
  > > ...
  > > Client connection path to the database is using TCP/IP
  > > Situation: Client's program frequently shows
  > > Error writing data to the connection
  > > An existing connection was forcibly closed by the remote host
  > That sounds to me as if the server end is killing the connection as
  > opposed to the connection being "lost" due to nnetwork problems or the
  > client end failing for some reason.
  >
  > > Client stated it happened after using the program for some time.
  > > As testing, I tried saving couple of big transaction on the client 
computer and will encountered the same error. Note: Processing time for the 
transaction takes less then 3 mins.
  > Is the transaction doing something CPU intensive, for example a huge
  > sort? If so, it's possible that there is no keep-alive on the network
  > and some configuration option on the server is killing off "dead"
  > connections.
  >
  > This is something I get occasionally with my Oracle database servers at
  > work. They are configured (and I know not how!) to drop dead connections
  > after a certain time. When the clients submits a huge CPU intensive
  > transaction, it runs and then because there's no network traffic, the
  > server assumes the connection has died and drops it.
  >
  > When the application tries to talk again to the server, it gets the
  > message that you are seeing - force closed by remote host.
  >
  > > ...
  >
  > > Testing on network so far shows it is stable.
  > Probbaly because there is plenty of traffic during the test. You need to
  > have a connection initiate with the server and then, do nothing.
  > Possibly an SSH to the server could be made and then simply left alone
  > to see if it too dies? Of course, you need to try to get a response from
  > the server in order to know if it has died or not which means that you
  > have effectively reset the aliveness of the connection.
  >
  > > Perform test by pinging the server and then transferring file to the 
server while the program is running. Will get the same error above but ping and 
file transfer continue without hiccup.
  > I think, but I'm not a network guru, that ping uses UDP which is not TCP.
  >
  > > Perform another test by having two program open. Only the program running 
the test above will crashed with error and the second program can continue 
being used without any problem.
  > Do both programs run the same large transaction? What happens if both
  > do? I predict both will lose the connection. Also, when the client is
  > running the large transaction, what does Task Manager show

Re: [firebird-support] Re: How to insert only if a matching row does not exist?

[Ismael L. Donis Garcia]

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 Message - 
  From: gastrocus 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, October 20, 2011 12:28 PM
  Subject: [firebird-support] Re: How to insert only if a matching row does not 
exist?





  --- In firebird-support@yahoogroups.com, Helen Borrie  wrote:
  >
  > >What is the analogous way to achieve this in Firebird (2.5) ?
  > 
  > INSERT INTO emp (fruits) values ('mango')
  > where not exists (select 1 from emp where fruits = 'mango')

  Thanks for the quick reply.

  Strange... when I try to do this (via flamerobin or ibexpert) it does not 
recognize the "Where" token (Dynamic SQL error -104, Token unknown, where ). 
Must be something simple :(

  Here is what I am trying:

  I have a table like the following:
  CREATE TABLE T1 (
  ID INTEGER NOT NULL,
  TYPE INTEGER,
  NAME VARCHAR(128),
  SYSID INTEGER,
  FLAG INTEGER
  );

  ID has a generator so I don't want to insert a value for it.

  Here is the query I tried

  INSERT INTO T1 (type, name, sysid, flag) values (1, 'Z', 1, 0)
  WHERE NOT EXISTS (SELECT 1 FROM T1 WHERE name = 'Z')

  It 
  > 
  > Look up INSERT OR UPDATE and also MERGE in the Language Reference Update. 
One or both might do what you want, more efficiently than NOT EXISTS. Not 
enough info here to guess what you're really going to do with it.
  > 

  My application is really to write a script that will be run once on a 
smallish dataset (on the order of 1000 rows) so performance isn't really a big 
deal.

  Thanks for the pointer. I did look at INSERT OR UPDATE prior to posting but I 
do not want to UPDATE if there is a match so I didn't think this applied.



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Debian install

[Ismael L. Donis Garcia]

The .tar.gz

Best Regards
=
|| ISMAEL ||
=

- Original Message - 
From: Rick Debay
To: firebird-support@yahoogroups.com
Sent: Friday, October 21, 2011 10:27 AM
Subject: RE: [firebird-support] Debian install



Do you use Alien to install the RPM package, or unzip the 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 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-support] Debian install

I'm running Debian 6.0 (squeeze) which has a package for FB 2.5.0. FB
2.5.1, is only available for Debian sid (unstable).
Is there any way to get FB 2.5.1 for a production system using Debian
package management? Or must I install it using the packages from
Firebird?

Disclaimer: This message (including attachments) is confidential and may be 
privileged. If you have received it by mistake please notify the sender by 
return e-mail and delete this message from your system. Any unauthorized use 
or dissemination of this message in whole or in part is strictly prohibited. 
Please note that e-mails are susceptible to change. RxStrategies, Inc. shall 
not be liable for the improper or incomplete transmission of the information 
contained in this communication or for any delay in its receipt or damage to 
your system. RxStrategies, Inc. does not guarantee that the integrity of 
this communication has been maintained nor that this communication is free 
from viruses, interceptions or interference.


 

Re: [firebird-support] Programatically detect shutdown state of database? IBOAdmin?

[Ismael L. Donis Garcia]

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, 2011 11:16 AM
  Subject: [firebird-support] Programatically detect shutdown state of 
database? IBOAdmin?



  Hi - 

  How can I from my Delphi application detect the shutdown state (normal/multi 
user maintenance/single user maintenance/full) of a database?

  Like what the gstat command line tool can tell me.

  I need it for a remote database too.

  IBOAdmin can be used to do shut down a database and bring it back online, but 
can it also tell me the current state? 

  I want to do a programmatic restore, so I want to shut down the database 
before using gbak. But I cant find a way to make sure that a shut down has 
completed sucessfully..

  Thanks
  Jacob



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Detecting default values

[Ismael L. Donis Garcia]

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,

  I have a table with a field for which i need a default value. My problem 
  is the default value can change at any time. So the solution I found is 
  to use a "before insert" trigger.

  But now, i'm facing a new challenge: how to detect if the null status I 
  received in new.myfield is because the field was not in the insert 
  statement or because the insert statement set it to null ?

  well, from
  insert into mytable (field1) values (:field1)
  or from
  insert into mytable (field1, myfield) values (:field1, null)


  

[Non-text portions of this message have been removed]

Re: [firebird-support] connect to FB using visual basic 2010

[Ismael L. Donis Garcia]

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 connectionString = 
"User=SYSDBA;" +
"Password=masterkey;" +
"Database=D:\data\Tests.fdb;" +
"DataSource=localhost;" +
"Port=3050;" +
"Dialect=3;" +
"Charset=NONE;" +
"Role=;" +
"Connection lifetime=15;" +
"Pooling=true;" +
"MinPoolSize=0;" +
"MaxPoolSize=50;" +
"Packet Size=8192;" +
"ServerType=0";
FbConnection conexion = new FbConnection(connectionString);
try
{
// Open two connections.
conexion.Open();
DataTable dt = new DataTable();
FbDataAdapter da = new FbDataAdapter("SELECT * FROM PERSONAS", conexion);
da.Fill(dt);
data.DataSource = dt;
conexion.Close();}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
finally
{
conexion.Dispose();
}


Best Regards
=
|| ISMAEL ||
=
  - Original Message - 
  From: zacwingfield 
  To: firebird-support@yahoogroups.com 
  Sent: Wednesday, December 07, 2011 1:02 PM
  Subject: [firebird-support] connect to FB using visual basic 2010



  hi, can anyone point me to a good tuitorial on how to connect to firebird 
from VB 2010

  many thanks
  zac



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Best raid configuration

[Ismael L. Donis Garcia]

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 setup a new fb server with 7 sas hard drive
With best configuration i can choose ? raid 0, raid 5, raid 6? etc ...

thanks by advance
stéphane

Re: [firebird-support] Re: Best raid configuration

[Ismael L. Donis Garcia]

I have had never no type of problem. The one that is not recommended is the 
raid 10.

Best Regards
=
|| ISMAEL ||
=
  - Original Message - 
  From: trskopo 
  To: firebird-support@yahoogroups.com 
  Sent: Monday, December 26, 2011 9:30 PM
  Subject: [firebird-support] Re: 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
  > 
  > 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 setup a new fb server with 7 sas hard drive
  > With best configuration i can choose ? raid 0, raid 5, raid 6? etc ...
  > 
  > thanks by advance
  > stéphane
  >



  

[Non-text portions of this message have been removed]

Re: [firebird-support] UTF8 in firebird ?

[Ismael L. Donis Garcia]

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 ?



  Vander Clock Stephane wrote:
  > let speak first about the utf8
  > UTF8 it's just a way to encode special character like è à etc ..
  > for this utf8 will use combination of char upper than ascii #127
  > In this way, and it's not the less, UTF8 stay compatible with all
  > software that work with 8 bit string. thank to this we can use
  > a firebird database defined as iso8859_1 to store UTF8

  That is not true.

  Some characters have different code points, for example British Pound 
  symbol, Japanese Yen symbol, Copyright (c) symbol, etc.

  UTF8 is 100% compatible with ASCII, which is not the same as iso8859_1.

  -- 
  Milan Babuskov

  ==
  The easiest way to import XML, CSV
  and textual files into Firebird:
  http://www.guacosoft.com/xmlwizard
  ==



  

[Non-text portions of this message have been removed]

[firebird-support] [OT] flamerobin 0.9.4 release

[Ismael L. Donis Garcia]

Excuse all for OT.

Will somebody be able to tell me if the answer of Michael Hieke is possible?

I don't understand. Then because is seen in Windows with ISO8859_1?
The same database if I open it with Flamerobin from Windows I see the 
descriptions of the exceptions and if I open it from 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 Garcia:

>> In Debian not shows the descriptions of the exceptions when these have
>> accentuated letters with character set ISO8859_1.


> I don't think anything can be done about this.  The problem squarely
> lies with Firebird, because the system table for exceptions
> RDB$EXCEPTIONS has the field RDB$EXCEPTION_NAME using the charset
> UNICDOE_FSS and the field RDB$MESSAGE using the charset NONE.

> The result of this is that exception message texts only work correctly
> if they don't contain any ASCII characters, or when the connection
> charset is the same as it was when the exception was created (or a
> different one with the same encoding of the characters in question).

> This can easily be checked in Windows too.  Connect to a database with
> charset UTF-8 and create an exception:

>CREATE EXCEPTION "äöü" 'Test message ÄÖÜ ß';

> Then disconnect and reconnect with the connection charset set to for
> example WIN1252 or ISO8859_1.  Browse the RDB$EXCEPTIONS table and you
> will see that the name is shown correctly while the message is not.

> Since it is impossible to say which connection charset was used when the
> exception was created (and since it is in a charset NONE column) there
> is no way for FlameRobin to do the correct charset conversion.

> Thanks

> Michael Hieke 

[firebird-support] creating 2 indexes of the same records

[Ismael L. Donis Garcia]

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.idac=1) and (m.idreg=1))


Best Regards
=
|| ISMAEL ||
=

[Non-text portions of this message have been removed]

Re: [firebird-support] String right truncation Error

[Ismael L. Donis Garcia]

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-support] String right truncation Error



  I'm running Firebird 2.5.0 on Linux Debian 64 bits
  Sever version:
  LI-V2.5.0.26054 Firebird 2.5 Release Candidate 3

  Aldo

  El 25/02/12 13:25, Mark Rotteveel escribió:
  >
  > On 25-2-2012 16:26, Aldo Caruso wrote:
  > > I did the three tests you mention and the error persists in Firebird 2.5
  > > ( and it does not exists neither in 2.0 version nor in 2.1 version )
  > > More, I recreated the error with brand new tables and view, so anybody
  > > can recreate it and verify.
  >
  > It works fine for me on Firebird 2.5.1 on Windows 7 x64:
  > ---
  > Server Version
  > ---
  > WI-V2.5.1.26351 Firebird 2.5
  > ---
  > OK
  > ---
  >
  > Browsing the tracker gives me:
  > http://tracker.firebirdsql.org/browse/CORE-3211
  >
  > Which was indeed solved in 2.5.1
  >
  > Mark
  > -- 
  > Mark Rotteveel
  >
  > 

  [Non-text portions of this message have been removed]



  

[Non-text portions of this message have been removed]

[firebird-support] OT: Backup from Visual Basic

[Ismael L. Donis Garcia]

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]

[firebird-support] Re: Backup from Visual Basic

[Ismael L. Donis Garcia]

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 Garcia 
  To: Firebird Support 
  Sent: Monday, March 19, 2012 2:46 PM
  Subject: OT: Backup from Visual Basic


  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]

Re: [firebird-support] How to do a full text search ?

[Ismael L. Donis Garcia]

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: Friday, March 23, 2012 10:12 AM
  Subject: [firebird-support] How to do a full text search ?



  Hello,

  We have a table where user can do classic search against different field

  select 
  ... 
  from 
  tableA 
  where 
  field1>n and 
  field2=i;

  now i want to permit user to also filter by keyword
  something like

  select 
  ...
  from 
  tableA 
  where 
  field1>n and 
  field2=i and 
  (FieldVarcharDescr like '%Keyword1%' or FieldVarcharDescr like '%Keyword2%')

  How to do this ?



  

[Non-text portions of this message have been removed]

[firebird-support] Arithmetic overflow or division by zero has occurred.

[Ismael L. Donis Garcia]

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
Engine Message :
arithmetic exception, numeric overflow, or string truncation
numeric value is out of rang



As I can solve this problem without decreasing the number of decimal?

Best Regards
=
|| ISMAEL ||
=

[Non-text portions of this message have been removed]

Re: [firebird-support] Arithmetic overflow or division by zero has occurred.

[Ismael L. Donis Garcia]

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 ||
=
  - Original Message - 
  From: Svein Erling Tysvær 
  To: 'firebird-support@yahoogroups.com' 
  Sent: Thursday, March 29, 2012 3:24 AM
  Subject: RE: [firebird-support] Arithmetic overflow or division by zero has 
occurred.



  >SELECT cast((5411.000455/0.20) as numeric(16,6)) as mount FROM 
MON$ATTACHMENTS r

  This particular query can be rewritten as

  SELECT 5411.000455*cast(1/0.20 as integer) as mount FROM MON$ATTACHMENTS r

  Though it will not work equally well with other numbers, at least not if 
cast(1/0.xx as numeric(16, 4)) doesn't yield sufficient precision when 
doing 5411.000455*ResultFromAbove.

  HTH,
  Set


  

[Non-text portions of this message have been removed]

Re: [firebird-support] Arithmetic overflow or division by zero has occurred.

[Ismael L. Donis Garcia]

Perfect

1 million of thanks
=
|| ISMAEL ||
=
  - Original Message - 
  From: Huan Ruan 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, March 29, 2012 5:13 PM
  Subject: Re: [firebird-support] Arithmetic overflow or division by zero has 
occurred.



  On 30 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
  >
  > 54311.999455 / 1.01 = 54311,945143
  >

  Cast one of the numbers in your calculation as "double precision", e.g.

  SELECT cast(cast(54311.999455 as double precision)/1.01 as
  numeric(16,6)) as mount FROM rdb$database

  Cheers
  Huan

  [Non-text portions of this message have been removed]



  

[Non-text portions of this message have been removed]

Re: [firebird-support] [Firebird-general] Linux install problem

[Ismael L. Donis Garcia]

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 cause this should have been to 'support'- definitely loosing the plot here 
:(

  
  Not sure what is going wrong here :(

  I've installed 2.5 using FirebirdCS-2.5.1.26351-0.amd64.tar.gz but it will 
not 
  create the SYSDBA passwork. I'm getting
  /opt/firebird/bin/gsec: cannot execute binary file
  I've run this a couple times already without a problem, for some reason this 
  time it is failing.

  Any pointers to what I may be missing ?

  Running on SUSE12.1 x64 exactly the same as this machine where it just 
installed 
  without a problem. I presume I've missed something that needs to be installed 
as 
  well ...

  -- 
  Lester Caine - G8HFL
  -
  Contact - http://lsces.co.uk/wiki/?page=contact
  L.S.Caine Electronic Services - http://lsces.co.uk
  EnquirySolve - http://enquirysolve.com/
  Model Engineers Digital Workshop - http://medw.co.uk//
  Firebird - http://www.firebirdsql.org/index.php



  

[Non-text portions of this message have been removed]

[firebird-support] values null in summation of record

[Ismael L. Donis Garcia]

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
=
|| ISMAEL ||
=

[Non-text portions of this message have been removed]

[firebird-support] OT: Program to replication db in linux

[Ismael L. Donis Garcia]

Exist some program to replication automatic to database firebird in Linux?

Best Regards
=
|| ISMAEL ||
=

[Non-text portions of this message have been removed]

Re: [firebird-support] Unexpected behaviour when using union

[Ismael L. Donis Garcia]

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
  Subject: [firebird-support] Unexpected behaviour when using union



  Configuration:
  - Windows 7 64 Bit professional SP1 NL
  - Firebird 2.5.1 64 Bit

  Table:
  CREATE TABLE "TEST" 
  (
  "TESTID" INTEGER NOT NULL,
  "NAME" VARCHAR(40),
  CONSTRAINT "TEST_PK" PRIMARY KEY ("TESTID")
  );

  2 records:
  insert into "TEST" ("TESTID", "NAME") values(1, 'EEN')
  insert into "TEST" ("TESTID", "NAME") values(2, 'twee')

  First query:
  "select "TESTID", "NAME" from test order by upper(2)"
  Answer (As expected):
  1, EEN
  2, twee

  Second query:
  "select "TESTID", "NAME" from test 
  union select "TESTID", "NAME" from test order by 2"
  Answer (Unexpected):
  1, EEN
  2, twee
  The answer has only two rows. I would expect each row double, in total 4 
rows. Is this normal behaviour?

  Third query:
  "select "TESTID", "NAME" from test 
  union select "TESTID", "NAME" from test order by upper(2)"
  Answer (Unexpected):
  An error message: ISC ERROR CODE:335544569
  ISC ERROR MESSAGE:
  Dynamic SQL Error
  SQL error code = -104
  Invalid command
  invalid ORDER BY clause

  Especially the third query is annoying me. Is this according to the standard 
or is it a bug? Why is does "order by upper(2)" not work with an union and work 
without an union?



  

[Non-text portions of this message have been removed]

[firebird-support] Enabling only numbers at field varchar(11)

[Ismael L. Donis Garcia]

As I could validate that an alone field of varchar(11) enabled numbers and 
that these had 11 characters of length?

Best Regards
=
|| ISMAEL ||
= 

Re: [firebird-support] Problem IBStoredProc

[Ismael L. Donis Garcia]

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 ^ ;


=
|| ISMAEL ||
=
  - Original Message - 
  From: Farshid Dehghan 
  To: firebird-support@yahoogroups.com 
  Sent: Thursday, August 23, 2012 1:16 PM
  Subject: [firebird-support] Problem IBStoredProc



  Hi
  I've used Delphi IBStoredProc, But not run.
  No error.
  Please get help

  //--in firebird
  SET TERM ^ ;
  CREATE PROCEDURE SP(
  TLek VARCHAR(15) CHARACTER SET NONE COLLATE NONE)
  RETURNS(
  PNAME VARCHAR(100) CHARACTER SET NONE COLLATE NONE)
  AS
  BEGIN
  Select Name FROM TBL1 Where (TLekName = :TLek) ORDER BY ID 
  Into :PName DO
  SUSPEND;
  END ^
  SET TERM ^ ;

  //--in delphi
  IBStoredProc1.StoredProcName := 'SP';
  IBStoredProc1.ParamByName('TLek').AsString := 'mb';
  IBStoredProc1.ExecProc;



  

[Non-text portions of this message have been removed]

[firebird-support] I need help to create trigger in Flamerobin and Firebird 2.5.1

[Ismael L. Donis Garcia]

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 del período de 
contable correspondiente al mes de ' 
  || case when (extract(month from old.fechap) = 1) then 'Enero/' when 
(extract(month from old.fechap) = 2) then 'Febrero/'
  when (extract(month from old.fechap) = 3) then 'Marzo/' when 
(extract(month from old.fechap) = 4) then 'Abril/'
  when (extract(month from old.fechap) = 5) then 'Mayo/' when 
(extract(month from old.fechap) = 6) then 'Junio/' 
  when (extract(month from old.fechap) = 7) then 'Julio/' when 
(extract(month from old.fechap) = 8) then 'Agosto/' 
  when (extract(month from old.fechap) = 9) then 'Septiembre/' when 
(extract(month from old.fechap) = 10) then 'Octubre/' 
  when (extract(month from old.fechap) = 11) then 'Noviembre/' else  
'Diciembre/' || extract(year from old.fechap) || ' de la entidad: ' || 
new.entidad);
  else
exception e_act;
end
END^
SET TERM ; ^

Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code: 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 16, column 160
)

Thanks all 
=
|| ISMAEL ||
=

[Non-text portions of this message have been removed]

Re: [firebird-support] I need help to create trigger in Flamerobin and Firebird 2.5.1

[Ismael L. Donis Garcia]

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 
Firebird 2.5.1




  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 del período de 
contable correspondiente al mes de ' 
  || case when (extract(month from old.fechap) = 1) then 'Enero/' when 
(extract(month from old.fechap) = 2) then 'Febrero/'
  when (extract(month from old.fechap) = 3) then 'Marzo/' when (extract(month 
from old.fechap) = 4) then 'Abril/'
  when (extract(month from old.fechap) = 5) then 'Mayo/' when (extract(month 
from old.fechap) = 6) then 'Junio/' 
  when (extract(month from old.fechap) = 7) then 'Julio/' when (extract(month 
from old.fechap) = 8) then 'Agosto/' 
  when (extract(month from old.fechap) = 9) then 'Septiembre/' when 
(extract(month from old.fechap) = 10) then 'Octubre/' 
  when (extract(month from old.fechap) = 11) then 'Noviembre/' else 
'Diciembre/' || extract(year from old.fechap) || ' de la entidad: ' || 
new.entidad);
  else
  exception e_act;
  end
  END^
  SET TERM ; ^

  Message: isc_dsql_prepare failed

  SQL Message : -104
  Invalid token

  Engine Code : 335544569
  Engine Message :
  Dynamic SQL Error
  SQL error code = -104
  Token unknown - line 16, column 160
  )

  Thanks all 
  =
  || ISMAEL ||
  =



[Non-text portions of this message have been removed]

Re: [firebird-support] How to create an calculated field for bank balance?

[Ismael L. Donis Garcia]

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 field for bank 
balance?



  Hello,

  Is there a trick to have this?

  CREATE TABLE BANK_ACCOUNT
  (
  ID INTEGER NOT NULL,
OCCURRENCE TIMESTAMP,
DESCRIPTION VARCHAR(100),
AMOUNT DECIMAL(10,2) NOT NULL
  CONSTRAINT PK_
  BANK_ACCOUNT _1 PRIMARY KEY (ID)
  );

  CREATE VIEW  BANK_ACCOUNT_STATEMENT (ID, 
  OCCURRENCE , 
  DESCRIPTION ,  AMOUNT, BALANCE)
  AS 

  SELECT r.*,  (Calculated Field)
   as BALANCE   
  FROM 
  BANK_ACCOUNT r
  order by r.OCCURRENCE
   desc
  ;

  Calculated Field is the previous record balance plus the current record field 
AMOUNT. If there is no previous record, then is the current record field AMOUNT.

  For example:
  ID  DESCRIPTION  AMOUNT  BALANCE
  1  Deposit  10   10
  2  Check-55
  3  Check-10  -5
  4  Credit transfer5045

  Thank you in advance for your support.

  [Non-text portions of this message have been removed]



  

[Non-text portions of this message have been removed]

[firebird-support] Install Firebird 2.5.2 CS i386 RC1 in they Debian squeeze

[Ismael L. Donis Garcia]

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 ||
= 

Re: [firebird-support] Re: View output differs from straight SELECT output

[Ismael L. Donis Garcia]

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 
  Sent: Tuesday, October 23, 2012 9:26 AM
  Subject: [firebird-support] Re: View output differs from straight SELECT 
output



  --- In firebird-support@yahoogroups.com, Thomas Steinmaurer  wrote:
  >
  > > Firebird 2.5RC3 (Debian version) on Debian Squeeze
  
  > > I created a view with this SQL:
  > > CREATE VIEW OKRESULTS (RUNID, OKCOUNT, OKPERCENTAGE)
  
  > > which gives output (in FlameRobin) like:
  > > RUNID OKCOUNT OKPERCENTAGE
  > > 8 5 [null]
  > >
  > > What am I doing wrong? Do I need to explicitly CAST the expression to
  > > e.g. a float?
  Hi Thomas,

  Thanks.
  > Looks a bit like:
  > http://tracker.firebirdsql.org/browse/CORE-3141
  Yes, it does... and it is fixed in FB embedded Windows 2.5.1
  > 
  > Any reason why you are using a RC of 2.5.0?

  It's the one distributed by Debian stable (6.0/Squeeze) - so it's a simple 
apt-get ;)
  Looks like an upgrade may be a good idea ;)



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Firebird Verison of this MySQL command

[Ismael L. Donis Garcia]

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 Gable 
  To: firebird-support@yahoogroups.com 
  Sent: Monday, February 04, 2013 9:56 AM
  Subject: RE: [firebird-support] Firebird Verison of this MySQL command



  Hi,

  CURRENTLEVELS is set as a integer 
  BARCODENUMBER is set as a VarChar(13) as that is the max number of a barcode
  STOCKCONTROLYN is set to VarChar(1) as it is is either 1 or 0

  And yes

  UPDATE ProductTable
  SET CurrentLevels = CurrentLevels - ' '
  WHERE BarcodeNumber = ' '
  AND StockControlYN = '1'

  That is what I want to do but Firebird is not happy is this function not
  supported in Firebird?

  Andy

  -Original Message-
  From: firebird-support@yahoogroups.com
  [mailto:firebird-support@yahoogroups.com] On Behalf Of Svein Erling Tysvær
  Sent: 04 February 2013 2:32 PM
  To: firebird-support@yahoogroups.com'
  Subject: RE: [firebird-support] Firebird Verison of this MySQL command

  >I am trying to update a coloum in Firebird via the following SQL 
  >command
  >
  >SQLCommand = vbNullString
  >SQLCommand = SQLCommand & "UPDATE ProductTable "
  >SQLCommand = SQLCommand & "SET "
  >SQLCommand = SQLCommand & "CURRENTLEVELS = CURRENTLEVELS - '" &
  Format(Readin(3), "#0") & "' "
  >
  >SQLCommand = SQLCommand & "WHERE "
  >SQLCommand = SQLCommand & "BARCODENUMBER='" & Readin(2) & "' and "
  >SQLCommand = SQLCommand & "STOCKCONTROLYN='1';"
  > 
  >ReadIn(3) is a value that comes from the data file
  >
  >My problem is this The above SQL command works on MySQL, MSSQL, 
  >PostgreSQL But it will not work on Firebird
  >
  >My application that is doing the processing crashes when it run agenst 
  >Firebird
  > 
  >So what is the Firebird version of this?
  >
  >basically I want to update the CURRENTLEVELS orginal value but take 
  >away the
  >Readin(3) value

  Hi Andy!

  Basically, your SQL call is something like:

  UPDATE ProductTable
  SET CurrentLevels = CurrentLevels - ' '
  WHERE BarcodeNumber = ' '
  AND StockControlYN = '1'

  The problem I see here, is that seems to be a string - there should
  not be ' around the value if it is a number. Firebird does not support
  deducting from a string, at least not this way (there may be UDFs or similar
  that can do it). If BarcodeNumber and StockControl are CHAR or VARCHAR, then
  it is of course correct to use ' around them.

  HTH,
  Set

  

  ++

  Visit http://www.firebirdsql.org and click the Resources item on the main
  (top) menu. Try Knowledgebase and FAQ links !

  Also search the knowledgebases at http://www.ibphoenix.com 

  ++
  Yahoo! Groups Links



  

[Non-text portions of this message have been removed]

Re: [firebird-support] Problems trying to create Stored Procedure

[Ismael L. Donis Garcia]

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

| ISMAEL |


- Original Message - 
  From: Jerry Sands 
  To: firebird-support@yahoogroups.com 
  Sent: Friday, November 01, 2013 12:31 PM
  Subject: RE: [firebird-support] Problems trying to create Stored Procedure




  Change “SUSPEND#” to “SUSPEND;”





  From: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] On Behalf Of jim.rhema...@gmail.com
  Sent: Friday, November 01, 2013 11:23 AM
  To: firebird-support@yahoogroups.com
  Subject: [firebird-support] Problems trying to create Stored Procedure





  Good afternoon.



  Thank you for taking the time to help me on this.  I am new to creating and 
using Stored Procedures so please bear with me.



  I am trying to create this stored procedure:



  SET TERM #;

  CREATE PROCEDURE FindSalesAmt(Name VARCHAR(20)) RETURNS (price decimal(18,2), 
id bigint,

   description VARCHAR(90)) AS

  BEGIN 

SELECT startprice, itemid, title from ebayrevisefile

WHERE price > 20.00

INTO :price, :id, :description;

SUSPEND#

  END#

  SET TERM ;#

  GRANT EXECUTE ON PROCEDURE FindID to PUBLIC WITH GRANT OPTION;

suspend;

  end



  And when I compile it I get an error on the set term.  As I understand it the 
; is a terminator so I need to use a different one within the procedure.



  Any help on this is appreciated.  I am using Firebird 2.5 with DBVisualizer 
Pro 9.0.3. 



  Thank you!



  

[firebird-support] Test no reply

[Ismael L. Donis Garcia]

Test. 
I am not receiving the messages that I send to the list

Best Regards

| ISMAEL |

Re: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0

[Ismael L. Donis Garcia]

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:31 AM
  Subject: RES: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from 
Firebird 3.0




  OK! We will help!



  De: firebird-support@yahoogroups.com 
[mailto:firebird-support@yahoogroups.com] Em nome de LtColRDSChauhan
  Enviada em: terça-feira, 14 de janeiro de 2014 11:26
  Para: firebird-support@yahoogroups.com
  Assunto: [firebird-support] Migrate to Firebird 2.5.2 Win 32 from Firebird 3.0





  Please help me migrate to Firebird 2.5.2 from Firebird 3.0.




  Thanks & Regards,

  Lt Col (Retd) Rajiv Dular Singh Chauhan



  

[firebird-support] Test FB 3.0 Alpha 2 in Debian 7.3

[Ismael L. Donis Garcia]

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 |

Re: [firebird-support] datetime trunc

[Ismael L. Donis Garcia]

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 2:20 PM
  Subject: Re: [firebird-support] datetime trunc



  On 11-2-2014 16:06, Virna Constantin wrote:
  >
  >
  > EXTRACT()
  > http://www.firebirdsql.org/refdocs/langrefupd25-intfunc-extract.html

  Extract is not the same as PostgreSQL date_trunc. Extract returns the 
  requested value as an integer, while date_trunc returns a DATE or 
  TIMESTAMP truncated to the requested date field, example from 
  
http://www.postgresql.org/docs/current/static/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
 
  :

  SELECT date_trunc('hour', TIMESTAMP '2001-02-16 20:38:40');
  Result: 2001-02-16 20:00:00

  SELECT date_trunc('year', TIMESTAMP '2001-02-16 20:38:40');
  Result: 2001-01-01 00:00:00

  > On Tuesday, February 11, 2014 4:42 PM, Maximiliano Robaina
  >  wrote:
  >
  > Hi,
  >
  > Is there an equivalent function to trunc datetime fields in firebird ?
  > Something like date_trunc in postgre [1]


  

[firebird-support] FB 2.5.3?

[Ismael L. Donis Garcia]

anyone knows when it will release version 2.5.3

Best Regards

| ISMAEL |

[firebird-support] install firebird 3 superclasic in linux

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

as I can install firebird 3 superclasic in linux?
I want to try it on devuan

Best Regards

| ISMAEL |

[firebird-support] as I can install firebird 3RC2 superclasic in linux?

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

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 |
 

[firebird-support] conect flamerobin with Firebird3

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

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 : -902
Unsuccessful execution caused by a system error that precludes successful 
execution of subsequent statements

Engine Code: 335544745
Engine Message :
Your login SYSDBA is same as one of the SQL role name. Ask your database 
administrator to set up a valid Firebird login.
unknown ISC error 335545081

As I can overcome this error?

Best Regards

| ISMAEL |

Re: [firebird-support] conect flamerobin with Firebird3

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

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 connect, but when I turn off the PC and turn again and I 
no longer connect.

I'm trying to connect to the user who creates the BD

Regards..

| ISMAEL |


  - Original Message - 
  From: 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Tuesday, April 26, 2016 8:41 AM
  Subject: Re: [firebird-support] conect flamerobin with Firebird3



  > 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 : -902
  > Unsuccessful execution caused by a system error that precludes successful
  > execution of subsequent statements
  > 
  > Engine Code : 335544745
  > Engine Message :
  > Your login SYSDBA is same as one of the SQL role name. Ask your database
  > administrator to set up a valid Firebird login.
  > unknown ISC error 335545081
  > 
  > As I can overcome this error?

  Are you sure that FlameRobin picks up the FB 3 client library?

  --
  With regards,
  Thomas Steinmaurer
  http://www.upscene.com

  Professional Tools and Services for Firebird
  FB TraceManager, IB LogManager, Database Health Check, Tuning etc.



  
  Posted by: "Thomas Steinmaurer"  
Reply via web post  . Reply to sender  . Reply to group  . Start a New 
Topic  . Messages in this topic (2)  

Re: [firebird-support] conect flamerobin with Firebird3

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

No I have not registered the dabtabase with the sysdba user.
Even as I say connect and put the user who believes the database and gives me 
the same error as if flamerobin not respect the user with which I want to 
connect.
This error does not occur in version 2.5.5 because the db is a restored from a 
dabtabase running perfectly firebird 2.5.5 with the sysdba role created and 
another user as the owner of the dabtabase.

Regards..

| ISMAEL |


  - 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, 'Ismael L. Donis Garcia' sli...@citricos.co.cu 
  [firebird-support] wrote:
  > Create a firebird 3 bd in another user who is not sysdba
  > and create a role called sysdba without permission

  Creating a role called SYSDBA will disallow the user SYSDBA to connect 
  to Firebird.

  > and when I try to connect from flamerobin you give me the following
  > error message

  What user? Given the error below I suspect you are connecting with 
  SYSDBA.

  > *** IBPP::SQLException ***
  > Context: Database::Connect
  > Message: isc_attach_database failed
  >
  > SQL Message : -902
  > Unsuccessful execution caused by a system error that precludes
  > successful execution of subsequent statements
  >
  > Engine Code : 335544745
  > Engine Message :
  > Your login SYSDBA is same as one of the SQL role name. Ask your
  > database administrator to set up a valid Firebird login.
  > unknown ISC error 335545081
  >
  > As I can overcome this error?

  Dont create / drop the role SYSDBA.

  Mark


  
  Posted by: Mark Rotteveel  
Reply via web post  • Reply to sender  • Reply to group  • Start a New 
Topic  • Messages in this topic (4)  

Re: [firebird-support] FB 3.0 and PHP connection

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

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, open firebird.conf and find the entry for the parameter 
UserManager:
#UserManager = Srp
Delete the “#” symbol and change the value to:
UserManager = Legacy_UserManager
Find the entry for the WireCrypt parameter:
#WireCrypt = Enabled (for client) / Required (for server)
Delete the “#” symbol and change the value to:
WireCrypt = Disabled
Find the entry for the AuthServer parameter:
#AuthServer = Srp, WinSspi, Legacy_Auth
Delete the “#” symbol and change the order of the arguments:
AuthServer = Legacy_Auth, Srp, WinSspi
Find the entry for the AuthClient parameter:
#AuthClient = Srp, WinSspi, Legacy_Auth
Delete the “#” symbol and change the order of the arguments:
AuthClient = Legacy_Auth, Srp, WinSspi
Save the changes.
Stop and restart Firebird for the changes to take effect.
Legacy Passwords
The old masterke password is available for your first login as SYSDBA. It is 
known to the whole world and should be changed as soon as possible.
Reminder: Legacy authentication reads only the first 8 characters of any 
password.

Best Regards

| ISMAEL |


  - Original Message - 
  From: 'palbe...@libero.it' palbe...@libero.it [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Tuesday, April 26, 2016 9:47 AM
  Subject: [firebird-support] FB 3.0 and PHP connection




  Hi all,
   I'm working on the evaluation of Firebird SQL 3.0 and connection using PDO 
available in PHP.


  The database works fine and I'm able to connect it using FlameRobin but when 
I try to establish a connection using PHP I get a NULL as result of the follow:


  getMessage() . "";
 
  }
  var_dump($dbh);
  ?>


  PHP load fine the PDO and PDO_Firebird, does anyone knows if I have to move 
some DLL somewhere?


  NOTE: Windows 2012 R2, PHP Version 5.2.12, Apache 2.2, Firebird 3.0



  Thanks in advance.
  Alberto





  

--
  Posted by: "palbe...@libero.it"  
--

Reply via web post  • Reply to sender  • Reply to group  • Start a New 
Topic  • Messages in this topic (1)  


--

  Upgrade your account with the latest Yahoo Mail app
   
  Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!

--

  ++

Re: [firebird-support] conect flamerobin with Firebird3

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

>- 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, 'Ismael L. Donis Garcia' sli...@citricos.co.cu
>[firebird-support] wrote:
>> Create a firebird 3 bd in another user who is not sysdba
>> and create a role called sysdba without permission
>
>Creating a role called SYSDBA will disallow the user SYSDBA to connect
>to Firebird.
>

precisely that.

>> and when I try to connect from flamerobin you give me the following
>> error message

>What user? Given the error below I suspect you are connecting with
>SYSDBA.

the user who creates the database, which is the same with which I am trying 
to connect, but also comes with other users who have permissions to other 
roles created through

>> *** IBPP::SQLException ***
>> Context: Database::Connect
>> Message: isc_attach_database failed
>>
>> SQL Message : -902
>> Unsuccessful execution caused by a system error that precludes
>> successful execution of subsequent statements
>>
>> Engine Code : 335544745
>> Engine Message :
>> Your login SYSDBA is same as one of the SQL role name. Ask your
>> database administrator to set up a valid Firebird login.
>> unknown ISC error 335545081
>>
>> As I can overcome this error?
>
>Dont create / drop the role SYSDBA.
>
>Mark
>
>Posted by: Mark Rotteveel m...@lawinegevaar.nl

This problem does not occur in firebird 2.5.x

there any way to solve this error, or an issue introduced in firebird3?

Best Regards

| ISMAEL |

[firebird-support] install firebird 3 in "devuan"

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

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 OS.
Please enter new password for SYSDBA user: password
Install completed
root@vir-ser-dev2:/home/idonis/Descargas/Firebird-3.0.0.32483-0.i686# 
invoke-rc.d firebird start
root@vir-ser-dev2:/home/idonis/Descargas/Firebird-3.0.0.32483-0.i686# ps aux 
| grep firebir
root 4333 0.0 0.2 4576 2192 pts/0 S+ 08:03 0:00 grep firebir
root@vir-ser-dev2:

the indentical startup script is /opt/firebird/misc/firebird.init.d.debian

>From now Thanks

| ISMAEL |
 

Re: [firebird-support] install firebird 3 in "devuan"

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

what there is to add in the installer:

# Devuan specific
elif [ -r /etc/devuan_version ]
then
srcScript=firebird.init.d.debian
initScript=/etc/init.d/firebird
rm -f /usr/sbin/rcfirebird
ln -s ../../etc/init.d/firebird /usr/sbin/rcfirebird

Best Regards

| ISMAEL |


- Original 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 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 OS.
Please enter new password for SYSDBA user: password
Install completed
root@vir-ser-dev2:/home/idonis/Descargas/Firebird-3.0.0.32483-0.i686#
invoke-rc.d firebird start
root@vir-ser-dev2:/home/idonis/Descargas/Firebird-3.0.0.32483-0.i686# ps aux
| grep firebir
root 4333 0.0 0.2 4576 2192 pts/0 S+ 08:03 0:00 grep firebir
root@vir-ser-dev2:

the indentical startup script is /opt/firebird/misc/firebird.init.d.debian

>From now Thanks

| ISMAEL |



 

[firebird-support] Triggers on table MON$ATTACHMENTS

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

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 |

Re: [firebird-support] Re: Triggers on table MON$ATTACHMENTS (Solved)

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

>- 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 create triggers in the MON$ATTACHMENTS table?
>
>  No
>
>> 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
>
>  RTFM: Database triggers
>
>http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl->trgr.html#fblangref25-ddl-trgr-dbtrigger

SET TERM ^ ;
CREATE TRIGGER CONNECT_TR ACTIVE
ON CONNECT POSITION 0
AS
BEGIN
  /* Trigger para validar usuarios activos del sistema */
  delete from sccon where conec not in (select a.MON$ATTACHMENT_ID from 
MON$ATTACHMENTS a);
END^
SET TERM ; ^

Best Regards

| ISMAEL |

Re: [firebird-support] Re: Triggers on table MON$ATTACHMENTS

['Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support]]

>- 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 create triggers in the MON$ATTACHMENTS table?
>
>  No
>
>> 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
>
>  RTFM: Database triggers
>
>http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-ddl->trgr.html#fblangref25-ddl-trgr-dbtrigger

CREATE TRIGGER DISCONNECT_TR ACTIVE
ON DISCONNECT POSITION 0
AS
BEGIN
  /* Trigger para validar usuarios activos del sistema */
  delete from table1 where con = CURRENT_CONNECTION;
END

Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code: 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Unexpected end of command - line 6, column 35

Best Regards

| ISMAEL |

Re: [firebird-support] Migrating a 2.5 server

['Ismael L. Donis Garcia' sli...@natio.co.cu [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 -
  From: Luke Crooks l...@solentwholesale.com [firebird-support]
  To: firebird-support@yahoogroups.com
  Sent: Monday, February 06, 2017 6:24 AM
  Subject: [firebird-support] Migrating a 2.5 server







  So currently I have firebird 2.5 installed and running on Windows, working 
fine but performance is a bit slow.


  I have installed 2.5 on Ubuntu, and I can connect to the current database 
with ISQL easily:


connect "192.168.155.112:C:\database\database.FDB" user 'SYSDBA' password 
'adminpassword';
So I stopped the firebird services on the Windows server, copied the file to 
the Ubuntu server, and in isql tried to run:


SQL> connect "localhost:/var/lib/firebird/2.5/data/database.FDB" user 'SYSDBA' 
password 'adminpassword';
Statement failed, SQLSTATE = m
file /var/lib/firebird/2.5/data/database.FDB is not a valid database
Note I have so far tried:


~$ sudo adduser `id -un` firebird
[sudo] password for luke:
The user `luke' is already a member of `firebird'.
As well as


# chown firebird /var/lib/firebird/2.5/data/database.fdb
With no luck, if anyone has any idea as to why I might be getting this error, I 
would be very grateful :)


  I am not sure if Super or Classic was used on Windows, however I have tried 
using both on Ubuntu with the same error message. Windows server version 2.5.6, 
same version on Linux






  Regards,
  --
  Luke Crooks








  

Re: [firebird-support] QUERY QUESTION

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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] QUERY QUESTION



  Good day,

  I have a question for you SQL boffins, how can I query a table to get the
  count of consecutive days found ?

  A Table contains rows with dates where an item(s) has been added for every
  day this item was used. 

  i.e.

  itemnr dateused

  abc 2017/02/01

  abc 2017/02/02

  abc 2017/02/25

  abc 2017/02/25

  abc 2017/02/25

  abc 2017/02/26

  abc 2017/02/27

  abc 2017/02/28

  abc 2017/03/01

  abc 2017/03/02

  The result from above sample should be 6 as there is a break between
  2017/02/02 and 2017/02/25?

  Regards

  Stef

  [Non-text portions of this message have been removed]



  

[firebird-support] Install Firebird FirebirdCS-2.5.7.27050-0.i686 in Devuan 1 32 bit

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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.

Best Regards
--
Ismael
Devuan User : http://distrowatch.com/table.php?distribution=devuan

Re: [firebird-support] Install Firebird FirebirdCS-2.5.7.27050-0.i686 in Devuan 1 32 bit [Solved]

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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: [firebird-support] Install Firebird FirebirdCS-2.5.7.27050-0.i686 in 
Devuan 1 32 bit




  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.

  Best Regards
  --
  Ismael
  Devuan User : http://distrowatch.com/table.php?distribution=devuan


  

[firebird-support] OT: Firebird 4.0 xinetd Support on Linux Replaced

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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 (listener) process starts up via init/systemd, binds to the 3050 port and 
spawns a worker firebird process
for every connection-similarly to what happens on Windows.

This has caused me the following doubt:
With this modification Firebird 4.0 will work on linux system that do not use 
systemd? Yes or no?

Best Regards
--
Ismael
Devuan User : http://distrowatch.com/table.php?distribution=devuan

Re: [firebird-support] Doubts about Firebird in Linux....

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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: Thursday, May 17, 2018 1:22 AM
>Subject: RE: [firebird-support] Doubts about Firebird in Linux
>
>
>Hi Aldo,
>
>is not ext4 too slow?
>What mount switches do you use?
>We had to switch back to ext3, because ext4 was too slow (barrier switch 
>and db forced write were on).
>
>András
>
>>From: firebird-support@yahoogroups.com 
>>[mailto:firebird-supp...@yahoogroups..com]
>>Sent: Thursday, May 17, 2018 2:14 AM
>>To: firebird-support@yahoogroups.com
>>Subject: Re: [firebird-support] Doubts about Firebird in Linux
>>
>>I'm running Firebird on Linux since many years, with the following 
>>environment:
>>
>>1. Ubuntu 14.04 ( I've also run it on Debian 6.0 )
>>2. ext4
>>3. Journaling
>>4. Firebird 2.5.2
>>Aldo Caruso
>>
>>>El 16/05/18 a las 20:43, Javier Cintron 
>>>fcintr...@yahoo.com [firebird-support] 
>>>escribió:
>>>
>>>Firebird ver 2.5.7.27050 64 bits
>>>Superserver
>>>Windows Server 2012R2
>>>
>>>I am planning to change the operating system that hosts our ERP's 
>>>Firebird Databases from Windows Server 2012R2
>>>to Linux and I have some questions about it:
>>>
>>>
>>>1. Which Linux distribution do you recommend? I have experience using 
>>>Centos.
>>>2. Which Linux file system do you recommend? (ext3 ext4, etc)
>>>3. Do you recommend using a journaling file system?
>>>4. One of the requirements is that the Firebird has to be 2.5.7.27050 but 
>>>as of today the current version is 2.5.8.27089: is there a >>>repository 
>>>of past firebird versions?
>>>
>>>Thanks in advance for your help

Re: [firebird-support] firebird binary installs and debian 10 - unattended-upgrades deleted firebird user

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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: firebird-support@yahoogroups.com 
  Sent: Monday, March 25, 2019 12:25 PM
  Subject: [firebird-support] firebird binary installs and debian 10 - 
unattended-upgrades deleted firebird user




  Hi list .

  Since february I'm using debian 10 for a try (as a server) .

  All firebird installs I do, are from binaries downloaded from firebirsql.org .


  I don't use unattended-upgrades package because I'm not familiar with it ..




  I found today that firebird didn't start . After some research I found 
firebird user was not there  but firebird group was.




  Manual debian upgrades, sometimes ask me if firebird user can be deleted to 
which I answer NO.




  Seems unattended-upgrades don't ask, or should be configured properly .

  I just created firebird user again and recreate permission on files / 
directories and it started fine.





  And unattended-upgrades is now gone.





  Regards




  Pablo Sánchez



  

--
  Posted by: pab...@adinet.com.uy 
--

Reply via web post  • Reply to sender  • Reply to group  • Start a New 
Topic  • Messages in this topic (1)  


--

  Have you tried the highest rated email app?
   
  With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app 
on the market. What are you waiting for? Now you can access all your inboxes 
(Gmail, Outlook, AOL and more) in one place. Never delete an email again with 
1000GB of free cloud storage.

--

  ++

  Visit http://www.firebirdsql.org and click the Documentation item
  on the main (top) menu.  Try FAQ and other links from the left-side menu 
there.

  Also search the knowledgebases at 
http://www.ibphoenix.com/resources/documents/ 

  ++ 
  Visit Your Group 
   


  .
   
   

Re: [firebird-support] firebird binary installs and debian 10 - unattended-upgrades deleted firebird user

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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 problem, although use 
devuen, although it is almost the same, but without systemd
For the next month is that I plan to use devuan 3 which is equivalent to debian 
10

Best regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

  - Original Message - 
  From: pab...@adinet.com.uy [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Monday, March 25, 2019 5:21 PM
  Subject: Re: [firebird-support] firebird binary installs and debian 10 - 
unattended-upgrades deleted firebird user



  Ismael, the post was just a heads up for anyone using binaries install on 
debian 10 .

  
  Posted by: pab...@adinet.com.uy 
Reply via web post  • Reply to sender  • Reply to group  • Start a New 
Topic  • Messages in this topic (3)  

  ++

  Visit http://www.firebirdsql.org and click the Documentation item
  on the main (top) menu.  Try FAQ and other links from the left-side menu 
there.

  Also search the knowledgebases at 
http://www.ibphoenix.com/resources/documents/ 

  ++ 
  Visit Your Group 
 

Re: [firebird-support] Off-Topic: Firebird future

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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 - 
  From: Lucas Franzen l...@frred.de [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Tuesday, October 22, 2019 9:50 AM
  Subject: Re: [firebird-support] Off-Topic: Firebird future




  Am 22.10.2019 um 15:24 schrieb Stefan Heymann li...@stefanheymann.de 
  [firebird-support]:
  >>> If you want to have it for free, like in
  >>> free beer, you can sit down, write it and publish it
  >> This is the plan. ;-)
  >> Gabor
  >
  > Sounds like a good plan :-))

  Yes, I can confirm this, we tested that plan very thoroughly.

  Worked like a charm.

  Lucas



  
  Posted by: Lucas Franzen  
Reply via web post  • Reply to sender  • Reply to group  • Start a New 
Topic  • Messages in this topic (17)  

Re: [firebird-support] Re: Off-Topic: Firebird future

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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 Message - 
  From: emou...@yahoo.fr [firebird-support] 
  To: firebird-support@yahoogroups.com 
  Sent: Tuesday, October 29, 2019 12:24 PM
  Subject: Re: [firebird-support] Re: Off-Topic: Firebird future






  >
  > Lazarus/Delphi developers are unable to use isql?
  >

  Hello,

  I can use isql; I can use isql. But when there is more than 5, 6 tables, a 
graphical tool becomes useful and saves a lot of time.

  For information, I have pasted a link to "Red Expert" GUI: it is a very 
advanced program (written for Java 8; so, works on Windows and Linux). The 
screenshot is there to show that with a graphical interface, understanding the 
relationships of a database is immediate (not to mention the bookmarks of 
favorite queries, sorting \ filtering by clicking on a column, etc).

  https://www.cjoint.com/c/IJDrlzg3d83

  Best regards



  

--
  Posted by: emou...@yahoo.fr 
--

Reply via web post  • Reply to sender  • Reply to group  • Start a New 
Topic  • Messages in this topic (31)  

  ++

  Visit http://www.firebirdsql.org and click the Documentation item
  on the main (top) menu.  Try FAQ and other links from the left-side menu 
there.

  Also search the knowledgebases at 
http://www.ibphoenix.com/resources/documents/ 

  ++ 
  Visit Your Group 
   • Privacy • Unsubscribe • Terms of Use 

[firebird-support] Automated smapshot builds of linux

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

Automated constructions of Linux snapshots are not being made since day 11.
Who could review this?

Best Regards
--
Ismael

[firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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 structure for file /mnt/ccs/libsc.fdb; found 11.2, support 
12.2
IProvider::attachDatabase failed when loading mapping cache

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:
Context:Database::Create
Message:isc_dsql_execute_immediate failed

SQL Message:-551
This user not have privilege to perform this operation on this object

Engine Code :335544352
no permission for CREATE access to DATABASE /mnt/ccs/test.fdb

Best Regards
--
Ismael
Devuan User: http://distrowatch.com/table.php?distribution=devuan

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

And how do I assign the pre-benefits to the user that I am going to use to 
create the database?

Reiterated greetings
--
Ismael
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 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 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 the user.
>
>   Actually it is plainly written in the error messages.
>
> -- 
>   WBR, SD.
>
>








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

I don't know if I will be such a novice, but I can't find the language 
reference manual for firebird 3

I install firebird3 in devuan which is the operating system I use and it 
asks me for the password of the user sysdba.

Then if I create the user from flamerobin or using gsec it never lets me use 
that user that I create to create a new database, that has never happened to 
me with firebird 2.5.x

And the truth is that I have tried in several ways, but the truth did not 
achieve positive results.

Can't someone give me a more detailed explanation of how to create a 
database in firebird 3 with a user other than sysdba?

I know that time is money, but I do not think that it is so much for those 
who really have the knowledge of how to do it, I have already searched the 
internet and I have not found it, perhaps it is not possible to search there 
either.

Best regards
--
Ismael
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 
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 "GRANT" statement as described in Language Reference.
>
> -- 
>   WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
> 








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/

Re: [firebird-support] error when trying to open databases 2.5 on server 3.0.5

['Ismael L. Donis Garcia' sli...@natio.co.cu [firebird-support]]

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-support] 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 firebird 3
>
> https://firebirdsql.org/en/reference-manuals/
>
>   Google Translate can help you read it.
>
> -- 
>   WBR, SD.
>
>
> 
>
> 
>
> ++
>
> Visit http://www.firebirdsql.org and click the Documentation item
> on the main (top) menu.  Try FAQ and other links from the left-side menu 
> there.
>
> Also search the knowledgebases at 
> http://www.ibphoenix.com/resources/documents/
>
> ++
> 
>
> Yahoo Groups Links
>
>
>
> 








++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/