Re: Error executing sql statement


Ivan Debono wrote:
Actually it does, but only from Jet 5.0

<tongue firmly embedded in cheek> Wow, when did that come out? I've
been waiting for five years!

....or perhaps you meant Jet 4.0?

On a more serious note, I've never known an empty string to be at all
useful in a text column, let alone to be the default. I usually do the
complete opposite of the OP i.e. on the rare occasion where there is no
pattern matching or other validation to preclude one, I'll always
explicitly check to exclude zero-length strings e.g.

CREATE TABLE Blahs (...
description VARCHAR (200) DEFAULT '{{NONE}}' NOT NULL,
CONSTRAINT blah_description__not_zero_length
CHECK (LEN(description) > 0),
CONSTRAINT blah_description__curly_brackets_in_default_only
CHECK (description NOT LIKE '%[{}]%' OR description = '{{NONE}}'),
....

Jamie.

--

.