[firebird-support] ODBC Connection on Windows 7 - 64 bit

onifugration is working perfectly on another pc running 32 bit verions of Windows 7 Pro and Firebird ODBC. What can be wrong ? Thanks Walter [Non-text portions of this message have been removed]

[firebird-support] Re: ODBC Connection on Windows 7 - 64 bit

try to check the connection in the ODBC configuration panel of Windows 7. --- In firebird-support@yahoogroups.com, Helen Borrie wrote: > > At 02:30 AM 30/09/2011, Walter wrote: > > >Hi, I'm trying to set up an ODBC connection on Windows 7 Pro (installed > >driver using F

[firebird-support] Aliases and Windows 7

I had to use a Windows 7 machine as Firebird server...after updating firewall rules everything is ok, but Firebird seems to ignore the aliases.conf file...I place the fdb file in a shared folder, with full access granted to everyone, and create the alias. I can access the database locally provid

[firebird-support] Re: Aliases and Windows 7

--- In firebird-support@yahoogroups.com, Dmitry Kuzmenko wrote: > > Hello, Walter! > > Thursday, May 30, 2013, 3:20:13 PM, you wrote: > > W> I had to use a Windows 7 machine as Firebird server...after > W> updating firewall rules everything is ok, but F

[firebird-support] Re: Aliases and Windows 7

Hi, this is the path of the fdb file: C:\Users\Desy\Documents\FB this is the aliases.conf (on the server machine): XFILES = C:\Users\Desy\Documents\FB\XFILES.FDB the error occours both with local or remote access. For example, I had Firebird installed on a Windows 2003 machine (named AD2K3), w

[firebird-support] Re: Aliases and Windows 7

The solution in this case was more simple than I could imagine. For some reason I don'know there are two firebird folders, one inside the "c:\program files" folder and another one inside the "c:\program files(x86)" one, even if I was sure to have used the default directory of the installation pr

[firebird-support] Re: Aliases and Windows 7

You could be right...I was in the middle of a disaster recovery operation, and I could have missed it. Sorry again --- In firebird-support@yahoogroups.com, Mark Rotteveel wrote: > > On 3-6-2013 18:56, Walter wrote: > > The solution in this case was more simple than I could imagi

Re: [firebird-support] Order by

Germán, as you can read Spanish, this article can be useful: https://firebird21.wordpress.com/2014/11/20/mostrando-los-resultados-ordenados-por-cualquier-criterio/ Greetings. Walter. On Tue, Oct 6, 2015 at 6:17 PM, Germán Balbi bal...@yahoo.com [firebird-support] wrote: > > >

Re: [firebird-support] Order by

Ok Germán. Just for your advice, we have a forum too, you can ask your questions there in Spanish, Portuguese or English. It is about Firebird, SQL and database design. Usually you receive an answer in the next 24 hours. http://yoforeo.com/firebird21 Greetings. Walter. On Wed, Oct 7, 2015

Re: [firebird-support] Sort hierarchical data

-saldos-acumulados/ https://firebird21.wordpress.com/2015/09/05/ejemplo-de-recursion-6-repitiendo-las-filas/ Greetings. Walter. On Wed, Oct 21, 2015 at 6:37 AM, josef.gschwendt...@quattro-soft.de [firebird-support] wrote: > > > Hi, > > I have a table with hierarchical > da

Re: [firebird-support] Writing to Aliases.conf in non-admin mode

Well, the more easy answer is not install Firebird under the folder "Program files", because Windows since its Vista version has protected that folder. You can install Firebird in C:\FIREBIRD\ or something so and no problems writing to any of its files. Greetings. Walter. On S

Re: [firebird-support] error writing data to the connection

with the Server, use Classic, not SuperServer. You can download a .ZIP file from FIREBIRDSQL.ORG, there are .BAT files there that you can use for run the Server. Greetings. Walter. On Sun, Dec 20, 2015 at 4:18 AM, arash_iranb...@yahoo.com [firebird-support] wrote: > > >

Re: [firebird-support] Numeration without hole, Is right Before Insert Trigger?

Hello Luigi If you can read Spanish, this article can be useful: https://firebird21.wordpress.com/2014/09/11/algo-mas-sobre-transacciones-optimistas-y-transacciones-pesimistas/ Greetings. Walter. On Thu, Dec 24, 2015 at 7:05 AM, Svein Erling Tysvær setys...@gmail.com [firebird-support

Re: [firebird-support] access column by column name

You can use EXECUTE STATEMENT for that. Greetings. Walter. On Sat, Dec 26, 2015 at 1:50 PM, slucas slu...@iquanta.com [firebird-support] wrote: > > > hello one and all, > > i would like to write a stored procedure which looks something like: > > CREATE PROCEDURE IC_I

Re: [firebird-support] Update table column from another table

Floating point values are not exact values, there is not guarantee. If you need exact values, use NUMERIC or DECIMAL instead. Greetings. Walter. On Sat, Jan 2, 2016 at 11:28 AM, Sonya Blade sonyablade2...@hotmail.com [firebird-support] wrote: > > > > Yes I tried that it wasn&#x

Re: [firebird-support] Database design. Simple question!

To have a separate table for a single column is a good idea if the column will be of type BLOB and will be used just sometimes. Greetings. Walter. On Mon, Jul 25, 2016 at 5:51 PM, shg_siste...@yahoo.com.ar [firebird-support] wrote: > > > Hello! I have a FB 2.5 database wit

Re: [firebird-support] Speed of comparing one field to another

to create a trigger. Greetings. Walter. On Tue, Sep 13, 2016 at 9:26 AM, Maya Opperman m...@omniaccounts.co.za [firebird-support] wrote: > > > Hi, > > > > I have a large table, and I’m only extracting a few records using: > > > > Select t.ID > > From my

[firebird-support] Data pages and data page slots

where I can find information? Mr Google was not polite with me. Of course, I know a cycle backup/restore put both numbers equals, but ... is that the only way? or I can make "data pages" equal to "data page slots" without a cycle backup/restore? Greetings. Walter.

Re: [firebird-support] Re: Data pages and data page slots

Thank you very much Vlad, that is what I was thinking but always is very better to have the explanation of one expert. Greetings. Walter. On Tue, Dec 13, 2016 at 11:25 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In firebird-support@yahoogroups.com, > wrote

[firebird-support] Is this a bug of Firebird?

seems a bug for me. Or there are some reasons for allowing to do such thing? Of course, the fault is of the programmer, but it can be detected at compilation time. Firebird version: 2.5.5 Greetings. Walter.

Re: [firebird-support] Is this a bug of Firebird?

Yes, but I can not know the value of the column X.ALU_NOMBRE And the idea, of course, is know that value, that's why it appears in the FOR SELECT. If not, I can do nothing with X.ALU_NOMBRE Greetings. Walter. On Wed, Feb 8, 2017 at 12:02 PM, Dimitry Sibiryakov s...@ibphoenix.com [fir

Re: [firebird-support] Is this a bug of Firebird?

thing. Or not? Greetings. Walter. On Wed, Feb 8, 2017 at 2:36 PM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > > > > Yes, but I can not know the value of the column X.ALU_NOMBRE > > > > And the idea, of course, is know that v

Re: [firebird-support] Is this a bug of Firebird?

too, the programmer can have a hard time detecting the problem. Greetings. Walter. On Thu, Feb 9, 2017 at 12:19 PM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > Doug, > > > Delphi's latest compiler provides a hint in these cases: >

[firebird-support] Is there an easy way for input rows from a script file?

connect to "Database2", which also have a table called "MyTable" and with the same structure. After that, I want to insert into "MyTable" (of "Database2") the rows contained in "MyFile.DAT" How can I do such thing without a lot of effort writing an INSERT command in each line of "MyFile.DAT"? Greetings. Walter.

Re: [firebird-support] Is there an easy way for input rows from a script file?

Thank you very much Set, I will try your advice. Off topic: can you say me what the letters HTH means? Greetings. Walter. On Wed, Feb 15, 2017 at 6:31 PM, setysvar setys...@gmail.com [firebird-support] wrote: > > > Den 15.02.2017 17:07, skrev 'Walter R.

Re: [firebird-support] Is there an easy way for input rows from a script file?

Thank you, Sean Greetings. Walter. On Wed, Feb 15, 2017 at 6:43 PM, 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] wrote: > > > Walter, > > > If I connect to a database "Database1" using ISQL, I can write something > like: > > &

Re: [firebird-support] Re: Is there an easy way for input rows from a script file?

Thank you Vlad, but is not for me, is for an article of my blog, I am showing the alternatives for exporting data. firebird21.wordpress.com Greetings. Walter. On Thu, Feb 16, 2017 at 3:44 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > ---In firebird-support@yahoog

Re: [firebird-support] Is there an easy way for input rows from a script file?

Thank you Set, now I know the meaning of HTH. Greetings. Walter. On Thu, Feb 16, 2017 at 4:09 AM, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > > > HTH = Hope this (alternatively: that) helps > > 2017-02-16 3:06 GMT+01:00 'Walter R. Ojeda Valiente

[firebird-support] Entity Relationship Diagram

. Greetings. Walter.

[firebird-support] How to get the the tables and the columns of a Foreign Key?

advance. Greetings. Walter.

Re: [firebird-support] How to get the the tables and the columns of a Foreign Key?

Thank you very much SET. Yes, it will be useful. No exactly what I was looking for but good enough for know the names of the tables and the columns involved. Greetings. Walter. On Tue, May 30, 2017 at 3:38 AM, Svein Erling Tysvær setys...@gmail.com [firebird-support] wrote: > > >

[firebird-support] Connected databases to the Server

Hello everyone There is some way to know which databases are connected actually at the Server? Maybe 3 databases are connected now, or maybe 17, or maybe 83, how can I know that? Which databases are connected, right now? Thanks in advance. Greetings. Walter. <https://www.avast.com/

Re: [firebird-support] Connected databases to the Server

Doesn't work, always shows just 1 database, the current one. Sometimes with several instances, but always the same database name. Greetings. Walter. On Sun, Oct 8, 2017 at 5:25 AM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 07.10.2017 22:57, 'Walter R. O

Re: [firebird-support] detect if database has changed

, if you are interested in 20 tables, your table CHANGES will have 20 rows. The problem will be the frequents deadlocks if you don't manage well your transactions. Greetings. Walter. On Mon, Oct 9, 2017 at 5:06 AM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: >

Re: Re[2]: [firebird-support] select column if it exists

What about: SELECT A, B, COALESCE(C, 'some value here') FROM MyTable Greetings. Walter. On Tue, Oct 10, 2017 at 2:56 PM, 'Daniel Miller' dmil...@amfes.com [firebird-support] wrote: > > > I don't think you could express it in the SELECT dire

[firebird-support] Impossible to create a new database from a script

a team's work and people needs to read those comments. So, there is a solution? Is this a bug of Firebird? Somebody knows how to solve this problem? Thanks in advance. Walter. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_cont

Re: [firebird-support] Impossible to create a new database from a script

use ISO8859_1, no UTF8. After a database is created with the UTF8, is it possible to change its character set to ISO8859_1? Thanks in advance. Walter. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. ww

Re: [firebird-support] Impossible to create a new database from a script

ABASE. Thanks a lot for your help, case solved and closed. Greetings. Walter. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&ut

Re: [firebird-support] Impossible to create a new database from a script

Thank you Dimitri for your answer. Greetings. Walter. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_c

Re: [firebird-support] Impossible to create a new database from a script

ned. The solution was to write SET NAMES ISO8859_1; before the CREATE DATABASE statement and execute the script file with ISQL, no with EMS SQL MANAGER, because it always stop in the lines with comments. But with the INPUT command of ISQL.EXE it works fine. Anyway, the problem is solved. Greetin

[firebird-support] UPDATE OR INSERT in Firebird 3

new IDENTITY type in Firebird 3 I always have an error, writing MyColumn1 in the UPDATE OR INSERT or not writing. So, my question is: Is it possible to use UPDATE OR INSERT with an IDENTITY column? Thanks in advance. Greetings. Walter.

[firebird-support] Re: UPDATE OR INSERT in Firebird 3

I forget to say that my IDENTITY column is the Primary Key of MyTable, therefore if I don't write it an error happens because...the table needs a Primary Key. On Thu, Nov 19, 2020 at 8:52 PM Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > Hello everybody &g

[firebird-support] Re: UPDATE OR INSERT in Firebird 3

re is some solution? Or it is impossible to use an IDENTITY column with an UPDATE OR INSERT? Greetings. Walter. On Thu, Nov 19, 2020 at 8:55 PM Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > I forget to say that my IDENTITY column is the Primary Key of MyTabl

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

u very much for your answer. Greetings. Walter. On Fri, Nov 20, 2020 at 6:16 AM Herman Viaene herman.via...@edpnet.be [firebird-support] wrote: > > > Op 20/11/2020 om 01:04 schreef 'Walter R. Ojeda Valiente' > sistemas2000profesio...@gmail.com [firebird-support]: > >

Re: [firebird-support] Re: UPDATE OR INSERT in Firebird 3

INSERT and UPDATE too. Fewer lines of code are a good practice according to my point of view. Greetings. Walter. On Tue, Nov 24, 2020 at 3:32 PM Daniel Miller dmil...@amfes.com [firebird-support] wrote: > > > I experimented with IDENTITY fields myself - based on my experience and >

Re: [firebird-support] UPDATE OR INSERT in Firebird 3

only problem I have found with Firebird 3 is that IDENTITY columns can not be used with UPDATE OR INSERT. Greetings. Walter. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Libre de virus. www.avast.com <https

[firebird-support] Number of the Next Transaction

not 3? Why after a SELECT the OIT, OAT and OST had changed so much? Someone can explain me? Thanks in advance. Greetings. Walter.

Re: [firebird-support] Re: Number of the Next Transaction

be 3 or a number very close to 3. Why it was 304? Greetings. Walter. On Sun, Oct 12, 2014 at 3:47 PM, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > > > 12.10.2014 23:25, 'Walter R. Ojeda Valiente' wrote: > > > I can not understand th

Re: [firebird-support] Re: Number of the Next Transaction

Thank you very much again Dmitry. I now understand. It is very clear now. Greetings. Walter. On Sun, Oct 12, 2014 at 4:58 PM, Dmitry Yemanov dim...@users.sourceforge.net [firebird-support] wrote: > > > 13.10.2014 00:22, 'Walter R. Ojeda Valiente' wrote: > > >

Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic

Hmmm, database dialect is 1. No issues with that? Greetings. Walter. On Mon, Nov 17, 2014 at 7:41 AM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] wrote: > > > > Isnt the transaction per second wrongly calculated? > > Oops, sorry!!! I hav

Re: [firebird-support] Selecting arbitrary records in an arbitrary order

Hello Caroline If you can read Spanish, then at this article: http://firebird21.wordpress.com/2013/11/10/enviando-y-recibiendo-una-cantidad-variable-de-parametros-en-los-stored-procedures/ you will see a technique for achieving that you want. Greetings. Walter. On Wed, Nov 19, 2014 at 5:50

Re: [firebird-support] Why this similar to is wrong?

at is not perfect, but works. Greetings. Walter. On Tue, Nov 25, 2014 at 9:29 AM, sirhamac...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > select > >iif('em...@testdomain.com' similar to > '([_a-zA-Z\d\-\.]+@[_

Re: [firebird-support] Why this similar to is wrong?

Yet more simple: SELECT IIF('em...@testdomain.com' SIMILAR TO '[[:ALNUM:]-_.]*@[[:ALNUM:]-_.]*', 'ok', 'fail') FROM RDB$DATABASE Greetings. Walter. On Tue, Nov 25, 2014 at 10:48 AM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.c

Re: [firebird-support] Question about a package

He also can have several versions of Firebird running on the same computer. Of course using different ports. Greetings. Walter. On Thu, Dec 4, 2014 at 5:06 AM, Markov Dmitri markovdmi...@yahoo.com [firebird-support] wrote: > > > Hi! > I can't answer on your question, but di

Re: [firebird-support] Re: performance of subselect with group by

Well done Set Greetings. Walter. On Tue, Dec 16, 2014 at 4:30 PM, Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > > >> I don't think there is any simple way to make a delete with a >

Re: [firebird-support] Re: Deadlock exception occurs but it shouldn't?

transaction T1 blocks a row and after that transaction T2 wants to update that row then transaction T2 will wait. But if transaction T2 blocks a row and after that transaction T1 wants to update that row will have a deadlock. Greetings. Walter. On Wed, Dec 24, 2014 at 10:39 AM, brucedickin

Re: [firebird-support] Re: Deadlock exception occurs but it shouldn't?

Hello Bruce Yes, transaction T1 can block a row and transaction T2 will wait. But if transaction T2 blocks a row then transaction T1 can not wait and dead. Greetings. Walter. On Thu, Dec 25, 2014 at 7:27 AM, brucedickin...@wp.pl [firebird-support] < firebird-support@yahoogroups.com>

Re: [firebird-support] Re: Deadlock exception occurs but it shouldn't?

Strange, I will test it, too. Maybe I have a misconcept. Greetings. Walter. On Thu, Dec 25, 2014 at 11:36 AM, brucedickin...@wp.pl [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Walter, > > I've tested what you've said. But it does not mat

Re: [firebird-support] Re: Deadlock exception occurs but it shouldn't?

Yes, you are right. I had a misconcept. Sorry. Greetings. Walter. On Thu, Dec 25, 2014 at 12:00 PM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > Strange, I will test it, too. Maybe I have a misconcept. > > Greetings. > > Walter. > > >

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

e I can update the record. Greetings. Walter. On Fri, Dec 26, 2014 at 6:15 PM, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > > > On Dec 24, 2014, at 3:22 AM, brucedickin...@wp.pl [firebird-support] < > firebird-support@yahoogroups.com> wrote: &g

Re: [firebird-support] Deadlock exception occurs but it shouldn't?

Vlad, your explanation is very good, but I still don't understand something: Why before step 1 the engine does not blocks the record avoiding such problem? Greetings. Walter. On Sat, Dec 27, 2014 at 5:19 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > Upda

Re: [firebird-support] Re: Deadlock exception occurs but it shouldn't?

Thank you for your explanation Vlad, the proccess is more clear for me now. Greatings. Walter. On Mon, Dec 29, 2014 at 4:55 AM, hv...@users.sourceforge.net [firebird-support] wrote: > > > Walter, > > there are few reasons: > > a) MVCC engine never block records - it jus

Re: [firebird-support] Unlock record

ISQL1. ISQL2 absolutly ignores that happens in the ISQL1 instance. Is there a way to know in ISQL2 the transaction's data started by ISQL1? Version 2.5.2, SuperServer, Windows 7 Greetings. Walter. On Thu, Jan 22, 2015 at 1:50 PM, Svein Erling Tysvær svein.erling.tysv...@kreftreg

[firebird-support] Problem with a trigger

ssible to use parentesis? Firebird 2.5.2, SuperServer Greetings. Walter.

Re: [firebird-support] Multiple WHERE clauses

Sean: Which is the difference between it: WHERE 1 = CASE WHEN (Param <> 0) THEN 1 WHEN (Some OtherTest) THEN 1 WHEN (Yet another Test) THEN 1 ELSE 0 END and it: Param <> 0 OR SomeOtherTest OR YetAnotherTest ? Because I get the same result with both ways. Greetings. Walter. On

Re: [firebird-support] Get/set context in derived table context

If you can read Spanish, this article shows several methods for having row numbers in the SELECT. https://firebird21.wordpress.com/2013/05/13/numerando-las-filas-de-un-select/ Greetings. Walter. On Thu, Mar 19, 2015 at 5:28 AM, masb...@za-management.com [firebird-support] wrote: > >

Re: [firebird-support] Re: Awaiting Garbage Collector

much for such presentation. I have just one doubt, and it is with page 46. Can you explain me that page, please? Thanks in advance. Walter. On Mon, Mar 23, 2015 at 8:27 AM, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > > > Hi, > > Unfortunately, your expe

Re: [firebird-support] Re: Awaiting Garbage Collector

Tx14 did although Tx14 is still active? These things had confused me. Of course, I think that I am not understanding rightly the graph, that's why some words can help to do it clear. Greetings. Walter. On Wed, Mar 25, 2015 at 5:10 AM, Alexey Kovyazin a...@ib-aid.com [firebird-support] w

Re: [firebird-support] Re: Awaiting Garbage Collector

Thank you very much for your answer Alexey, I was very bussy these days. Looking at the page 46 it seems more understandable now. Greetings. Walter. On Wed, Mar 25, 2015 at 2:02 PM, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > > > Hi Walter, > > On s

Re: [firebird-support] Test VARCAHR for numeric

ordpress.com/2014/04/27/usando-similar-to/ https://firebird21.wordpress.com/2014/11/25/validando-un-e-mail/ Greetings. Walter. On Thu, Apr 23, 2015 at 2:34 PM, sboyd...@gmail.com [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Is there any way, within a store

Re: [firebird-support] Test VARCAHR for numeric

Sorry, typo in the SELECT, just one comma after MyColumn2. Greetings. Walter. On Thu, Apr 23, 2015 at 8:00 PM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > You can use SIMILAR TO, something like it: > > SELECT >MyColumn1, >MyColumn2,,

Re: [firebird-support] Test VARCAHR for numeric

Again, if you can read Spanish then the following article has more examples: https://firebird21.wordpress.com/2015/04/23/validando-que-el-contenido-de-un-char-o-varchar-sea-numerico/ Greetings. Walter. On Thu, Apr 23, 2015 at 8:03 PM, Walter R. Ojeda Valiente < sistemas2000profe

Re: [firebird-support] Test VARCAHR for numeric

. Walter. On Fri, Apr 24, 2015 at 2:53 AM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On Thu, 23 Apr 2015 20:00:32 -0400, "'Walter R. Ojeda Valiente' > sistemas2000profesio...@gmail.com [firebird-support]" > wrote: > >

Re: [firebird-support] Test VARCAHR for numeric

Very interesting Mark, I shall remember that for the time when Firebird3 is coming here. Greetings. Walter. On Sat, Apr 25, 2015 at 3:14 AM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > > > On 25-4-2015 08:08, 'Walter R. Ojeda Valiente' > sistemas200

Re: [firebird-support] GBAK - validation error for column X, value "*** null ***"

: https://firebird21.wordpress.com/2013/03/05/backup-y-restauracion-al-mismo-tiempo/ Greetings. Walter. On Fri, May 15, 2015 at 4:41 AM, Josef Kokeš j.ko...@apatykaservis.cz [firebird-support] wrote: > > > Hi! > > Thanks for the answer. Luckily, I still have the FDB file, so I can g

Re: [firebird-support] Database restore speed with IBExpert and Gbak

Hello Thomas That seems an interesting idea. Can you explain it with more details? Greetings. Walter. On Tue, May 26, 2015 at 12:25 PM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: > > > Halim, > > > Thank you for your reply. > > I just tested

Re: [firebird-support] Database restore speed with IBExpert and Gbak

Thank you very much, Thomas. Very useful. Greetings. Walter. On Tue, May 26, 2015 at 1:02 PM, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: > > > Hello Walter, > > > Hello Thomas > > > > That seems an interesting idea. Can you explain it

Re: [firebird-support] Altering a domain

Excellent explanation Ann, as always. Just one doubt: After a cycle backup/restore: the restored database will have all the rows with the new domain? All columns with domain D_CURRENCY that were created with DECIMAL(9, 2) now will be DECIMAL(18, 2) ? Greetings. Walter. On Tue, Jun 16, 2015

Re: [firebird-support] Altering a domain

Thank you Ann. Greetings. Walter. On Sat, Jun 20, 2015 at 9:04 AM, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > > On Jun 19, 2015, at 3:32 PM, 'Walter R. Ojeda Valiente' > sistemas2000profesio...@gmail.com [firebird-support] < >

[firebird-support] Firebird 3, execution modes

and Database2 using SuperClassic, it is impossible with just one instance of FIREBIRD.EXE ¿Am I right? Greetings. Walter.

[firebird-support] Re: Firebird 3, execution modes

¿Nobody has answers to my questions? Greetings. Walter. On Fri, Jul 10, 2015 at 10:39 PM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > Reading the excellent (as usual) document of Helen Borrie: Firebird 3.0 > Release Notes (for Firebird 3.0 Beta 2) I had

Re: [firebird-support] Re: Firebird 3, execution modes

Ah, ok, I don't knew that. Thank you for the info. Greetings. Walter. On Tue, Jul 14, 2015 at 10:50 AM, 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support] wrote: > > > You might get a quicker response on firebird-devel. Questions about beta > version

[firebird-support] Knowing the previous rows

ID 1234, it would be great a SELECT which show me something like that: 1234 INSERT COMMIT 1234 UPDATE COMMIT 1234 UPDATE ROLLBACK 1234 UPDATE COMMIT 1234 UPDATE COMMIT 1234 UPDATE COMMIT Saying me some "story" of that row. Is that possible? Thanks in advance. Greetings. Walter.

Re: [firebird-support] Knowing the previous rows

tings. Walter. On Fri, Aug 7, 2015 at 1:32 AM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > > > Hi, > > What about triggers? > > Regards, > Karol Bieniaszewski > > > Oryginalna wiadomość > Od: "'Walter R

Re: [firebird-support] Knowing the previous rows

Thank you Ann, I shall investigate that. Greetings. Walter. On Fri, Aug 7, 2015 at 1:10 PM, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > > > The idea is to know how many garbage a table has. Or several tables. Or > the whole database. > &

Re: [firebird-support] Knowing the previous rows

Well, after run GSTAT and reading the output I can see how many garbage a whole table has, but it don't shows me the "story" of a row. ¿How many COMMITs and how many ROLLBACKs the row with ID 1234 of the table CLIENTS had had? Greetings. Walter. On Fri, Aug 7, 2015 at 1:42 PM,

Re: [firebird-support] Knowing the previous rows

E add garbage to the database so I try to avoid using those commands and so all works fine. Happy users, happy my employees, happy me. :-) But I have a blog about Firebird and one reader did that question and as I don't knew the answer was curious. Greetings. Walter. On Fri, Aug 7, 2015

[firebird-support] Problem with AUTONOMOUS TRANSACTION

crash. Without those words everything works fine. It is not possible to use autonomous transactions inside a database trigger? The same problem happens with SuperServer and Classic. Windows 7, 32 bits Firebird 2.5.4 Greetings. Walter.

Re: [firebird-support] Problem with AUTONOMOUS TRANSACTION

Ha, ha, ha, ha, ha, ha, ha, ha. Thank you very much Helen, sometimes the memory is not so good as was some years ago. Ok, I now know and hope not forget again: "NEVER USE IN AUTONOMOUS TRANSACTION INSIDE A TRANSACTION RELATED DATABASE TRIGGER". Greetings. Walter. On Fri, Aug 7, 201

Re: [firebird-support] Knowing the previous rows

TeamViewer or similar is not the best option because it is still a waste of time. I don't like receive calls of clients complaining about something. Happy clients means more money, today or later. So, all my applications should be good in all senses. Greetings. Walter. On Sat, Aug 8, 2015 at

Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

Hello Set Why writing: PP.STATUS_CODE || '' will improve the SELECT, can you explain me? As far I know, adding '' is for use NATURAL in the PLAN, why the use of NATURAL will do a better response time? Thanks in advance. Greetings. Walter. On Thu, Aug 13, 2015 at 4:4

Re: [firebird-support] What is the best way to re-write this Stored Procedure that seems to be SLOW processing?

point of view. Of course that NATURAL is the faster way when you want read all the rows of a table, but going from 2 hours and 45 minutes to 12 minutes is a extremely great improvement and I was very interested for understand the reason. Greetings. Walter. On Sat, Aug 15, 2015 at 9:42 AM, set

[firebird-support] Differences when adding a Primary Key

... Why sometimes the first case fails and the second case always work? Of course that the table has not a Primary Key yet and the ID column has not nulls neither duplicated values. But (just sometimes) the first case fails. Greetings. Walter.

[firebird-support] Re: Differences when adding a Primary Key

Nobody knows? Nobody has any idea? Greetings. Walter. On Thu, Aug 20, 2015 at 10:45 AM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > Hello everybody > > For add a Primary Key to a table we can write: > > ALTER TABLE MyTable ADD PRIMARY KEY (ID)

Re: [firebird-support] Re: Differences when adding a Primary Key

Hello Ricardo Thank you for your answer, but that is not the problem. Without using CONSTRAINT doesn't work and in such case the name is choosed by Firebird, not for me. Greetings. Walter. On Fri, Aug 21, 2015 at 1:43 PM, Ricardo Uzcategui ricardou...@cantv.net [firebird-support]

Re: [firebird-support] Re: Differences when adding a Primary Key

me is: both works or both fails, but why one fails and the other works? Greetings. Walter. On Fri, Aug 21, 2015 at 2:43 PM, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > > > > On Aug 21, 2015, at 2:13 PM, 'Walter R. Ojeda Valiente' > sistem

Re: [firebird-support] Re: Differences when adding a Primary Key

Nobody knows the answer? Well, then I shall add this to the "Firebird's mysteries". Greetings. Walter. On Fri, Aug 21, 2015 at 4:47 PM, Walter R. Ojeda Valiente < sistemas2000profesio...@gmail.com> wrote: > Hello Ann > > Well, the world has not falled out, n

Re: [firebird-support] Re: Differences when adding a Primary Key

Hello Ann Well, that was not the case, because without the word CONSTRAINT has failed and with that word has worked fine and I was the only user of the database at that moment. But no problem, I know the solution: always use the word CONSTRAINT. Greetings. Walter. On Sun, Aug 23, 2015 at

Re: [firebird-support] Re: Differences when adding a Primary Key

tings. Walter. On Sun, Aug 23, 2015 at 12:37 PM, liviusliv...@poczta.onet.pl [firebird-support] wrote: > > > Hi, > > have you sample database to reproduce this. > How you test this difference? Have you some backup of database and restore > it and then test this two opt

[firebird-support] Expression index for use with the GROUP BY clause

SORT there caused by the GROUP BY clause. ASI_ANOEJE is SMALLINT ASI_CODSUC is SMALLINT ASC_FECHAX is DATE ASI_NUMCUE is VARCHAR(16) ASI_NUMSUB is CHAR(5) I'm using Firebird 2.5.4 Greetings. Walter.

  1   2   >