From: | "Andrzej Szydlo" <andrzej(at)gv(dot)edu(dot)pl> |
---|---|
To: | Byron Nikolaidis <byronn(at)insightdist(dot)com> |
Cc: | pgsql-interfaces(at)hub(dot)org |
Subject: | Re: [INTERFACES] ODBC, Delphi and BLOBs (images) |
Date: | 1998-08-19 21:53:54 |
Message-ID: | 199808192241.WAA17687@maciek.gv.edu.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Hagerty | 1998-08-20 02:37:17 | Data types and binary data |
Previous Message | Andrzej Szydlo | 1998-08-19 19:36:49 | Re: [INTERFACES] ODBC, Delphi and BLOBs (images) |