>Ok, this blows me away .. here is the query:
>
>INSERT INTO boatOptions (boatID,option) VALUES(13,'x')
>
>Simple enough? Well I am getting Syntax Errors with it..
>
>BoatID = Int
>option = VarChar (75)
>
>Am I missing something here ...?
Option is a reserved word (most likely). Use [option] and see if that helps.
(P.S. Don't use reserved words as a table or column name!) :)
--
Phillip Beazley
Onvix -- Website Hosting, Development & E-commerce
Visit http://www.onvix.com/ or call 727-578-9600.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
