Re: [firebird-support] Timestamp conversion issue

On 2016-04-05 10:47, Alex Castillo acr_k...@yahoo.com [firebird-support] wrote: > Hello everyone, > > I'm having some issues with a stored procedure. This is a legacy > development, so the time was stored in a varchar field and the date > in > a timestamp field. > > The issue stills happens after

Re: [firebird-support] What makes a database file size so big?

What page size do you use? Do you have a lot of blobs? If so what is the average size of those blobs? Mark - Bericht beantwoorden - Van: "Małgorzata Barchańska go...@fastdata.com.pl [firebird-support]" Aan: Onderwerp: [firebird-support] What makes a database file size so big? Datum: di

Re: [firebird-support] Re: UDF install in FB3.0 RC2

On 21-3-2016 09:19, russ...@belding.co.nz [firebird-support] wrote: > Thanks Vlad. I am failing with fb3 rc2 3.0.0.32366. > Yours is? > I will re-install and try again tomorrow. I believe you mentioned earlier that you were testing FB3 RC2 on a fresh install. Maybe the old UDFs require the presen

Re: [firebird-support] RECREATE Procedure issue.

On 2016-03-17 15:49, Joje j...@codework-solutions.com [firebird-support] wrote: > Hi All, >  I am facing a issue with 'RECREATE' procedure. > > Problem: > I have a stored procedure that uses 'RECREATE Procedure', this > procedure does not execute properly when executed in EMS SQL manager > for

Re: [firebird-support] Compiling stored procedure while database in production

On 2016-03-17 3:43, mailgro...@murdochfl.com [firebird-support] wrote: > I had a strange coincidence today, but Im wondering if it actually > may have been cause/effect instead. > > Im running fb_inet_server.exe 2.5.2.26539 on Windows 2008 Server. You are running an old Firebird version that has a

Re: [firebird-support] RECREATE Procedure issue.

On 2016-03-18 9:10, Joje j...@codework-solutions.com [firebird-support] wrote: > I am executing this query using my .net application and it is not > throwing any error. If there was a error then it would log that error > and will display it to the user. If it is not throwing an error, then I woul

Re: [firebird-support] Error with > 10 columns in SQL SELECT query using python firebirdsql

On 2016-03-17 5:54, ggoo...@yahoo.com [firebird-support] wrote: > I am querying a Firebird 1.5.3 database with python code using the > python firebirdsql module. All works well (query returns values as > expected) with up to 10 columns from two tables, but when I add an > 11th column I get the erro

Re: [firebird-support] RECREATE Procedure issue.

On 19-3-2016 11:51, j...@codework-solutions.com [firebird-support] wrote: > Regarding thus issue could someone raise a ticket & update the > documentation of firebird. You can create tickets at http://tracker.firebirdsql.org/browse/DOC Mark -- Mark Rotteveel

Re: [firebird-support] RECREATE Procedure issue.

On 19-3-2016 04:44, j...@codework-solutions.com [firebird-support] wrote: > If it's not executing then it should send a message. Also I referred the > site documentation of recreate procedure. But there was no specific info > about dependency in stored procedure. > > But later when I referred the d

Re: Re: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

On 2016-03-11 13:49, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: >>> 11.03.2016 12:59, liviuslivius liviusliv...@poczta.onet.pl >> [firebird-support] wrote: >> > > i can confirm this - database modified datatime is frozen when >> first connection has started. >> > > i suppos

Re: AW: Re: [firebird-support] timestamp of the firebird database (modified date) does not change in fb 3.0 RC2

On 2016-03-11 13:40, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hi, > > my third ticked within three days. What should I do, windows ticket? > E-Mail an microsoft? ;) It is expected behavior. See https://msdn.microsoft.com/en-us/library/windows/desktop/ms724290%28v=vs.85%29.asp

Re: [firebird-support] FB3 RC2 error with Flamerobin

On 9-3-2016 17:05, 'esdonisgarcia' esdonisgar...@sisconge.hol.es [firebird-support] wrote: >> On 6-3-2016 17:55, 'esdonisgarcia' esdonisgar...@sisconge.hol.es >> [firebird-support] wrote: >>> You can use a Flamerobin with FB3 RC2? >> >> Yes you can, but you need to make sure that you either use th

Re: AW: [firebird-support] coalesce bug in fb 3.0 rc2?

On 2016-03-09 7:57, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hello again, > > sorry, outlook corrects me in German. At the moment, I have no > sulution for the problem. Anything ideas? I think you should create a sample database to demonstrate this problem, and create a ticke

Re: [firebird-support] coalesce bug in fb 3.0 rc2?

On 2016-03-08 16:18, 'Checkmail' check_m...@satron.de [firebird-support] wrote: > Hello, > > in the further version of firebird I can execute the following and > get > the real value of m (exists in tlager_sum) > > select a.teilenr, a.bezeichnung, a.minb, coalesce(b.menge,0) as m, > a.typ > > fr

Re: [firebird-support] How write a query with a progressive sum field

On 2016-03-07 11:32, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 07.03.2016 11:16, Luigi Siciliano luigi...@tiscalinet.it > [firebird-support] wrote: >> How I do? > >sum(saldo) over (order by data) That only works with Firebird 3. Mark

Re: [firebird-support] FB3 RC2 error with Flamerobin

On 6-3-2016 17:55, 'esdonisgarcia' esdonisgar...@sisconge.hol.es [firebird-support] wrote: > You can use a Flamerobin with FB3 RC2? Yes you can, but you need to make sure that you either use the libfbclient.so of Firebird 3, or that you set the encryption setting to Enabled (or Disabled) instea

Re: [firebird-support] When do I need the FB 3 client libs?

On 2016-03-04 12:45, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > Hi, > > I wonder when to use the new client libs. For getting more concrete: > I > run a web server with apache using the FB 2.5 client libs to access > the FB 3.0 RC 2 server. Is that constellation OK or are

Re: [firebird-support] Re: Problems with connecting to Firebird 2.5.5 over TCP/IP on Linux (Ubuntu).

On 25 Feb 2016 08:29:14 -0800, "brucedickin...@wp.pl [firebird-support]" wrote: > @Mark I've tried 127.0.0.1 - the same error. > @Steve I've instaled xinetd (found some suggestions about that on > stackoverflow) > > I've run such command: > > root@john-VirtualBox:/etc/init.d# netstat -an |grep 3

Re: [firebird-support] Problems with connecting to Firebird 2.5.5 over TCP/IP on Linux (Ubuntu).

On 25 Feb 2016 08:15:12 -0800, "brucedickin...@wp.pl [firebird-support]" wrote: > Hello guys, > > could you be so kind and help me to diagnose problem with connecting to > Firebird on Ubuntu? I do not have experience with linux (haven't touched it > for years). Today I've installed Ubuntu on VM a

Re: [firebird-support] database formats?

On 24 Feb 2016 06:29:20 -0800, "heineferre...@yahoo.com [firebird-support]" wrote: > Hi, > > Is there any difference between the database format of a 32bit Firebird > database vs a 64bit Firebird database? Depends on the Firebird version. I believe in 2.0 or earlier there was a difference, but t

Re: [firebird-support] I can't drop foreign key

On 16-2-2016 22:05, watan...@yahoo.com [firebird-support] wrote: > I am using FireBird 2.5.3 > and a Database is updated from 2.2, and the database was updated from 1.5. > > The database have about 150 tables and just one foreign key. > > The Foreign key is from "hachu"Table to "parts"Table > > Thi

Re: [firebird-support] how to suppress dashes in query results

On 11 Feb 2016 17:57:35 -0800, "ho...@agencybusys.com [firebird-support]" wrote: > Users can enter values with dashes (-) in random locations. I don't know > where they might put them. I need to select a record using a where clause > that doesn't have those dashes. For example, the user might reco

Re: ODP: Re: [firebird-support] Firebird and web connection

On Tue, 9 Feb 2016 13:46:18 -, "'esdonisgarcia' esdonisgar...@sisconge.hol.es [firebird-support]" wrote: >> >> hi, >> why?I use FB without any problem for web pages. > > It is appropriate > >> But maybe i did not >> understand your answer. >> Maybe you talking about direct db access over >>

Re: [firebird-support] Firebird and web connection

On 6-2-2016 22:37, mlcvi...@yahoo.fr [firebird-support] wrote: > Hello I'm looking for any information on connecting to a firebird > database by IP adresse. > > The database is placed on a web server with a permanent IP... > > is it possible ?, and where to find information on how to do it... Tha

RE: [firebird-support] system table behaviour

On Thu, 4 Feb 2016 15:55:29 +1100, "'Andrew Zenz' and...@aimsoftware.com.au [firebird-support]" wrote: > 'Tis starting to make some sense now. > > Unfortunately our application establishes a connection to the FB server > and remains active until shut down. I can't terminate it and create a > new

Re: [firebird-support] What is more effective execute block or select?

On Thu, 28 Jan 2016 16:22:03 +0100, "Svein Erling Tysvær setys...@gmail.com [firebird-support]" wrote: > No, I must admit limited knowledge of MERGE. For Firebird 3 is seems like a > good alternative, but I think Fb 2.1 and 2.5(?) requires a WHEN NOT MATCHED > THEN INSERT clause (which is typicall

Re: [firebird-support] What is more effective execute block or select?

On Wed, 27 Jan 2016 23:01:50 +0100, "setysvar setys...@gmail.com [firebird-support]" wrote: > [..] On the other hand, there are cases > where EXECUTE BLOCK can help performance (note, I speak for 2.5, I know > nothing about Firebird 3): > > UPDATE h > SET = (SELECT FROM t WHERE > h. = t.)

Re: [firebird-support] What is more effective execute block or select?

On Wed, 27 Jan 2016 10:48:49 -0200, "hamacker sirhamac...@gmail.com [firebird-support]" wrote: > I would know whats methods is more effective, per exemple: > To know if itens exists or not, select: > select > case > when exists(select 1 from cv_itens where id_cv=51716) > then 'Y' >

Re: [firebird-support] The PHP default transaction

On Thu, 21 Jan 2016 10:44:10 +, "Tim Ward t...@telensa.com [firebird-support]" wrote: > I've got a long running (hours) PHP script which does large numbers > (tens of thousands) of database operations along the lines of > > start explicit transaction > do something in that transact

Re: [firebird-support] CPU Affinity

Setting the cpu affinity to target more than one cpu will usually be worse for performance, as SuperServer is essentially single threaded and allowing it to run on multiple cores will cause expensive rescheduling. SuperServer may perform better than Classic because CS has a smaller page buffer b

Re: [firebird-support] When to use Firebird 3 Classic

On 17-1-2016 00:07, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > is there still a reason to use the Classic mode with Firebird 3? Since > there is real SMP support with SuperServer I don’t think there can be > advantages with ClassicServer. The main advantage of course is t

Re: [firebird-support] Firebird Download Malware

On Tue, 5 Jan 2016 15:57:26 +0300, "Alexey Kovyazin a...@ib-aid.com [firebird-support]" wrote: > Hi, > > >The following file is affected: > >http://sourceforge.net/projects/firebird/files/firebird-win64/2.5.5-Release/Firebird-2.5.5.26952_0_x64.exe/download > > I can confirm that Security Essen

Re: [firebird-support] Firebird Download Malware

On 3-1-2016 03:22, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > Hello. > > I downloaded FB 2.5.5 from firebirdsql and my Microsoft Essentials > detected it as a malware. > > Did anybody face the same problem? Could you specify: * The file you download (link please) * When did it report

Re: [firebird-support] 2 servers acessing one database

On Wed, 16 Dec 2015 08:41:11 -0500, "DougC d...@moosemail.net [firebird-support]" wrote: > No, it is not. Two firebird server instances cannot access the same > database regardless of where it is located. On the same physical machine it can: that is how Classic Server works. The major problem is

Re: [firebird-support] FB 1.56 over a VPN

On 9-12-2015 17:31, dres...@tbinc.com [firebird-support] wrote: > We are using FB 1.56, and have a customer using it over a VPN with less > than stellar results (meaning very slow). We are considering FB 3--will > this solve some of the slowness? Any other comments? Maybe, switching to FB 2.5 migh

Re: [firebird-support] Charset UTF8 or ISO8859_1 for new DB with CI + AI

On 8-12-2015 20:58, r...@seedsbydesign.com [firebird-support] wrote: > 1. Is only one byte used for storage for english and spanish? No, only for plain ASCII, and ñ is not in ASCII. IIRC ñ will take two bytes. > 2. Is there any CI + AI collation for ISO8859_1? Yes there are. See http://www.fire

Re: [firebird-support] Dialect 1 vs. 3: DATE to VARCHAR CAST results in different date/time format

On 8-12-2015 09:52, Thomas Steinmaurer t...@iblogmanager.com [firebird-support] wrote: > Hello, > > Executing the following in both, dialect 1 and 3: > > select cast(current_timestamp as varchar(30))from rdb$database > > > results in a string with a different date/time format. At least on > Window

Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?

That is very dangerous to do, the same bytes might be reused differently in a newer ODS. Either use a normal Firebird table to store version info, or do it outside of the database. Do not hack things in the internal structure. Mark - Reply message - Van: "Fabiano Kureck fabi...@sci10.com

Re: [firebird-support] Is it save to append some data at end of the binary firebird database file?

On Windows, all files can have alternative streams with additional data. It is a form of hidden metadata that is attached to the main filename. Mark - Reply message - Van: "Tim Ward t...@telensa.com [firebird-support]" Aan: Onderwerp: [firebird-support] Is it save to append some data a

Re: [firebird-support] VS2008 DDEX/ADO.NET confusion

On 28-11-2015 06:38, slucas slu...@iquanta.com [firebird-support] wrote: > may someone please give me some clarity? i am using visual studio > 2008. i have to use that version to develope an embedded program for a > smart device. so i am locked into VS2008. Are you using .NET or C++? > i am tr

Re: [firebird-support] Backaup&Restore error

On 27-11-2015 20:30, Helen Borrie hele...@iinet.net.au [firebird-support] wrote: > The -fix_fss_metadata switch needs an argument, which is the character > set of any text data that is stored in your metadata, e.g., in CHECK > constraints, triggers, stored procedures and such. > > If you know that

Re: [firebird-support] Cannot Connect to FireBird Database from network workstation

On 21-11-2015 20:07, Jesse McCarty linuxphotographe...@gmail.com [firebird-support] wrote: > Production system running Ubuntu 14.04 (64Bit) and Firebird Classic 2.5 > has the database setup and also has two samba file shares setup. The > Windows 7 machine can see the shares (including the location

Re: [firebird-support] How does LIST() work?

On Thu, 12 Nov 2015 10:03:52 +0200, "'Louis van Alphen' lo...@nucleo.co.za [firebird-support]" wrote: > The document is quite slim on this. Is it possible to, for a parent row to > retrieve child rows and 'pack' a column from the detail rows into a list > using the LIST function? It does exactly

Re: [firebird-support] Order by :variable in a Stored Procedure

If you pass a variable into an order by, it will sort on that *value*, and as that is the same for all rows, it is essentially a no-op. You can only do this by either sourcing the order by using a case to specify the column from a parameter, or by dynamically constructing the query, and executin

Re: [firebird-support] Restore with -FIX_FSS_D and -FIX_FSS_D -FIX_FSS_M

No, you should only use these options if you know your database had the problems it fixes. If your database doesn't have these problems, it could corrupt instead of fix. And you should only apply it once. Repeatedly adopting these options will corrupt if you use non-ASCII characters. Mark

Re: [firebird-support] Firebird Temporary Table

On 31-10-2015 01:43, Aris Mardi arismrd2...@yahoo.com [firebird-support] wrote: > Thank you for your response. > Concerning temporary table. Is it possible to put both ddl temporary > table creation and temporary table selection on a single stored > procedure ? Regarding the ddl creation need to b

Re: [firebird-support] What happens with open transactions on interruptions?

On 29-10-2015 15:41, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > I ask from pure curiosity. What happens on interruption or crash? > > I’m using Flamerobin (and other tools) and doing several modifications. > The transaction is still open. Now the connection breaks. What wi

Re: [firebird-support] It´s a bug or whatever?

On 29-10-2015 19:22, hamacker sirhamac...@gmail.com [firebird-support] wrote: > When I try: > select (2183.48/(1-(37.25/100))) as valor from rdb$database > > As result Firebird: 3465,8412 > But other databases(MSSQL) and spreadshets(Excel and Calc) the correct > result is 3479,6494023904 > > If I

Re: [firebird-support] High CPU use after restore

On Thu, 29 Oct 2015 07:43:29 +0100, "Jardar Maatje jardar.maa...@nds.nortek.no [firebird-support]" wrote: > Hi again, > > Sounds like a reasonable cause for the problem. So now is my question, what > is the best way to upgrade. > My current setup is as follows: > I have two databases, one for raw

Re: [firebird-support] High CPU use after restore

On Wed, 28 Oct 2015 23:59:59 +0100, "setysvar setys...@gmail.com [firebird-support]" wrote: > http://tracker.firebirdsql.org/browse/CORE-4601 is a report of a 60-time > improvement (from half a minute to half a second) with Firebird > 2.5.2/2.5.3 and Jaybird 2.2.5/2.1.6 when changing from blob t

Re: [firebird-support] Offset/size/format of date/time/timezone sensitive section in GBAK export

On 25 Oct 2015 13:44:59 -0700, "tvd...@ymail.com [firebird-support]" wrote: > When making a backup using GBAK, the output depends on the > date/time/timezone (in particular DST). > > Could anyone please tell me how to locate the section containing this? > What is its format? > Does it have a fi

Re: [firebird-support] Restore without constraints

On 22-10-2015 11:20, Köditz, Martin martin.koed...@it-syn.de [firebird-support] wrote: > is it possible to restore a database without constraints? Or is there > another way to do this? I just want do delete each primary key in the db. Could you explain exactly what you are trying to achieve? For

Re: [firebird-support] How to do a running total in SQL

In Firebird 3 it will be possible with window functions. In Firebird 2.5 I don't know a way in pure SQL. Mark - Reply message - Van: "Maya Opperman m...@omniaccounts.co.za [firebird-support]" Aan: "firebird-support@yahoogroups.com" Onderwerp: [firebird-support] How to do a running tota

Re: [firebird-support] Cannot Create Index

On 14-10-2015 07:18, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > How to increase the database page size 16kb ? You need to backup your database, and restore it with a larger page size (commandline parameter -page_size 16384), see http://www.firebirdsql.org/file/documentati

Re: [firebird-support] Firebird 2.5 64 bit and UDFs not loading

On 1-10-2015 13:51, kerry.neighb...@yahoo.com.au [firebird-support] wrote: > > > I have been running Firebird 2.5 (32 bit) for sometime - in Windows 7 64 > bit. I use one of my own UDFs and FreeAdhocUDF for a lot of my queries. > > I am now trying to get Firebird 64 bit Super Server to work. The ex

Re: [firebird-support] firebird service terminated unexpectedly

On Mon, 28 Sep 2015 17:51:08 -0300, "Eduardo guse...@gmail.com [firebird-support]" wrote: > Hello: > > I have an application developped in Delphi that uses Firebird > 2.1.4.18393 SuperServer. > > The application is running well in many enterprises. But there is one > place where there is a prob

Re: [firebird-support] Firebird Embedded on web hosting

On 19-9-2015 10:48, hv...@users.sourceforge.net [firebird-support] wrote: > ---In firebird-support@yahoogroups.com, wrote : > > > On 18-9-2015 19:50, amigoface@... > [firebird-support] wrote: > > > > i have problems on using firebird embedded on my asp.net web host . >

Re: [firebird-support] Firebird Embedded on web hosting

On 18-9-2015 19:50, amigof...@gmail.com [firebird-support] wrote: > i have problems on using firebird embedded on my asp.net web host . > > everything work fine locally but on the web i have an exception > > System.Data.Entity.Core.EntityException: The underlying provider failed > on Open. ---> Fir

Re: [firebird-support] How to Extract Filename from file path inside a stored procedure?

On 17-9-2015 16:19, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Firebird v1.5.3 and v2.5.4 For Firebird 2.5 it is simpler than for Firebird 1.5. > I need a way to extract just the file name for a given file path either > by code in a stored procedure or by calling a UDF in the stored

Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?

On 15 Sep 2015 23:51:11 -0700, "brucedickin...@wp.pl [firebird-support]" wrote: > Hello, > > I need to rebuild some records in my database. I have to choices: > > 1. Firstly I delete set of records and then insert new ones. > 2. I update the existing ones. > > What solution is preferable? Will

Re: [firebird-support] HUGE Log File

On 14 Sep 2015 15:14:38 -0700, "chubmast...@mac.com [firebird-support]" wrote: > Im no IT guy so bear with me. I have a 2009 iMac running os x 10.8 It > has a 640 gb hard drive. Firebird.log is taking up 424 gb. I have a > digital X-ray program that uses firebird as it's framework. They den

Re: [firebird-support] read only select statements and isolation

On 14-9-2015 09:45, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > On 13-9-2015 04:33, thirdshiftco...@yahoo.com [firebird-support] wrote: >> I read through and practiced with all types of read committed >> transactions with and without wait. I understand those sc

Re: [firebird-support] read only select statements and isolation

On 13-9-2015 04:33, thirdshiftco...@yahoo.com [firebird-support] wrote: > I read through and practiced with all types of read committed > transactions with and without wait. I understand those scenarios as they > apply to read write with, for i.e., update statements. > > I am trying to figure out b

Re: [firebird-support] reword question re: selects in firebird in transactions

On 13-9-2015 20:01, thirdshiftco...@yahoo.com [firebird-support] wrote: > I am just practicing. I might have posted a confusing question before. > > I want to see how selects behave differently with being in different > isolation contexts rather than just running the default snapshot like in > isql

Re: [firebird-support] Firebird Server on Windows 10

On 11-9-2015 19:59, Mike Ro miker...@gmail.com [firebird-support] wrote: > I am trying to install a Firebird server on a reasonably clean Windows > 10 machine, but I am running into the gsec "cannot attach to password > database" issue. > > Details are: > > Edition: Windows 10 Pro (64-bit system, x

Re: [firebird-support] Sponsoring new feature requests

On 4-9-2015 11:15, j...@microtec.fr [firebird-support] wrote: > I just posted a feature request on the bug tracker: [#CORE-4924] Access > field values of a cursor by field name - Firebird RDBMS Issue Tracker > > > > image

Re: [firebird-support] Suddenly: Connection rejected by remote interface

On 9-9-2015 14:59, soprano...@yahoo.com.ar [firebird-support] wrote: > > > Hello, > > My Firebird works ok, but sometimes suddenly stop to accept connections > and I need to restart it in order to work again. > > Firebird Version: Firebird TCP/IP server version LI-V2.5.2.26540 > Firebird 2.5 You s

Re: [firebird-support] can't log-in as user account firebird

You are not supposed to login as user Firebird, that is also why it is pointing to nologin. That user is only the user for running the service, and for security reasons you shouldn't login with it. To connect to Firebird, you need to have an account in Firebird (created using gsec) and connect t

Re: [firebird-support] Error in order by clause

As far as I can tell it sorts as it should. What sort are you expecting? Mark - Reply message - Van: "'Bogdan' bog...@mordicom.si [firebird-support]" Aan: Onderwerp: [firebird-support] Error in order by clause Datum: ma, aug. 24, 2015 10:37 Hi to all Server: Firebird 2.5.4. I have f

RE: [firebird-support] Regarding ODBC

On Fri, 21 Aug 2015 14:37:06 +, "'Raman, Anitha' anitha.ra...@am.jll.com [firebird-support]" wrote: > Nick - I downloaded this where the Powercenter Client is running. Are you > saying I need this downloaded even on Powercenter Server side? That depends on where Powercenter uses ODBC, if it i

Re: [firebird-support] Regarding ODBC

The mailinglist doesn't support attachments, please post the error message as text. Mark - Reply message - Van: "'Raman, Anitha' anitha.ra...@am.jll.com [firebird-support]" Aan: Onderwerp: [firebird-support] Regarding ODBC Datum: do, aug. 20, 2015 23:19 Hello group - I have installed

Re: [firebird-support] Installation of Firebird 2.5.4 on CentOS 6

AMD64 is x86-64. AMD was the first to have 64 bit x86, and Intel used the same instruction set when Itanium failed. The name has never changed in the build. Mark - Reply message - Van: "Hector Sánchez hec...@planatec.es [firebird-support]" Aan: Onderwerp: [firebird-support] Installatio

Re: [firebird-support] Error in power function in firebird 2.5

On Wed, 12 Aug 2015 13:00:57 +0200, "Jesus Garcia jeg...@gmail.com [firebird-support]" wrote: > In firebird documentation appears that in power function with an x value > negative, an error is raised, but I can execute in firebird 2.5 > > *select power(-3.215,2) from rdb$database* > > where is t

RE: [firebird-support] error firebird v2.5.4 using trigger and hash function and update or delete record same content

On Tue, 11 Aug 2015 13:09:27 +0200, "'Bogdan' bog...@mordicom.si [firebird-support]" wrote: > I believe there is no PK in the table, so engine doesn't know what record > to delete A delete statement doesn't need an unique identification of the row (the exception is delete ... returning ... as it

Re: [firebird-support] error firebird v2.5.4 using trigger and hash function and update or delete record same content

On 10 Aug 2015 14:23:44 -0700, "email...@yahoo.com.br [firebird-support]" wrote: > - I add new records mannually, add one new ID field value and the other > fields have your values by TRIGGER BEFORE INSERT > - Then, I try add 2 or more record with ID = 1 > - Later, I try delete any one record and

Re: [firebird-support] Trying to decide legacy tables.

On Mon, 10 Aug 2015 19:23:56 +, "Maureen Bertocci mberto...@bblfleet.com [firebird-support]" wrote: > Hello, and thank you I am excite about my new endeavor! > > > I would like to join the support group. I am new to firebird. There are > two things I am trying to figure out. > 1. The fir

Re: [firebird-support] Knowing the previous rows

On 7-8-2015 22:50, 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support] wrote: > I just was a bit curious about that possibility, which seems interesting > for audit tables and more yet, users. > > By design, very few UPDATEs and DELETEs there are on my databases > becau

Re: [firebird-support] Using LIKE/MATCHING? in stored procedure

On Wed, 5 Aug 2015 10:58:34 +, "Tor Jørgen Brekka tor.jor...@kameleongruppen.no [firebird-support]" wrote: > Hello, > > I need help with the following stored procedure that I need to change: > > Here is a part of it like it is today: > --- > BEGIN

Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Character Set and Collations

On 31-7-2015 16:09, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Greetings All, > > I recently did a metadata only backup of my Firebird 1.5.3 database. > > Please note this database has a character set of NONE and anywhere where > this could be set has remained NONE and no Collation was

Re: [firebird-support] Taking database back from v2.5 ODS11.2 to v2.1 ODS11.1

On 4-8-2015 00:34, 'Neil Pickles' neil.pick...@csy.co.uk [firebird-support] wrote: > I’m sure I saw a message on here about how it was possible to backup a > database from one Firebird/ODS version and restore it to a previous > Firebird/ODS version. I am trying to convert a Firebird v2.5 database

Re: Rif: [firebird-support] Chararacter set NONE to ISO8859_1

On 24-7-2015 21:37, Aldo Caruso aldo.car...@argencasas.com [firebird-support] wrote: > In the process of moving the data back and forth, using a temporary > field of the right character set, you have to drop the original field an > then recreate it. > > The process of dropping a field is a bit nas

Re: [firebird-support] FreeUDFLib 64 Bit version

On 24-7-2015 22:29, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Greetings, > > Does anyone know where I can get a 64 bit version of the FreeUDFLib.dll? > > I know Jeff Overcash (TeamB) has done it per this link, but I have no > idea how to get ahold of him > > http://codeverge.com/embar

Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - Existence Predicates NOT IN Question

On 24-7-2015 13:25, 'stwizard' stwiz...@att.net [firebird-support] wrote: > Greetings All, > > In the Firebird 2 Migration & Installation guide > http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-Installation.pdf > on page 8 under the performance section it states the follo

Re: [firebird-support] Problem with FB database that freezes

On 24-7-2015 00:23, conver...@gmail.com [firebird-support] wrote: > Thanks for your insightful response. FWIW, I would like to mention that, > in the same server, we have another database (same size ~7 GB) no one > connects to, it's a restore of the production database from January this > year. Thi

Re: [firebird-support] Problem with FB database that freezes

On 23-7-2015 21:07, conver...@gmail.com [firebird-support] wrote: > Hi there, we have a 7 GB Firebird 2.5 database, running on FB Classic > 2.5.2 64 bits on a Windows Server. This is a 64 bits Windows server with > 24 CPU cores and 32 GB of RAM. > > When the client connection count surpasses 200, t

Re: [firebird-support] Upgrade Firebird 1.5.3 to 2.5.4 - CHECK Constraint Change Question

On Thu, 23 Jul 2015 08:15:35 -0500, "'stwizard' stwiz...@att.net [firebird-support]" wrote: > Greetings All, > > In the Firebird 2 Migration & Installation guide > http://www.firebirdsql.org/file/documentation/release_notes/Firebird-2_1_6-I > nstallation.pdf > on page 4 it states the following:

RE: [firebird-support] Migration Guide for Firebird 1.5.3 to 2.5.4

On Thu, 23 Jul 2015 07:16:18 -0500, "'stwizard' stwiz...@att.net [firebird-support]" wrote: > Thank you Helen for your reply, > > I'll do as you suggest and read the release notes (in order) and I may have > question after reading them. Just know that upgrading the database (apart from the metad

Re: Rif: [firebird-support] Chararacter set NONE to ISO8859_1

On Wed, 22 Jul 2015 21:09:12 -0300, "Aldo Caruso aldo.car...@argencasas.com [firebird-support]" wrote: > Raffaele, > > thanks for your answer. > The question is what prevents data loss in the first procedure ? > Suppose the filed in question is > > FIRST_NAME VARCHAR(60) CHAR

Re: Rif: [firebird-support] Re: Is it possible to use only "part" of the index?

On 20 Jul 2015 05:20:31 -0700, "brucedickin...@wp.pl [firebird-support]" wrote: > So, if I change the order of fields in the index I can speed things up. > Could someone explain me why it works like it works? What are the internals > behind this? Simplified the index entry is This means that w

Re: [firebird-support] Hello all, I have some questions about the param "-T" for nbackup and respectively

On 19 Jul 2015 10:29:04 -0700, "map...@gmail.com [firebird-support]" wrote: > Hello all, I have some questions about the param "-T" for nbackup and… > https://plus.google.com/b/111558763769231855886/+DobrinPetkov/posts/YGswA4f6KjF > > > > https://plus.google.com/b/111558763769231855886/+Dobr

Re: [firebird-support] Re: Duplicate key error during database restore

You are using a Firebird 2.1 gbak.exe to backup and/or restore a Firebird 2.5 database. Mark - Reply message - Van: "sboyd...@gmail.com [firebird-support]" Aan: Onderwerp: [firebird-support] Re: Duplicate key error during database restore Datum: vr, jul. 17, 2015 20:22 More information

Re: [firebird-support] Is it possible to use only "part" of the index?

You can use an index partially, but only if that part is the prefix of the rest of the index. As ID_PARAM is the second part of the index, the index cannot be used. Either reverse the columns in the index definition, or create a separate index. Note that given the name, I'd guess this should be

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

You might get a quicker response on firebird-devel. Questions about beta versions are off topic on firebird-support. Mark - Reply message - Van: "'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]" Aan: Onderwerp: [firebird-support] Re: Firebird 3, executio

Re: [firebird-support] firebird & nessus

On Mon, 13 Jul 2015 08:56:10 -0700, "Alex Hasman hasmana...@yahoo.com [firebird-support]" wrote: > i have a problem in convrting the adobe files to other type such as word > , i tried via online but i failed too, how can i get started to convert > please. I fail to see how this is related

Re: [firebird-support] firebird & nessus

On Mon, 13 Jul 2015 13:56:04 +0100, "Nick Upson n...@telensa.com [firebird-support]" wrote: > Hi > > firebird 2.1 centos, I have systems in a company who are scanning with > nessus and this causes the firebird log below. Although they do not have > access to the database I'm concerned what is hap

Re: [firebird-support] moving from FB 2.5.1 to 2.5.4

On 09 Jul 2015 19:53:34 -0700, "jakef...@yahoo.com [firebird-support]" wrote: > What are the proper steps to change a database on a server from FB 2.5.1 > to 2.5.4 (both 32 bit on Windows 2008 server) > My current plan is: > 1. I downloaded 2.5.4 .zip files and unzipped to > ...\Firebird\Firebi

RE: [firebird-support] Gbaked and restored database larger than the original?

On Wed, 8 Jul 2015 12:14:13 +, "Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]" wrote: > Take a look here: http://www.firebirdfaq.org/faq361/ > > I'd add that restore also has a -use_all_space option. If you don't > specify this, then pages are filled to approx

Re: [firebird-support] Order By Not Working Using "WITH" Clause

f I don't use Distinct, i don't get expected result. On Friday, 3 July 2015 7:17 PM, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" wrote: On Fri, 3 Jul 2015 12:15:31 + (UTC), "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" wrote: &

Re: [firebird-support] Order By Not Working Using "WITH" Clause

On Fri, 3 Jul 2015 12:15:31 + (UTC), "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" wrote: > Hi All, > I have below SQL, which is concatenating the ShortCode column data, but > without ordering as per the ORDER_NUMBER column in ABC table in "WITH" > clause. > Please help. > > With

Re: FWD: [firebird-support] Blob concat consume memory - why?

You forwarded it to firebird-support, not to firebird-devel. Mark On 24-6-2015 12:12, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: > > > Hi, > why concating blob consume memory and not leave it until transaction > end? > simple sample > SET TERM ^ ; >

<    2   3   4   5   6   7   8   9   >