Page 1 of 1

TMSTable - problem with field names that start with a number

Posted: Sun 07 Feb 2010 04:46
by yylee
Hi

I have a table that has a few fields that are named as '1XL_Size' and '2XL_Size'. When I insert new records via the TMSTable component, it returns an 'Incorrect Syntax near '1'' error. I am sure that '1' is from the 1XL_Size field. I try re-naming the fields in the component as [1XL_Size], but when the application starts it complains about this field not present. Any idea how to get around this?

thanks
David

Posted: Mon 08 Feb 2010 07:56
by Dimon
To solve the problem try to set the TMSTable.Options.QuoteNames property to True.

Posted: Tue 09 Feb 2010 04:21
by yylee
it works, thank you!