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.
User Profile
Collapse
-
To pass sql query from VB6 to crystal reports
-
Hi Fish,
Thanx for your concern.
"Do you want to work with both as a single one or do you want work with each?
If you are mentioning the first, then I would like to stay that it is generally a bad practice."
Actually I am merging some village databases to its upper level i.e Subcenters or SCs database and then will use latter to generate reports. I am not going to manipulate ANY OF THE VILLAGE... -
Hi all ,
even I am also wanted to know the same thing....
I want to connect my mysql database with other computers on lan....
I am using VB6 as frontend and myodbc as connector...
Plz help.
GauravLeave a comment:
-
Hi vksingh
In simple words...I want to combine to identical Access databases into one and that to from vb6. Just need a hint to get started....can I do this by using adodc? or should I have to use some database object like
"dim db1 as database"
but I don't know how to manipulate this object? Jz need a little help.
Gaurav...Leave a comment:
-
and yeah I forget to mention that structures are same.
GauravLeave a comment:
-
Merging Two Access DATABASES
Hi All,
Just joined this site....I am really stuck into one problem. Actually I am writing a code in VB6 to merge TWO ACCESS DATABASES. Wanted to know if I can use a single sql query to merge. Is MERGE or UNION effective in merging two DATABASES. Plz help.
I am looking forward to get some positive replies.
Thanx in advance.
Gaurav
No activity results to display
Show More
Leave a comment: