|
-
Jun 29th, 1999, 10:51 PM
#1
Thread Starter
Lively Member
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
-
Jun 30th, 1999, 11:04 AM
#2
New Member
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.
-
Jun 30th, 1999, 11:44 AM
#3
Thread Starter
Lively Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|