[firebird-support] Writing Carraige returns into a field using SQL

2012-09-03 Thread sir_wally_lewis
Hi, I have a problem, where I need to use SQL to update a Memo field. The textual data includes carriage returns. This should be simple however the below fails: UPDATE ST_SCLE_PRNT_FMT SET NA_SCLE_PRNT_FRMT = '[2|02:*]' || #13#10 || 'BARFMTDEFAULT=00' || #13#10 || 'USEDATE=SELLDATE' || #13#10 ||

Re: [firebird-support] Establishing a database with Firebird

2012-09-03 Thread Michael Ludwig
jasonvv schrieb am 03.09.2012 um 04:11 (-): > My aims are (i) establishing a new database on the new computer and > (ii) ensuring that the old records are safely transferred. … would > anyone please advise on the new database establishment as well as the > record transferral as I am reall

Re: [firebird-support] Writing Carraige returns into a field using SQL

2012-09-03 Thread Mark Rotteveel
On Mon, 03 Sep 2012 07:00:18 -, "sir_wally_lewis" wrote: > Hi, > > I have a problem, where I need to use SQL to update a Memo field. > The textual data includes carriage returns. > > This should be simple however the below fails: > > UPDATE ST_SCLE_PRNT_FMT > SET NA_SCLE_PRNT_FRMT = '[2|02:

[firebird-support] Stored Proc optimisation advice

2012-09-03 Thread Maya Opperman
Hi, I have a stored proc that calculates account balances. Most of the time it takes between 1-2 seconds, but every now and then it takes 22 seconds. It seems to be approx. every 5 or 6 records. Ie. I have a stores procedure that returns a list of 6 accounts and their balances. I have a sub p

[firebird-support] Re: Return SQL result in portions / progressively load result set

2012-09-03 Thread williamevanw
--- In firebird-support@yahoogroups.com, Mark Rotteveel wrote: > > On Fri, 31 Aug 2012 08:23:17 -, "williamevanw" > > wrote: > > Hi guys, > > > > I have several database tables that can grow to contain more than a > > million records. These tables are loaded into a jTable and then > displ

[firebird-support] Do collation affects index size?

2012-09-03 Thread Fabiano
Hi all, create domain d1 varchar(100) character set utf8; create table t1 (c1 d1, c2 d1); alter table t1 add unique (c1, c2); create domain d2 varchar(100) character set utf8 collate unicode_ci_ai; create table t2 (c1 d2, c2 d2); alter table t2 add unique (c1, c2); -- unsuccessful metadata update

Re: [firebird-support] Do collation affects index size?

2012-09-03 Thread Mark Rotteveel
On Mon, 03 Sep 2012 10:09:12 -, "Fabiano" wrote: > Hi all, > > create domain d1 varchar(100) character set utf8; > create table t1 (c1 d1, c2 d1); > alter table t1 add unique (c1, c2); > > create domain d2 varchar(100) character set utf8 collate unicode_ci_ai; > create table t2 (c1 d2, c2 d2

[firebird-support] Firebird - Microsoft Server 2008 x64 - Memory Management - Hard / Page Faults

2012-09-03 Thread welham.lindsay
Hi I am running Firebird_2_5 on a Microsoft 2008 x64 OS When doing large extraction queries or running gfix the Resource Managers shows thourands of Memory Hard / Page Faults Is there any Microsoft Configuration or Firebird Confif setting that can be changed to elliminate the latter Linds

Re: [firebird-support] Firebird - Microsoft Server 2008 x64 - Memory Management - Hard / Page Faults

2012-09-03 Thread Carlos H. Cantu
Take a look at this post: dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html Carlos Firebird Performance in Detail - http://videos.firebirddevelopersday.com www.firebirdnews.org - www.FireBase.com.br wl> Hi wl> I am running Firebird_2_5 on a Microsoft 2008 x64 OS wl

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

2012-09-03 Thread Ismael L. Donis Garcia
SET TERM ^ ; CREATE TRIGGER AFCONFI_AU FOR AFCONFI ACTIVE AFTER UPDATE POSITION 0 AS BEGIN /* Trigger para registrar el control de actividades */ if (old.fechap <> new.fechap) then begin if (old.fechap < new.fechap) then execute procedure pi_afact(new.idac, 'Realizó el cierre

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

2012-09-03 Thread Ismael L. Donis Garcia
I had not put the END of the CASE Best Regards = || ISMAEL || = - Original Message - From: Ismael L. Donis Garcia To: Firebird Support Sent: Monday, September 03, 2012 4:08 PM Subject: [firebird-support] I need help to create trigger in Flamerobin and Firebird

[firebird-support] Re: Writing Carraige returns into a field using SQL

2012-09-03 Thread sir_wally_lewis
Thanks, Brain was faded. Kind Regards, Robert.

[firebird-support] Re: Establishing a database with Firebird

2012-09-03 Thread technisoft2005
--- In firebird-support@yahoogroups.com, "jasonvv" wrote: > > Hi all, > > My name is Jason and I am a Medical Physicist in Canberra, Australia. I am > also a beginner of firebird. Radiation records? Such as might possibly form evidence in a court case or scientific studies? Shouldn't yo

Re: [firebird-support] Re: Writing Carraige returns into a field using SQL

2012-09-03 Thread Mark Rotteveel
On Mon, 03 Sep 2012 23:14:02 -, "sir_wally_lewis" wrote: > Thanks, > > Brain was faded. I just realized that with FB 2.5, you might also be able to use hexadecimal notation for strings: http://www.firebirdsql.org/refdocs/langrefupd25-hexbinstrings.html So concatenating x'0D0A' where you wan

Re: [firebird-support] Establishing a database with Firebird

2012-09-03 Thread Lester Caine
Michael Ludwig wrote: >> >My aims are (i) establishing a new database on the new computer and >> >(ii) ensuring that the old records are safely transferred. … would >> >anyone please advise on the new database establishment as well as the >> >record transferral as I am really a newbie to firebird.