I'm having problems with a BLOB Sub Type 1 Field. Sub Type 1 is
supposed to be a text (memo) field. Here's the DDL (cut down a bit
because there are 21 fields).

CREATE TABLE "Users"(
"UserID" Integer NOT NULL,
"FirstName" Varchar(255),
"LastName" Varchar(255),
"Display" Varchar(255) NOT NULL,
<...>
"Pathname" Blob sub_type 1,
<...>
PRIMARY KEY ("UserID"),
CONSTRAINT "L484e5d7f" UNIQUE ("Display")
);
ALTER TABLE "Users" ADD CONSTRAINT "J484e5d7f"
CHECK (CHAR_LENGTH("Display") > 0);
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE
ON "Users" TO "SYSDBA" WITH GRANT OPTION;

Initially the table is created with one record, with Pathname left NULL.
If I run the query SELECT * FROM "Users";, FlameRobin reports for
this field:

Field #17: Users.Pathname Alias:Pathname Type:NUMERIC(18,-53)

which sounds a bit iffy, but at least the single record displays OK.

However, if I now run UPDATE "Users" SET "Pathname"='any old string';,
SELECT * FROM "Users"; now fails with the message:

*** IBPP::WrongType ***
Context: RowImpl::GetValue
Message: Incompatible types.

BLOB and double

Could anyone please tell me what's happening here and how I fix it?
Unfortunately I can't use a VARCHAR field because this table is linked
to a table an MS Access front end, which only allows 255 characters in
VARCHAR. DAO reports the field as always containing the string '0', so
I'm assuming this is the result of this BLOB/double confusion.

Regards,

Robert.


--
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.2.0/1493 - Release Date: 6/9/2008 17:25