Subject Re: [ib-support] SQL Statement
Author Martijn Tonies

> I have just stumpled over some text saying something about this being
> wrong:
> Select
> a.Fielda,
> a.Fieldb,
> b.Fieldc,
> b:fieldd
> where
> a.Fielda=b.Fieldb and
> a.Fielde>"Some value"
> ordre by a.Fieldb;
> Is this wrong in any way ?

String values should be enclosed in single quotes:

> a.Fielde>'Some value'

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."