At 08:03 PM 29/11/2011, ibmcom2011 wrote:
heLen,
Thanks.
I found I should add a with check option to the end of a updatable view in
the introduction of FB2.0. Now my FB version is 2.5.
But the option requires a where sub-clause, and I don't know how to do.
Do you have a WHERE clause in the
Hello,
No such thing as Firebird cluster exists, at least in the frames of
current versions.
If you need failover and/or scalability, design your system in
distributed manner with replication.
Regards,
Alexey Kovyazin
IBSurgeon
Hello everybody
Do you know some book or article about
Helen,
I created a view as you said.
CREATE OR ALTER VIEW V_T_BALANCE(
F_ACD_ID,
NUM1,
NUM2,
BALANCE)
AS
select F_ACD_ID, NUM1, NUM2, BALANCE from FIN_ACC_CASH_DIARY
where 1 = 1
with check option
;
Then create a trigger for the view:
CREATE OR ALTER TRIGGER
Using Firebird 2.5.1 on Lion 10.7.2 on a 4 core machine I attach to 2 separate
databases on the same machine in quick succession via localhost. Firebird
always opens the first database with no problems but often hangs opening the
second database. The only way out is to reboot repeatedly until
At 10:21 PM 29/11/2011, ibmcom2011 wrote:
Helen,
I created a view as you said.
No, you didn't.
CREATE OR ALTER VIEW V_T_BALANCE(
F_ACD_ID,
NUM1,
NUM2,
BALANCE)
AS
select F_ACD_ID, NUM1, NUM2, BALANCE from FIN_ACC_CASH_DIARY
where 1 = 1
with check option
;
I said:
But for
2011/11/29 johnryh john...@yahoo.com.au
Using Firebird 2.5.1 on Lion 10.7.2 on a 4 core machine I attach to 2
separate databases on the same machine in quick succession via localhost.
Firebird always opens the first database with no problems but often hangs
opening the second database. The
johnryh [2011-11-29 09:29] :
Any ideas?
what Firebird kind are you using ? Classic, SuperClassic, Superserver ?
may be you use trace/audit with SuperClassic or SuperServer ?
Thanks Helen, it worked perfectly. I got the idea of the flow, now I can
proceed with my learning. Thanks again!
--- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote:
Remove SUSPEND from the SP.
Then, call the procedure like this if the trigger wants only a one-row set:
--- In firebird-support@yahoogroups.com, W O sistemas2000profesional@...
wrote:
Hello everybody
Do you know some book or article about clustering Firebird's databases?
Greetings.
Firebird HA can be achievied today with replication and
using a heartbeat like in the Linux-HA project
Works like a champ! Thanks!
--- In firebird-support@yahoogroups.com, Philippe Makowski makowski@... wrote:
2011/11/28 greg_runnels greg_runnels@...
Does anyone have a good suggestion for an admin tool on the Mac? I recently
upgraded to the 64-bit version of Firebird 2.5.1, and
I had almost the exact same issue. I installed the lipo 64 version.
Everything is happy now!
--- In firebird-support@yahoogroups.com, johnryh johnryh@... wrote:
Using Firebird 2.5.1 on Lion 10.7.2 on a 4 core machine I attach to 2
separate databases on the same machine in quick succession
--- In firebird-support@yahoogroups.com, philippe makowski makowski@... wrote:
johnryh [2011-11-29 09:29] :
Any ideas?
what Firebird kind are you using ? Classic, SuperClassic, Superserver ?
may be you use trace/audit with SuperClassic or SuperServer ?
Everything except the lipo
FB 2.5
I need to insert data with a script. but get an error
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 2, column 1.
INSERT.
the script itself is like below- any ideas what is wrong?
INSERT INTO CAR_MARK (car_mark_id, car_mark_name) VALUES (1, 'test ');
At 12:22 PM 30/11/2011, Net Newbie wrote:
FB 2.5
I need to insert data with a script. but get an error
Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 2, column 1.
INSERT.
the script itself is like below- any ideas what is wrong?
INSERT INTO CAR_MARK
Hi All,
Application is very slow while connecting Firebird database version
2.5.0 using the .Net Provider 2.5.1.
Please have a look at the snap shot of database what I am using. I have
changed the Page buffers size from default 0 to 4000 to check the
performance of the database, but I
15 matches
Mail list logo