hi, all,
in a store procedure, i try to insert into a table some records from an other
store procedure, it seems like this:
create procedure test1
as
begin
insert into table1(f1, f2, f3)
select fa, fb, fc from test2(param1, param2);
end
test2 is a store procedure defined in the same
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote:
At 08:12 AM 22/11/2011, Aage Johansen wrote:
Martin Agren wrote:
...
Data output from my stored proc isnt reflecting the changes I have
made. I make changes in DDL, check the new dataset (Flamerobin or
my client
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
Helen,
Martin Agren wrote:
...
Data output from my stored proc isnt reflecting the changes I have
made. I make changes in DDL, check the new dataset (Flamerobin or
my client app) and am not getting the
A bit basic but is the transaction being committed?
Sent from my BlackBerry® wireless device
-Original Message-
From: Tomasz Tyrakowski t.tyrakow...@sol-system.pl
Sender: firebird-support@yahoogroups.com
Date: Tue, 22 Nov 2011 11:55:00
To: firebird-support@yahoogroups.com
Reply-To:
Tomasz,
i'm sorry.
i always use ibexpert to manage my database and test my store procedure and sql.
now i think i have found the reason of failing to inserting. just i execute the
procedure again, and clear all the history in the parameters history, it can
work correctly.
thank you again.
Mahesh Pratihari wrote:
Could you please let me know the best fit data type in XML in firebird,
as firebird doesn't support the xml data type?
I need the alternative data type of it.
If you later need to query this data, then you should really store it in
tables instead of a single blob
Hi,
I use a proprietary application that embeds a Firebird database.
I would like to be able to access its data via network, the application does
not provide an interface.
Since the database file is locked (http://www.firebirdfaq.org/faq230/) only one
server may control it.
Is there a way to
Yes, I've done that several times. No success.
I've tried all the different configurations of Firebird 2.5.1. Still no
success.
Any other ideas? Thanks!
Hello,
Also check transaction count limit (2^32-1) in your databases.
If Next transaction is close to it, make backup/restore.
Regards,
Alexey Kovyazin
IBSurgeon (www.ib-aid.com)
There are no problems (like corruption) if the server was power down during
backup?
Since backup is an regular
At 04:38 AM 23/11/2011, random64785 wrote:
Hi,
I use a proprietary application that embeds a Firebird database.
I would like to be able to access its data via network, the application does
not provide an interface.
Since the database file is locked (http://www.firebirdfaq.org/faq230/) only
one
10 matches
Mail list logo