Page 1 of 1
Selection query with limitation records
Posted: Fri 12 Oct 2007 09:15
by illusione
My direct 4.20 use trial version. I can not select a query with limitation records.
Code
Select * from DVD Limit 10
Posted: Fri 12 Oct 2007 10:04
by Alexey
Which component do you use? Any exception raised?
Posted: Fri 12 Oct 2007 13:22
by illusione
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.
Posted: Mon 15 Oct 2007 07:22
by Alexey
We will investigate this problem.
Look forward to hearing from me again.
Posted: Mon 12 Nov 2007 16:44
by Alexey
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.