If a column in a SELECT list is not an aggregate function then you need to
write it in the GROUP BY clause.
Many people have your same problem when start using SQL.
Greetings.
Walter.
On Thu, Sep 25, 2014 at 9:38 AM, 'Andrew Gable' andrew.ga...@tesco.net
[firebird-support]
Hello Marcos
I think you are from Colombia, so you can read and write Spanish.
You can post all your doubts about Firebird, SQL or databases in a forum
which URL is:
firebird21.yoforeo.com
Greetings.
Walter.
On Mon, Sep 22, 2014 at 10:38 AM, Marcos Herrera marcos.herr...@manar.com.co
If you can read Spanish, here is an article about encryption, read also the
related articles:
http://firebird21.wordpress.com/2014/08/28/encriptando-columnas-de-una-tabla/
Greetings.
Walter.
On Thu, Aug 28, 2014 at 7:26 AM, Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]
Nobody has an idea?
Greetings.
Walter.
On Mon, Jun 23, 2014 at 10:45 AM, W O sistemas2000profesio...@gmail.com
wrote:
Something strange has occurred.
Yesterday I try to create a user after connecting with the role RDB$ADMIN
No success. An error message.
Some minutes ago I did exactly
Something strange has occurred.
Yesterday I try to create a user after connecting with the role RDB$ADMIN
No success. An error message.
Some minutes ago I did exactly the same thing, because I wanted to copy the
error message and write it in an e-mail, asking for help.
However, now it works.
I like very much the way Ann explains, almost impossible to be more clear.
Greetings.
Walter.
On Tue, May 20, 2014 at 10:47 AM, Ann Harrison
aharri...@ibphoenix.com[firebird-support]
firebird-support@yahoogroups.com wrote:
On Mon, May 19, 2014 at 1:31 PM,
Svein, Bhavbhuti has a background as a Visual FoxPro developer and in that
language exist empty dates.
Probably is the reason why he had casted an empty string as a timestamp.
The same thing had happened to me when I was learning SQL.
Greetings.
Walter.
On Tue, May 13, 2014 at 4:02 AM,
If you can read Spanish (as I think) then you can start reading these
articles:
http://firebird21.wordpress.com/category/indice-de-este-blog/
Look for a category named OLAP Y OLTP
And if you have any doubt just write the question there.
Greetings.
Walter.
On Sun, May 11, 2014 at 10:59 AM,
That's the most simple formula Josef but requires that COLUMN always be 1
or 0, never another number neither NULL.
Greetings.
Walter.
On Thu, Apr 3, 2014 at 1:06 AM, Josef Kokeš j.ko...@apatykaservis.czwrote:
On 2.4.2014 9:26, Bogdan Mihalache wrote:
Update table set *column =
Yes, it is easy.
If you can read (or translate) Spanish, there is an article on my blog,
which explain step by step how to do that:
http://firebird21.wordpress.com/2014/03/17/usando-excel-para-leer-bases-de-datos-de-firebird/
Greetings.
Walter.
On Sat, Mar 29, 2014 at 1:35 AM,
Many programming languages also use the '+' symbol as a string
concatenation operator, such as: Basic, dBase, Visual FoxPro, etc.
Greetings.
Walter.
On Fri, Mar 21, 2014 at 11:02 AM, Thomas Steinmaurer
t...@iblogmanager.comwrote:
FB 1.5
The following SQL (and variations of it)
If I am understanding well, you need to do replication.
Greetings.
Walter.
On Fri, Jan 10, 2014 at 9:52 AM, dice_in_trou...@yahoo.com wrote:
Hi,
I have a frebird database in which was copied and was updated at the same
time. My questions is how can I transfer the content of one of the
to combine the data from one
database to another?
Thanks,
On Saturday, January 11, 2014 1:00 AM, W O
sistemas2000profesio...@gmail.com wrote:
If I am understanding well, you need to do replication.
Greetings.
Walter.
On Fri, Jan 10, 2014 at 9:52 AM, dice_in_trou...@yahoo.com wrote
And you can find several examples of that Ivan says, here:
http://firebird21.wordpress.com/2013/05/16/importar-datos-desde-otra-base-de-datos/
http://firebird21.wordpress.com/2013/05/31/insertar-modificar-o-borrar-filas-en-una-base-de-datos-externa/
Greetings.
Walter.
On Fri, Jan 10, 2014
What about creating a user with the RDB$ADMIN role?
Greetings.
Walter.
On Wed, Jan 8, 2014 at 8:41 AM, corni...@gmail.com wrote:
Hi
I want to fix my software usage of SYSDBA/masterkey and would appreciate
pointers to fastest/best way to do so. I have +- 100 installations running
on
Do you have the SET TERM?
Greetings.
Walter.
On Sat, Jan 4, 2014 at 2:41 AM, venussof...@gmail.com wrote:
Hi Walter
Okay I upgraded to FB 2.5.2.26540. I have successfully created the SPs
Parser and Crear_Tabla_Pivot but when I try to create the SP called
ACTUALIZAR_TABLA_PIVOT (I
We had used www.inspirohost.com the last year with good results.
Greetings.
Walter.
On Sat, Jan 4, 2014 at 2:22 PM, dice_in_trou...@yahoo.com wrote:
Hello to all,
I would like to host my firebird database on a provider, but don't have an
idea on where to start. We currently have a
, 2014 2:41 AM, W O
sistemas2000profesio...@gmail.com wrote:
We had used www.inspirohost.com the last year with good results.
Greetings.
Walter.
On Sat, Jan 4, 2014 at 2:22 PM, dice_in_trou...@yahoo.com wrote:
Hello to all,
I would like to host my firebird database on a provider
)
AS
SELECT r.IPID, m.IID, m.CCODE, r.BAMT
FROM SSALEINVOICEFOOTER r
JOIN MACCOUNTS m
on m.IID = r.IACCOUNTID
ORDER by r.IPID;
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON V_SSALEINVOICEFOOTER TO SYSDBA WITH GRANT OPTION;
On 29-12-2013 12:08 pm, W O wrote
You are right, Dmitry, I use EMS SQL Manager.
Thank you for answer, I'll try now with ISQL.
Greetings.
Walter.
On Sun, Dec 29, 2013 at 4:29 AM, Dmitry Yemanov
dim...@users.sourceforge.net wrote:
29.12.2013 02:36, W O wrote:
I am using Windows 7 Ultimate, Firebird 2.5.2, SuperServer
With ISQL it works fine. So the problem is with EMS SQL Manager Lite, I am
using version 5.2.3.2
Thank you again Dmitry.
Greetings.
Walter.
On Sun, Dec 29, 2013 at 10:47 AM, W O sistemas2000profesio...@gmail.comwrote:
You are right, Dmitry, I use EMS SQL Manager.
Thank you for answer
, NULL
20, 27072.00, 3248.64, 64.97, 32.49, NULL, NULL, NULL
Please advise
Thanks and regards
Bhavbhuti
On 28-12-2013 02:26 am, W O wrote:
Well, it is not complicated at all, I was waiting for somebody writing a
better technique but the days go on and that not happen
In the page:
http://www.firebirdsql.org/refdocs/langrefupd25-sqlstate.html
there is an example of the use of SQLSTATE, however it doesnt work. When I
try that code the message: Unknown variable - SQLSTATE is showed.
I had declared the variable MSG as VARCHAR(1024) and the exception
EX_CUSTOM as
30, 40, 700 or more distinct
pivot tables.
http://firebird21.wordpress.com/2013/12/29/creando-y-actualizando-tablas-agregadas-de-uso-general/
Greetings.
Walter.
On Sat, Dec 28, 2013 at 10:25 AM, W O sistemas2000profesio...@gmail.comwrote:
Well, I had added 2 more articles to my blog:
http
Well, it is not complicated at all, I was waiting for somebody writing a
better technique but the days go on and that not happen then I show you a
link to a page where the technique is described, with two examples. The
page is in Spanish but you can use some translator (Google has one). And of
Muy bueno.
Saludos.
Walter.
On Tue, Dec 24, 2013 at 1:58 PM, Carlos H. Cantu lis...@warmboot.com.brwrote:
Enjoy FB CoreTeam band playing a nice Xmas song ;)
http://www.firebirdnews.org/?p=9021
[]s
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
You have 2 ways:
SELECT
FIRST 1
MyColumns
FROM
MyTable
That's the old way.
SELECT
MyColumns
FROM
MyTable
ROWS
1
That's the new way.
Greetings.
Walter.
On Sat, Dec 21, 2013 at 4:24 PM, firebirddev firebirddev
firebird...@gmail.com wrote:
Hello.
I was wondering how
Ok, thank you Mark.
Then, no makes sense to declare a cursor just for retrieving rows?
Where I can see an example of WHERE CURRENT OF clause?
Greetings.
Walter.
On Mon, Dec 16, 2013 at 2:04 PM, Mark Rotteveel m...@lawinegevaar.nlwrote:
On 15-12-2013 20:25, W O wrote:
If in a stored
Thank you very much Paul.
Greetings.
Walter.
On Mon, Dec 16, 2013 at 11:40 PM, paul p...@vinkenoog.nl wrote:
Hallo Walter,
Then, no makes sense to declare a cursor just for retrieving rows?
No, for just retrieving rows FOR SELECT is easier and safer.
If you want to perform
Good explanation Ann, it's very clear now.
Greetings.
Walter.
On Fri, Dec 13, 2013 at 3:58 PM, Ann Harrison aharri...@ibphoenix.comwrote:
On Fri, Dec 13, 2013 at 4:15 AM, Tim Ward t...@telensa.com wrote:
For x records it's usual to see 2x fetches. If this creeps up to 3x
fetches and
Me too, and for sure many other people too.
Greetings.
Walter.
On Tue, Nov 12, 2013 at 1:05 AM, brucedickin...@wp.pl wrote:
I see
I would expect to see message that everything is ok...or something like
that...
---In firebird-support@yahoogroups.com, sistemas2000profesional@...
nothing at all on success) to have a verbose flag which did cause
a suitable success message to be produced.
On 12/11/2013 11:20, W O wrote:
Me too, and for sure many other people too.
Greetings.
Walter.
On Tue, Nov 12, 2013 at 1:05 AM, brucedickin...@wp.pl wrote:
I see
I
the value you want…
Sean
*From:* firebird-support@yahoogroups.com [mailto:
firebird-support@yahoogroups.com] *On Behalf Of *W O
*Sent:* Friday, November 08, 2013 9:00 PM
*To:* firebird-support@yahoogroups.com
*Subject:* Re: [firebird-support] Table and Sequence names by reference
That's a problem with GFIX. If everything is ok then it says nothing.
Greetings.
Walter.
On Fri, Nov 8, 2013 at 5:22 AM, brucedickin...@wp.pl wrote:
Hi guys,
I have this strange problem which I do not get it. I am trying to check my
database with given options:
gfix -user SYSDBA
Really it would be nice to have the table's name when you are inside a
trigger.
Greetings.
Walter.
On Fri, Nov 8, 2013 at 9:18 PM, Daniel L. Miller dmil...@amfes.com wrote:
On 11/7/2013 3:45 PM, Ann Harrison wrote:
On Thu, Nov 7, 2013 at 2:09 PM, Daniel L. Miller dmil...@amfes.comwrote:
. 20/09/2013, W O wrote:
Catching exceptions, maybe?
Maybe NOT! PSQL has exception handling built in. The default handler
passes execution immediately to the final EXIT statement and returns the
error to the client. Write your own exception handlers in triggers, SPs and
block executes to get
Hello Sean
I like to do double validation: at language program level and at database
level.
I don't like depending just of the language for any job, because always
there are several programmers here, sometimes programming with different
languages. If I can validate something in a stored
Hello Sean
I like to do double validation: at language program level and at database
level.
I don't like depending just of the language for any job, because always
there are several programmers here, sometimes programming with different
languages. If I can validate something in a stored
.
Greetings.
Walter.
On Thu, Sep 19, 2013 at 6:17 AM, Mark Rotteveel m...@lawinegevaar.nlwrote:
**
On 18-9-2013 22:12, W O wrote:
In the trigger EMPLEADOS_BIU is the sentence INSERT INTO ERRORES...
but a row is inserted into the table ERRORES only if there are no errors.
This works fine
That's right, the trigger never fires when the column is VARCHAR(20) and
the lenght of data is greater than 20.
Is that a bug or it works as expected?
Greetings.
Walter.
On Thu, Sep 19, 2013 at 10:28 AM, Mark Rotteveel m...@lawinegevaar.nlwrote:
**
On 19-9-2013 15:58, Alan McDonald
if the data is not valid?***
*
** **
** **
Sean
** **
*From:* firebird-support@yahoogroups.com [mailto:
firebird-support@yahoogroups.com] *On Behalf Of *W O
*Sent:* Thursday, September 19, 2013 12:00 PM
*To:* firebird-support@yahoogroups.com
*Subject:* Re: [firebird-support] Why
Hello everybody
In which case the oldest active transaction and the oldest snapshot
transaction are differents?
I constantly watch the identificators of the transactions in several
databases and always those numbers are equals.
In which case they can be differents?
Greetings.
Walter.
Hello everybody
The TID (Transaction Identificator) is of type INTEGER, so when the last
TID is 2.147.483.647 the next TID will be 1, right?
But, what happens if there was a transaction with the number 1?
The two transactions will have the same number?
Greetings.
Walter.
:* firebird-support@yahoogroups.com [mailto:
firebird-support@yahoogroups.com] *On Behalf Of *W O
*Sent:* Sunday, September 08, 2013 3:32 PM
*To:* firebird-support@yahoogroups.com
*Subject:* [firebird-support] Two transactions can have the same TID?
** **
Hello everybody
.
On Sun, Sep 8, 2013 at 8:53 PM, Helen Borrie hele...@iinet.net.au wrote:
**
At 11:53 a.m. 9/09/2013, W O wrote:
Thank you very much for your answer Helen.
I do backups every day, one full and several incrementals. Well, rather
it is done automatically by my program.
That sounds like
Thank you very much Paul for answering.
In your document Firebird 2.5 - Language Reference Update the database
owner, BOB, writes:
*grant digger to frank with admin option granted by fritz*
*
*
but, what if fritz doesnt agree with to be the grantor?
It can take him a long time for know that he
Thank you very much Milan, I shall try that.
Greetings.
Walter.
On Sat, Aug 31, 2013 at 5:38 AM, mil...@panonnet.net wrote:
**
Hello, It would probably be more efficient to use FBExport because it uses
a binary format, so file to transfer would be smaller. And you also get a
benefit of
Hello everybody
In a Firebird's datatabase I have a large table with thousands of records,
is there a simple way for send these records to a text file?
My idea is to have a script with the INSERT INTO commands.
Something like it:
INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(1, 'Alicia',
Thank you very much for your answer Christian, I shall try your sugestion.
Greetings.
Walter.
On Thu, Aug 29, 2013 at 2:54 PM, chris.waldmann
christian.waldm...@rte-ag.ch wrote:
**
--- In firebird-support@yahoogroups.com, W O sistemas2000profesional@...
wrote:
Hello everybody
Copy Tiger program and documentation are very differents. The screenshots
are not the same, never CTAdmin.exe saves the .INI files at the CONFIG
folder as the documentation say. CTReplicator.exe has not the option
Import configuration as a screenshot of the documentation shows and so.
After
As others had said, the context variable CURRENT_TIME returns 13 characters.
It works fine:
SELECT CAST(CURRENT_TIME AS VARCHAR(13)) FROM RDB$DATABASE
Greetings.
Walter.
On Wed, Aug 21, 2013 at 5:54 AM, Wewe sullen...@yahoo.com wrote:
**
SELECT substring(CAST(CURRENT_TIME AS
Ok, right, bad words.
Greetings.
Walter.
On Wed, Aug 21, 2013 at 12:20 PM, Mark Rotteveel m...@lawinegevaar.nlwrote:
**
On Wed, 21 Aug 2013 12:13:14 -0400, W O
sistemas2000profesio...@gmail.com
wrote:
As others had said, the context variable CURRENT_TIME returns 13
characters
INSERT INTO MyTable
(Column1, Column2, Column3)
VALUES (Value1, Value2, Value3)
RETURNING Value1
INTO MyVar1
Greetings.
Walter.
On Sat, Aug 10, 2013 at 10:50 PM, John W. (Jack) Cane
jwc...@enwphotos.comwrote:
**
After performing an insert I need to know the value of the primary key of
Excuse, it could be:
RETURNING Column1
Greetings.
Walter.
On Sun, Aug 11, 2013 at 12:09 PM, W O sistemas2000profesio...@gmail.comwrote:
INSERT INTO MyTable
(Column1, Column2, Column3)
VALUES (Value1, Value2, Value3)
RETURNING Value1
INTO MyVar1
Greetings.
Walter.
On Sat, Aug 10
Thank you very much for the info, Ann.
Greetings.
Walter.
On Tue, Jul 30, 2013 at 4:06 PM, Ann Harrison aharri...@ibphoenix.comwrote:
**
W O sistemas2000profesio...@gmail.com wrote:
If the tables have always the same name you don't need the EXECUTE
STATEMENT
I found a simple
If the tables have always the same name you don't need the EXECUTE STATEMENT
Greetings.
Walter.
On Tue, Jul 30, 2013 at 2:39 AM, Nagy Szilveszter
nagy_szilvesz...@yahoo.com wrote:
**
I found a simple solution:
EXECUTE STATEMENT 'insert into A select * from B';
:D
Thank you very much for your answer Dmitry
Greetings.
Walter.
On Sun, Jun 30, 2013 at 4:27 PM, Dmitry Kuzmenko k...@ibase.ru wrote:
**
Hello, W!
Monday, July 1, 2013, 12:15:21 AM, you wrote:
WO Hello
WO Somebody knows how to use arrays?
do not use arrays, ever.
Arrays are stored
Hello everybody
I usually write a COMMIT or a ROLLBACK when want to finish a transaction.
However in the documentation of ISQL said that SET AUTODDL ON finish the
transaction with a COMMIT.
But in my tests using Windows 7 of 32 bits, Firebird 2.5.2, SuperServer I
cannot get that.
SET AUTODDL
Thank you Dmitry
I had tried it and still doesnt work:
SET AUTODDL ON;
INSERT INTO MyTable (Column1, Column2) VALUES (Value1, Value2);
INSERT INTO MyTable (Column1, Column2) VALUES (OtherValue1, OtherValue2);
QUIT;
And when I return to ISQL and write SELECT * FROM MyTable the two previous
Thank you very much Dmitry
Yes, my fault, I had a lapsus.
Thank you again.
Greetings.
Walter.
On Sun, Jun 23, 2013 at 2:31 PM, Dmitry Kuzmenko k...@ibase.ru wrote:
**
Hello, W!
Sunday, June 23, 2013, 10:26:17 PM, you wrote:
WO I had tried it and still doesnt work:
WO SET AUTODDL
Hello everybody
Which can be the cause that a database of 3.1 gigabytes grows to 4.2
gigabytes after a cycle backup/restore?
The file FIREBIRD.CONF seems normal, nothing strange there.
Growing 1.1 gigabytes seems to me too much.
Greetings.
Walter.
[Non-text portions of this message have
The source database has 3.1 Gb but after the backup/restore have 4.2 Gb
Seems very strange for me.
Greetings.
Walter.
On Tue, Jun 18, 2013 at 6:03 PM, Leyne, Sean s...@broadviewsoftware.comwrote:
**
Walter,
Which can be the cause that a database of 3.1 gigabytes grows to 4.2
Something more, generally it is a better practice to have a view and call
that view.
So, you would write: SELECT * FROM MyView WHERE MyCondition GROUP BY
MyColumns ORDER BY MyOrder
Greetings.
Walter.
On Sat, Jun 15, 2013 at 3:54 PM, Iwan Cahyadi Sugeng
iwan.c.sug...@gmail.com wrote:
It seems very good, I can not see any drawback there.
Greetings.
Walter.
On Sat, Jun 1, 2013 at 1:26 AM, thp_pkmi thp_p...@yahoo.com wrote:
**
--- In firebird-support@yahoogroups.com, firebirdsql firebirdsql@...
wrote:
I have an after update/delete trigger and would like to know
No puedes enviar valores numéricos con comas porque el Firebird entiende
que estás enviando dos valores distintos, la coma se usa para separar
valores. Y el punto se usa para separar la parte entera de la parte decimal
de un número.
Si quieres leer sobre Firebird en castellano y preguntar las
As Dmitry said, the data is bigger than column size, but: which column is
the culprit?
I don't know why, but Firebird never tell us that information, in cases
like it you only can do: try and error.
When you are an expert it is easy at first sight to find the culprit column
but for a begginer it
In my tests, SIMILAR TO never uses an index.
Of course, you can force an index for the table with the clause ORDER BY
Greetings.
Walter.
On Fri, May 10, 2013 at 8:55 AM, Parzival parzival1...@gmx.at wrote:
**
Hello all,
I could note find an information on that subject so far: Is there
Yes Ann, you are right, but I said: an index for the table, not for a
subset of a table for retrieval.
Greetings.
Walter.
On Fri, May 10, 2013 at 11:34 AM, Ann Harrison aharri...@ibphoenix.comwrote:
**
On Fri, May 10, 2013 at 10:54 AM, W O sistemas2000profesio...@gmail.com
wrote
Ok Ann, I understand now your point of view.
Thank you very much for your answer.
Greetings.
Walter.
P.D: I really loves the way you write and it is not a joke.
On Fri, May 10, 2013 at 1:58 PM, Ann Harrison aharri...@ibphoenix.comwrote:
**
On Fri, May 10, 2013 at 12:18 PM, W O
Had you installed the driver ODBC (or another driver) ?
Had you installed the Firebird Client and the driver ODBC at the other
computers?
Greetings.
Walter.
On Tue, May 7, 2013 at 7:37 AM, douglasrrerere doug...@reith.com.au wrote:
**
Hi there,
New to firebird.
I'm attempting to
Thank you Ann, very clear.
Greetings.
Walter.
On Fri, May 3, 2013 at 10:42 AM, Ann Harrison aharri...@ibphoenix.comwrote:
**
Walter,
If having each record in one page is better than having a record in two
or
more pages then have sense for me that gbak keep each record in just
Thank you very much Ann, your explanation was (as usual) very good.
Just one more question:
As I understand it, in a page just can be the rows (records) of a single
table. No two or more tables can share a page.
Am I right?
Greetings.
Walter.
On Fri, May 3, 2013 at 10:59 AM, Ann
and so on
-Mensagem original-
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de W O
Enviada em: sexta-feira, 3 de maio de 2013 12:42
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] Re: use of -USE_ALL_SPACE
Thank you very
database and use a hexadecimal
editor ;)
-Mensagem original-
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de W O
Enviada em: sexta-feira, 3 de maio de 2013 14:20
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] Re
Interesting Ivan
And a cycle backup/restore doesn't force each row to keep in a single page?
If having a row in several pages causes bad performance it has sense trying
to keep that rows as grouped as possible. Or not?
Greetings.
Walter.
On Thu, May 2, 2013 at 11:11 AM, Ivan Přenosil
when it is doing a restore.
Greetings.
Walter.
On Thu, May 2, 2013 at 1:59 PM, Ann Harrison aharri...@ibphoenix.comwrote:
**
On Thu, May 2, 2013 at 11:23 AM, W O sistemas2000profesio...@gmail.com
wrote:
And a cycle backup/restore doesn't force each row to keep in a single
page
Hello Ann:
As I understand it when a record is deleted a new primary version with a
mark (a flag) is put on it indicating that fact and the previous version of
the record is copied on another location (same page if there is room or
another page if there is not)
Is that true?
Greetings.
Walter.
Hello Norman
It would be possible for me to download that manual?
Can you tell me the link?
Greetings.
Walter.
On Wed, May 1, 2013 at 11:12 AM, Norman Dunbar nor...@dunbar-it.co.ukwrote:
**
On 01/05/13 15:53, Norman Dunbar wrote:
I'll reword the manual. ASAP.
The gbak manual has
Ann: So, if I am understanding well: the 80%-20% usage is not true?
Norman: Thank you very much, I had downloaded the 1.10 version.
Greetings.
Walter.
On Wed, May 1, 2013 at 11:37 AM, Ann Harrison aharri...@ibphoenix.comwrote:
**
Norm,
The default (ie, if you leave this parameter
Hello everybody:
After reading in this article:
http://www.firebirdfaq.org/faq3/
Alternatively, you can add a second server to do long running reports
(OLAP) and keep Super Server for fast transactions (OLTP).
it seems possible and desirable to have 2 Servers, one for long running
reports
Ok, thanks, it is more clear now.
Where I can find more information about OLAP and OLTP, some link you can
recommend me?
Greetings.
Walter.
On Fri, Apr 26, 2013 at 9:51 AM, Mark Rotteveel m...@lawinegevaar.nlwrote:
**
On Fri, 26 Apr 2013 09:37:19 -0400, W O
sistemas2000profesio
Rotteveel m...@lawinegevaar.nl
wrote:
**
On Fri, 26 Apr 2013 09:37:19 -0400, W O
sistemas2000profesio...@gmail.com
wrote:
Hello everybody:
After reading in this article:
http://www.firebirdfaq.org/faq3/
Alternatively, you can add a second server to do long running reports
:37:19 -0400, W O
sistemas2000profesio...@gmail.com
wrote:
Hello everybody:
After reading in this article:
http://www.firebirdfaq.org/faq3/
Alternatively, you can add a second server to do long running
reports
(OLAP) and keep Super Server for fast transactions (OLTP
at 9:51 AM, Mark Rotteveel m...@lawinegevaar.nl
wrote:
**
On Fri, 26 Apr 2013 09:37:19 -0400, W O
sistemas2000profesio...@gmail.com
wrote:
Hello everybody:
After reading in this article:
http://www.firebirdfaq.org/faq3/
Alternatively, you can add a second server to do long
Hello everybody
Since some days ago I have a blog about Firebird, this is the link:
http://firebird21.wordpress.com
(All the articles are in Spanish)
Any comment or advise will be welcomed.
Greetings.
Walter.
[Non-text portions of this message have been removed]
Always the database should be in the same computer where the Firebird
Server was installed. Mapped drives doesn't work.
Greetings.
Walter.
On Tue, Mar 5, 2013 at 9:43 PM, Alexandre Benson Smith
ibl...@thorsoftware.com.br wrote:
**
Em 5/3/2013 22:21, bluewindow99 escreveu:
I'm just
Hello Marianne
How do you use fbclone?
It is a command-line tool, but I can not find its documentation, just the
syntax.
Greetings.
Walter.
On Mon, Mar 4, 2013 at 11:08 AM, caste...@titelive.be wrote:
**
Hello,
I turned my Firebird 1.5 database into Firebird 2.5 database
Hello Mark
Thank for your answer.
But the strange thing is that PER_IDENTI is the Primary Key and ORDER BY
seems not use it.
Greetings.
Walter.
On Fri, Mar 1, 2013 at 4:18 AM, Mark Rotteveel m...@lawinegevaar.nl wrote:
**
On Fri, 1 Mar 2013 00:37:26 -0400, W O sistemas2000profesio
Hello Mateusz
But PER_IDENTI is the Primary Key, why Firebird needs a two-pass proccess?
Greetings.
Walter.
On Fri, Mar 1, 2013 at 5:51 AM, Mateusz Loskot mate...@loskot.net wrote:
**
On 1 March 2013 04:37, W O sistemas2000profesio...@gmail.com wrote:
Somebody knows why
:
**
On Fri, 1 Mar 2013 08:32:09 -0400, W O sistemas2000profesio...@gmail.com
wrote:
But the strange thing is that PER_IDENTI is the Primary Key and ORDER BY
seems not use it.
As Firebird is retrieving all rows anyway, there is - AFAIK - no benefit
to use the primary key index
are the Primary Keys
UQ_ are the Unique Keys
Greetings.
Walter.
On Fri, Mar 1, 2013 at 8:46 AM, Dmitry Yemanov dim...@users.sourceforge.net
wrote:
**
01.03.2013 8:37, W O wrote:
I have a table with 3.600.000 rows more or less.
Writing:
SELECT * FROM V_ABM_PERSONAS V
);
Greetings.
Walter.
On Fri, Mar 1, 2013 at 9:23 AM, W O sistemas2000profesio...@gmail.comwrote:
Hello Dmitry
Writing:
SELECT * FROM V_ABM_PERSONAS V WHERE V.PER_IDENTI 0 ROWS 1 TO 100
The plan is:
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (V P ORDER UQ_PERSONAS1 INDEX
(PK_PERSONAS), V D INDEX
!!!
Greetings.
Walter.
On Fri, Mar 1, 2013 at 9:31 AM, Mark Rotteveel m...@lawinegevaar.nl wrote:
**
On Fri, 1 Mar 2013 09:29:55 -0400, W O sistemas2000profesio...@gmail.com
wrote:
The view V_ABM_PERSONAS is:
CREATE VIEW V_ABM_PERSONAS(
PER_IDENTI,
...
FROM
PERSONAS P
Ok, it is clear now: better is never to use the ORDER BY clause in a view,
that avoid problems.
Every day I learn something new.
Greetings.
Walter.
On Fri, Mar 1, 2013 at 12:39 PM, Mark Rotteveel m...@lawinegevaar.nlwrote:
**
I guess that the use of ORDER BY applied on VIEWS is ok.
No, it is not the case. I use ODBC driver and question marks in many
applications, without a problem.
Greetings.
Walter.
On Wed, Feb 27, 2013 at 2:18 PM, Kurt Fitzner kurt.fitz...@gmail.comwrote:
**
Hello,
I am trying to use Firebird as a back end for LibreOffice Base. I have
Somebody knows why there are a difference so big?
I have a table with 3.600.000 rows more or less.
Writing:
SELECT * FROM V_ABM_PERSONAS V WHERE V.PER_IDENTI 0 ROWS 1 TO 100
takes 2.656 seconds (less than 3 seconds)
Writing:
SELECT * FROM V_ABM_PERSONAS V ORDER BY V.PER_IDENTI ROWS 1 TO 100
Hello everybody
Just a question because I have the doubt: if a table or stored procedure is
changed, it creates a delta row?
When an user updates a row a delta row is created, so adding garbage to the
database, the same thing happens when the structure of a table is changed?
Thanks in advance.
Martijn, can you send that presentation to me, too?
I'm very interested.
Greetings.
Walter.
On Thu, Feb 14, 2013 at 8:19 AM, Martijn Tonies m.ton...@upscene.comwrote:
**
Hello Michael,
I'll send you one of my old presentations about the system tables.
With regards,
Martijn Tonies
$foreign_key
INNER JOIN rdb$index_segments to_field ON to_table.rdb$index_name =
to_field.rdb$index_name
WHERE from_table.rdb$foreign_key IS NOT NULL
;
these are what we use most ofteni hope i made someone's life easier a
bit :)
Cheers,
Szilvi
From: W O
Hello everybody
Do you know what is the cause of this error message and how resolve it?
After a ROLLBACK the message:
'OLE IDispatch 0 de ibeole.TIBOLECommand: violation of FOREIGN KEY
constraint FK_HISTORICOFAC_1 on table HISTORICOFAC number of
transactions per sweep required.'
is showed.
We
1 - 100 of 174 matches
Mail list logo