Re: [INTERFACES] ODBC, Delphi and BLOBs (images)

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