To pass sql query from VB6 to crystal reports

[gaubun]

Dear All,

I am using :
-> VB6
-> mysql
-> crystal report 8.5
-> Mysql odbc 3.51 Driver

Now my problem is:

I want to pass SQL query to the report from vb form.

I tried:
report.sqlquery string= str
report.database .verify

but it didn't workd.

Plz help!

Regards.

[QVeen72]

Hi,

Instead of passing SQL Query pass RecordSelection Formualll.
dont use "Str" as variable Name. It is a Function name in VB6

Regards
Veena