Query with subqueries in vb.net

[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

[Duke]

This forum is dedicated to Devart dbForge Studio for MySQL product. If you have problems using Navicat please contact its support team.

[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,

[Duke]

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

What component do you use to execute created script?

[MavRik]

Working in vb.net, using standard connect and getData procedure,
on loadForm...

thanks

[Duke]

Working in vb.net, using standard connect and getData procedure, on loadForm...

Standard connect means MySQL Connector.NET?