Selection query with limitation records

Selection query with limitation records

Postby 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
illusione
 
Posts: 13
Joined: Fri 12 Oct 2007 08:56

Postby Alexey » Fri 12 Oct 2007 10:04

Which component do you use? Any exception raised?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby 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.
illusione
 
Posts: 13
Joined: Fri 12 Oct 2007 08:56

Postby 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

Postby 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.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL