|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 18th, 2005, 09:48 PM
|
|||
|
|||
What is the significance of a field named like this [size]
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. 
|
|
#2
February 19th, 2005, 01:25 PM
|
|||
|
|||
|
Dale
If you change the fieldname to "PantsSize" or "AsteroidSize" or "xSize", do you still have the problem? -- Good luck Jeff Boyce Access MVP "Dale" wrote in message ... 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.
|
|
#3
February 19th, 2005, 04:58 PM
|
|||
|
|||
|
"size" is a SQL-92 and ODBC reserved keyword. See the topic "Reserved
Keywords" in SQL Server Books Online. -- Brendan Reynolds (MVP) "Dale" wrote in message ... 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.
|
|
#4
February 21st, 2005, 05:22 PM
|
|||
|
|||
|
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. Brendan Reynolds wrote: "size" is a SQL-92 and ODBC reserved keyword. See the topic "Reserved Keywords" in SQL Server Books Online.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Prevent Blank Records being written. Need Help. | Robert Nusz @ DPS | Using Forms | 4 | December 29th, 2004 05:15 PM |
| Rowsource of Field List | Mark | Using Forms | 5 | December 20th, 2004 12:42 AM |
| New Record Update | Michelle | Using Forms | 5 | October 28th, 2004 07:59 AM |
| Autonumber | Ally H. | General Discussion | 7 | August 27th, 2004 04:51 PM |
| Make a field lookup dependent on the value in another field of a record? | Susan A | Database Design | 8 | May 22nd, 2004 09:10 PM |
Linear Mode
