[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
2015-10-06
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-10-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-10-30
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
-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
2015-11-02
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-12-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2015-12-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-12-26
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2016-01-02
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
Re: [firebird-support] Database design. Simple question!
2016-07-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2016-11-28
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2016-12-12
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2016-12-13
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-08
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-08
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-08
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-10
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-15
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-15
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-15
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-16
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2017-02-16
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2017-04-14
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
. Greetings. Walter.
[firebird-support] How to get the the tables and the columns of a Foreign Key?
2017-05-29
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
advance. Greetings. Walter.
Re: [firebird-support] How to get the the tables and the columns of a Foreign Key?
2017-05-30
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2017-10-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2018-01-02
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2018-01-02
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
, 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
2018-01-02
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2018-03-17
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2018-03-17
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2018-03-17
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2018-03-17
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2018-03-17
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2020-11-19
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2020-11-19
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2020-11-19
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2020-11-20
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2020-11-24
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2020-11-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2014-10-12
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2014-10-12
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2014-10-12
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2014-11-17
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2014-11-19
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-11-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-11-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2014-12-04
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2014-12-16
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-12-24
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-12-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-12-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-12-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-12-26
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-12-28
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2014-12-29
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-01-23
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-02-03
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
ssible to use parentesis? Firebird 2.5.2, SuperServer Greetings. Walter.
Re: [firebird-support] Multiple WHERE clauses
2015-02-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-03-19
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-03-24
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-03-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-04-04
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-04-23
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-04-23
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-04-23
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-04-24
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
. 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
2015-04-25
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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 ***"
2015-05-23
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
: 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
2015-05-26
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-05-26
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-06-19
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-06-20
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-07-10
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-07-14
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
¿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
2015-07-14
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-06
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-07
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-08
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2015-08-14
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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?
2015-08-15
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-20
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
... 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
2015-08-21
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-21
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-21
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-22
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-24
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-24
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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
2015-08-24
Thread
'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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.