PDA

Click to See Complete Forum and Search --> : Invalid use of vertical bars in query expression


bashfirst
Jun 29th, 1999, 10:51 PM
I'm trying to insert a record into a memo field of an Access database. The record contains vertical bars (| |). 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

Scuzy
Jun 30th, 1999, 11:04 AM
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.

bashfirst
Jun 30th, 1999, 11:44 AM
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