Productive Computing, Inc. Support Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

SMF - Just Installed!

Pages: [1]   Go Down

Author Topic: Query string error  (Read 250 times)

tcpms

  • Member
  • *
  • Posts: 25
Query string error
« on: May 14, 2017, 01:19:43 PM »

What's wrong with this query string?

The 'execute' fails with an error 4000 - parsing error.

"SELECT * FROM Customer WHERE DisplayName = " & customers::QB DisplayName

Without enclosing the name in single quotes, the parsing error occurred on the first character of the  DisplayName saying it was expecting "true"....., "false"......

Enclosing the name in single quotes results in a parsing error objecting to the first single quote.
Logged
Pages: [1]   Go Up