Mysql Select with limit throws error

[husibilski]

Hello,

I’ve to build some applications where only a part of the table should be shown. So I used Mysql Select Limit. It works fine when I used limit 20, the first 20 records where shown. But when I used an offset limit 20, 40 a database error was thrown. Here is the query

SELECT
RANG,
TEAM,
PUNKTE,
ZEIT,
STATIONEN
FROM
zwischenergebnis
order by rang
limit 20, 999;

I’ve attached the screenshot. I think SC mixed up the query. This query works in a SQL editor. Is there an other solution?

[ATTACH=CONFIG]n76235[/ATTACH]

I hope someone can help.

Thanks in advance

Hans-Uwe Sibilski

[bdl]

Hi Hans-Uwe

Try saving it as a MySQL View (easiest using the Database Builder in Scriptcase itself). Then test the view to make sure it works OK on its own. Lastly, base your Scriptcase app on the new view and not on the SQL statement. You may need to close the project and re-open it to get the new view to show up in the list of available data sources.