Hi,

> > String values should be enclosed in single quotes:
> >
> > > a.Fielde>'Some value'
>
> OK. This I do.
>
> But I meant more generally ?
>
> I have a DB that keeps getting corrupted, and I can't find the cause.,
> Maybe its my SQL, eventhough I don't do anything fancy !

If your db is getting corrupted by SQL, it would be terrible :)

What kind of corruptions are you experiencing? What makes you
think it's the SQL and not flaky hardware? Do you have the
same connection string (and the right one) in all applications?




Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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