TMSTable - problem with field names that start with a number
Posted: Sun 07 Feb 2010 04:46
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
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