Selection query with limitation records

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
illusione
Posts: 13
Joined: Fri 12 Oct 2007 08:56

Selection query with limitation records

Post by illusione » Fri 12 Oct 2007 09:15

My direct 4.20 use trial version. I can not select a query with limitation records.

Code

Select * from DVD Limit 10

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Fri 12 Oct 2007 10:04

Which component do you use? Any exception raised?

illusione
Posts: 13
Joined: Fri 12 Oct 2007 08:56

Post by illusione » Fri 12 Oct 2007 13:22

Vbnet work and I created a web form.

I created a dataset I connected to a database with
Connection Wizard and I created a query with the
Design query using a tableadapter.

The query works but if usage LIMIT by mistake.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 15 Oct 2007 07:22

We will investigate this problem.
Look forward to hearing from me again.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 12 Nov 2007 16:44

We have analyzed the problem. This is MS DataSet restriction. MySQL-specific features are not supported in it and we cannot overcome this in present.

Post Reply