Hi, I'm using BuilderXE and UTF8 FB database.
I prefere dbExpress components for unicode support.
Let you try them.
But if you use TDBEdit, TDBGrid, ... you need to use TDataSetProvider and
TClientDataSet
(and distribute midas.dll together with your application)
Best regards, Tom
Dne
Dear All
I wish to output text from a stored procedure. How do I do this?
Is there an alternative to the DBMS_OUTPUT package in oracle, or even a simple
PRINT statement?
Thanks
thanks
-Original Message-
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Doug Chamberlin
Sent: Thursday, June 21, 2012 4:12 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Left join and computed columns
On 6/21/12
I am having the strangest problem with by system. First, I am running Windows
7 64-bit with all the latest patches. I am also running Firebird 2.1.4.18393.
If I set the Firebird Guardian to start automatically, my system refuses to
boot. It will come up part way and just hang before it
Gary,
I am in the process of moving servers and the restore time of the 53GB
backup is a going to cause a timing problem
I have made a level 0 backup of the database, 53GB, I would like to restore
the level 0 backup in the meantime, and on the night of the server swap do a
level 1 backup
Stephen,
If I set the Firebird Guardian to start automatically, my system refuses to
boot.
The Guardian is not necessary for more recent Windows versions, due to changes
to the Services functionality which supports the automatic restart (within 1
minute) of a service which has ended abended.
On 2012-06-22 14:09, ktadimeti wrote:
I wish to output text from a stored procedure. How do I do this?
Is there an alternative to the DBMS_OUTPUT package in oracle, or even a
simple PRINT statement?
I'm not sure I understood you correctly, but you can just select rows
from a selectable
On Fri, Jun 22, 2012 at 9:09 AM, ktadimeti tadimetikes...@yahoo.com wrote:
I wish to output text from a stored procedure. How do I do this?
Is there an alternative to the DBMS_OUTPUT package in oracle, or even a
simple PRINT statement?
You need to display the text from the client, not the
ktadimeti wrote:
I wish to output text from a stored procedure. How do I do this?
There are different way, depending what you really need:
1. You can create a selectable stored procedure:
create procedure p1 returns (output_text varchar(3000)) as begin
for select something into :output_text do
Hi Sean
Does that mean I can do a level 0 restore overnight, and then a level 1
restore tomorrow night?
In other words, is doing this:
nbackup -R mydb.fdb level_0.nbk level_1.nbk
the same as doing this:
nbackup -R mydb.fdb level_0.nbk
nbackup -R mydb.fdb level_1.nbk
Thanks for you
Gary,
Does that mean I can do a level 0 restore overnight, and then a level 1
restore tomorrow night?
In other words, is doing this:
nbackup -R mydb.fdb level_0.nbk level_1.nbk
the same as doing this:
nbackup -R mydb.fdb level_0.nbk
nbackup -R mydb.fdb level_1.nbk
Yes.
Sean
hi all--
(always a great place to get answers!!)
here is the sql I'd prefer to use (a join)
select distinct t.plantkey, t.mostrecent, t.tagnumber, t.datetested,
t.equipmentkey, o.equipmentkey, o.datetested from reliefd t
join reliefd o
on t.equipmentkey=o.equipmentkey
where
t.mostrecent='T'
On Fri, Jun 22, 2012 at 3:28 PM, bwc3068 av...@telusplanet.net wrote:
hi all--
(always a great place to get answers!!)
here is the sql I'd prefer to use (a join)
select distinct t.plantkey, t.mostrecent, t.tagnumber, t.datetested,
t.equipmentkey, o.equipmentkey, o.datetested from reliefd
13 matches
Mail list logo