Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
TOP or LIMIT parameter usage |
Author |
Message |
|
Posted : 2006-11-13 19:08:27 |
I can't get TOP or LIMIT to work on the SQL Select command... Are they supported? Are they supported in Version 4?
I'm using the ODBC driver for a web site and when the user selects a lot of records, I'd like to limit the results to 100 records so it doesn't bog down the server or time out the user's browser. The unregistered versions do this already, but I'm guessing it's internal.
Thank you in advance... |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-14 08:18:40 |
This example using the sample ALLHITS database should help:
SELECT TOP 10 * from ALLHITS Order by WEEKS desc
|
|
|
|
|
Posted : 2006-11-14 17:43:53 |
That doesn't work in Version 3.10.10... what version are you using? Any other suggestions? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-15 08:10:39 |
I'm using FlexODBC v4.00.21. You will need to upgrade. |
|
|
|
|