SQL Error

[Ruslan Zasukhin]

On 11/22/05 12:27 AM, "Chuck Neal" <chuck at mediamacros.com> wrote:

> Unfortunately I do not have the luxury of changing it since its an
> existing project.  Any work arounds other than using the API syntax?  I
> really prefer to stick with SQL for now since this will be paralleling
> another app that uses the same structure.

You can try double quotes:

    INSERT INTO class (name,"text",ID)

Or [] 

    INSERT INTO class (name,[text],ID)


Usually this is used when identifier have spaces.



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]