Results 1 to 3 of 3

Thread: Invalid use of vertical bars in query expression

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 1999
    Location
    Raleigh, NC
    Posts
    70

    Post

    I'm trying to insert a record into a memo field of an Access database. The record contains vertical bars (| &#0124. I get an error message of
    Err 3075
    Invalid use of vertical bars in query expression.

    I can't find any mention of vertical bars being a problem. Anybody know the right answer?

    TIA
    Bash

  2. #2
    New Member
    Join Date
    Apr 1999
    Location
    Clark County Washington
    Posts
    6

    Post

    Vertical bars are reserved in SQL to concatinate two strings together. To refer to them as characters and not directives try preceding them with backslashes.

  3. #3

    Thread Starter
    Lively Member
    Join Date
    Jun 1999
    Location
    Raleigh, NC
    Posts
    70

    Post

    Thanks... I was aware the | | did concatenation for other DB engines, but was unaware of it being a problem in Access. I did finally find mention of the usage in the help files in the Use values in expressions topic. Thanx

Posting Permissions

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



Click Here to Expand Forum to Full Width