Hi,

I just tried to use the (somewhat) new update or insert construct, like
this:

------------------------------------------------------------
create table "Test" (
"Id" int not null primary key,
"Data" varchar(200)
);
[commit]
------------------------------------------------------------
update or insert into "Test" ("Id", "Data")
values (1, 'Stuff');

Stats from FlameRobin:
31 fetches, 6 marks, 0 reads, 0 writes.
1 inserts, 0 updates, 0 deletes, 4 index, 0 seq.
Delta memory: 9832 bytes.
Test: 1 inserts.
1 row affected directly.

This is as expected.
------------------------------------------------------------
select * from "Test"
(Returns data as expected)
------------------------------------------------------------
update or insert into "Test" ("Id", "Data")
values (1, 'New stuff');

Stats from FlameRobin:
30 fetches, 1 marks, 0 reads, 0 writes.
0 inserts, 1 updates, 0 deletes, 5 index, 0 seq.
Delta memory: 8480 bytes.
Test: 1 updates.
0 rows affected directly.
------------------------------------------------------------

In the last stats, it says "1 updates" but "0 rows affected directly".
Shouldn't that be "1 row affected directly"?

Not sure if this is by design and if not I don't know if it's FB or IBPP
(which is FR's underlying interface to FB) that gets it wrong. Please
help with that.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64

------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion
and the tools developers use with it. Learn more about uberSVN and get a
free download at: http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Flamerobin-devel mailing list
Flamerobin-devel@...
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

.