 |
kymon
Novice
Joined: 29 Jan 2003
Posts: 40
|
 Posted: Thu May 15, 2003 8:47 am
[zmud 6.62] mapper, find room, "'"
|
i get an error message when searching for a room with a "'" character in it, like "algar's store". this is the message i get:
Syntaxfehler in Abfrageausdruck '(Name LIKE '%'%') ORDER BY [ObjID]'
roughly translates to: syntax error in question statement ...
since i haven't seen that problem reported yet, i guess it's language specific. i'm using a german windows xp version.
i didn't have that problem with zmud 6.40. |
|
|
|
|
Daagar
Magician
Joined: 25 Oct 2000
Posts: 461
Location: USA
|
Posted: Fri May 16, 2003 6:24 pm
|
How are you searching for the room? Via the 'Find' button, or is this a custom script? If it is a custom script, you may need to escape the ' character by searching for "algar''s store" instead (note the use of two single quotes). This is correct for Oracle databases at least... not sure if JET uses the same escape character.
|
|
|
|
|
kymon
Novice
Joined: 29 Jan 2003
Posts: 40
|
Posted: Sat May 17, 2003 7:24 am
|
i'm using the find button, ctrl-f in the mapper window
|
|
|
|
|
|
|
|
