What is the significance of a field named like this [size]

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

in and SQL Server table? ... I have a table that I'm trying to run some
queries on using ADO and when I have a SELECT with the field name called
size without square brackets, my VB program craps out on me. I got
stuck on this for a while until I looked at the table in SQL Server and
noticed 2 fields with square brackets include this size one. I checked
and didn't find size to be a reserved word. Thanks.
 
Dale

If you change the fieldname to "PantsSize" or "AsteroidSize" or "xSize", do
you still have the problem?
 
"size" is a SQL-92 and ODBC reserved keyword. See the topic "Reserved
Keywords" in SQL Server Books Online.
 
Thanks for the responses guys.

Brendan, I just did a deeper search and see that it's and ODBC reserved
- that's probably how I missed it during my initial searches.
 
Back
Top