• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Can it be done?

LEGEND ,
Jan 25, 2007 Jan 25, 2007

Copy link to clipboard

Copied

I am attempting to use a column as a conditional, but my DBA upsized an old
Access application that used unorthodox naming method for the columns
('confirmation sent', 'invited?', etc)and then prodeded to write a bunch of
MSSQL Views off of them. Unfortunetly for me, MSSQL doesn't autoupdate when
the Views information when you rename the columns.

OK, I told you all that to ask you this. How can I get something like this
to work (with the space in it)

#GetAccepted.[confirmation sent]#

I keep getting an error with the '#' because of the brackets and I can't
remove the space or the who backend will fall out.

Any ideas?


TOPICS
Advanced techniques

Views

185

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 25, 2007 Jan 25, 2007

Copy link to clipboard

Copied

Where in your code are you attempting to do this?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 25, 2007 Jan 25, 2007

Copy link to clipboard

Copied

LATEST
#GetAccepted.[confirmation sent]#

This may not be what you really want to do, but if it is, the proper
syntax is no dot and quotes.

#GetAccepted["confirmation sent"]#

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation