On Wed, 19 Aug 1998 at 15:17:36 -0400, Byron Nikolaidis wrote:
>
> But what did you get in your log file this time? It should have a different
> message.
I'm sorry for not attaching it.
There are two cases. The first one I described in my previous
message. There's no activity logged then and Delphi displays "Invalid
BLOB length", nothing is written to tha table. It happens when I try
to insert a large image.
When I try to insert a relatively small image:
++++++++++
conn=43911292, query='declare SQL_CUR44066004 cursor for SELECT "img"
FROM "test_tab" WHERE "nr"=3' conn=43911292, query='fetch 100 in
SQL_CUR44066004'
[ fetched 1 rows ]
STATEMENT ERROR: func=SQLFetch, desc='', errnum=1, errmsg='Couldnt
open large object for writing.'
++++++++++
Delphi displays:
"Read Error: Couldn't open large object for writing."
and only the "nr" field is written to the table.
( the table is:
CREATE TABLE test_tab(nr int4, img lo);
CREATE UNIQUE INDEX test_inx ON test_tab (nr); )
Andrzej