Page 1 of 1

Query with subqueries in vb.net

Posted: Wed 14 Oct 2009 06:31
by MavRik
I am getting an error for a query that works in MySql,
I am using Navicat, it runs when I open a query,
but I can't seem to save the query,
and Views don't allow subqueries,
and Stored Procedure won't run it either,

any help would be appreciated,
Mav

Posted: Wed 14 Oct 2009 06:52
by Duke
This forum is dedicated to Devart dbForge Studio for MySQL product. If you have problems using Navicat please contact its support team.

RE:

Posted: Wed 14 Oct 2009 06:58
by MavRik
Am I in the wrong forum?,

I am using script created by "dbForge Query Builder",
I only stated that I am using Navicat to execute script,
and that the script works in a MySql query,

My problem is that I can get script to work in VB.Net,

I have no problems in Navicat, it's a great product !

thanks,

Posted: Wed 14 Oct 2009 08:44
by Duke
My problem is that I can get script to work in VB.Net,
What component do you use to execute created script?

Posted: Wed 14 Oct 2009 19:09
by MavRik
Working in vb.net, using standard connect and getData procedure,
on loadForm...

thanks

Posted: Thu 15 Oct 2009 08:32
by Duke
MavRik wrote:Working in vb.net, using standard connect and getData procedure, on loadForm...
Standard connect means MySQL Connector.NET?