I am having a problem with sending a SQL String from VB6 to either Crytal Reports v6 or v7.
String sent from VB6 code:
SELECT * FROM tblPartMaster WHERE PART = ‘1bb2bb3bb4’
BECOMES in Crystal Reports:
SELECT * FROM tblPartMaster WHERE PART = ‘1b2b3b4’
Where ‘b’ is a Blank Space!
NOTE: Each repeated space between the SINGLE QUOTES is compressed to a SINGLE Space. This is OK for the SELECT Statement but not OK inside the SINGLE Quotes. This makes the SQL WHERE and SQL BETWEEN commands unusable.
Any ideas, solutions or work arounds ?
