|
-
Jul 25th, 2003, 02:40 PM
#1
Thread Starter
Junior Member
Invalid char in SQL in VB6 with Access97 ?
Hi all,
What's wrong with the next SQL-statement in VB6-code using ADO
to retrieve a recordset from an Access-database (97)
"SELECT ZAN_KNA1.KUNNR, ZAN_KNA1.NAME1, ZAN_KNA1.STRAS, ZAN_KNA1.PSTLZ, ZAN_KNA1.ORT01, ZAN_KNA1.LAND1, ZAN_KNA1.LOEVM From ZAN_KNA1 WHERE (((ZAN_KNA1.NAME1) Like " % " & [m_Name] & " % ") AND ((ZAN_KNA1.ORT01) Like " % " & [m_City] & " % ") AND ((ZAN_KNA1.LAND1) Like " % " & [m_Country] & " % "))"
m_Name etc. are variables with normal values.
% is the wildcard.
Help would be wonderful,
Greetings, Ger.
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
|