Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2005
    Thane, Maharashtra,India

    Unanswered: invalid syntax near keyword default (was "Why do I get the following error?")

    select * from CurrencyMaster where default=true

    invalid syntax near keyword default.

  2. #2
    Join Date
    Dec 2004

    The word Default is a reserved word

    You cannot have a reserved word as a field name without enclosing it in brackets.
    Therefore :

    select * from CurrencyMaster where default=true
    doesn't work, and
    select * from CurrencyMaster where [default]=true

    will probably work. (Haven't tested it myself tho....)
    The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts