Re: [Zope] INTERBASE cannot do this type of query ?

Francois-regis Chalaoux wrote:

Error, Products.gvibDA.gvib.gvibExceptions.ProgrammingError: - Dynamic SQL Error -- SQL error code = -206 -- Column unknown -- MOUSE

SQL used:

select IND_SPECIE from ZEB_INDIVIDU where IND_SPECIE = "MOUSE"

Use single quotes around 'MOUSE'. In SQL, single qoutes are for string literals, double quotes for column names (there are people who think spaces in column names or mixed lower/upper case column names are neat.... NOT). Jan