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 ||
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
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:
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
--- 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
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
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
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
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
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
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
Thanks,
Brain was faded.
Kind Regards,
Robert.
--- 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
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
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.
15 matches
Mail list logo