Renaming a database field programmatically 1

[tmarkou]

The following SQL statement is causing me a headache apparently because the word, "Local", is a SQL reserved word:

strSQL = "SELECT * FROM OfficeInfo WHERE Local=True"

When I run this SQL I get the following error:

Error Type:
(0x80004005)
Unspecified error
/ccdds/ListResults.asp, line 189

I'm using a Access database with VBScript. I cannot change the name of this field in the database so I must do it programmatically somehow. Someone suggested creating a another View of this particular table and change the field name in this view. Would this be a good way to go about solving this problem? If yes then how do I create another view and change the field value? Is there a better way to go about it? Maybe I'm just missing something.

 

[PHV]

Try this:

strSQL = "SELECT * FROM OfficeInfo WHERE OfficeInfo.Local=True"

Hope This Help
PH.

 

[tmarkou]

I've tried this but it doesn't work. I get the same error message.

 

[shaddow]

To access some fields named as reserved words you have to use "[]". This is valid for names with spaces.

Examples: [local],[local field]

strSQL = "SELECT * FROM OfficeInfo WHERE [Local]=True"


________
George, M

 

[tmarkou]

Thanks shaddow, that did it! I appreciate the help.