Option keyword problem 2

[Sims, John (CDC/CCHP/NCBDDD) (CTR)]

> -----Original Message-----
> From: valentina-bounces at lists.macserve.net 
> [mailto:valentina-bounces at lists.macserve.net] On Behalf Of Chuck Neal
> Sent: Friday, August 18, 2006 10:44 AM
> To: Valentina Developers
> Subject: Option keyword problem 2
> 
> I managed to fix my code that had a database named "option" 
> but now I am having a similar problem on a table that has a 
> field named option.  Here is the insert query I am trying to use...
> 
> INSERT INTO Technique_Option (technique,dataField,parameter, 
> option,ID) VALUES ('S546GA-12384UO-5UUP6M-R', 
> 'I2G8L5-11Q5GIK-T47Q0I-2T', 'S546GA-1280JFG-2DJK2H-2', 
> 'J2I5NG-12ALET9-2NJMT-7', 'S546GA-12EB5HB-4JJ5VF-1' )
> 
> I have tried option in single quotes, double quotes, back 
> ticks, even with the table name in front and everything 
> errors the same way.
> 
> Error: line 1:1: unexpected token: option
> 
> 
> Is there any way to escape this so that it will allow the field name? 
> Changing all of my databases is just not an option at this 
> point, so I need to find a way to work around the data name 
> issue.  Thanks.
> 
> -Chuck
> --------------------------
> Chuck Neal
> CEO, MediaMacros, Inc.
> chuck at mediamacros.com
> http://www.mediamacros.com
> http://www.mediamacros.net
> 

Hi Chuck,

Have you tried square brackets [option]?  I'm not sure if that is an SQL
standard or if it will work in Valentina but I know a lot of DBMS use
them.

Good luck!

-John