Hi Folks,

When I try to set a default value, I get the error in the subject, any ideas?

This is the definition:

"LETT" VARCHAR(8) COLLATE "ANSI_CI" DEFAULT "",

If I want to add  DEFAULT to an existing table using ALTER, I get the same error.

Note, these fields are NULLABLE, for backward compatibility.

Many Thanks
Pierre

Hi Guys,

Ignore this one, seems to be double quotes are interpreted differently than single, using single quotes to define the DEFAULT Value works.

Thanks
Pierre