near "LIMIT": syntax error

ďťż

Pokrewne:

Cytat:

near "LIMIT": syntax error

BugTracker - Pią Lis 16, 2007 9:51 pm
" />A bug report

Repeatable: yes

Description:
Describe the problem, operating system, SQLiteStudio version and if you know the recipe to invoke it, please put it in here too.

The OS is Windows XP Pro 1GB ram

near "LIMIT": syntax error
while executing
"::database0 eval {select * from w3 where domain like '%.net%' order by domain;
LIMIT 1000 OFFSET 3000} R {
set data [list]
foreach id $R(*) {
..."
("uplevel" body line 1)
invoked from within
"uplevel "$_db eval $args""
(object "::dB0" method "::DB::eval" body line 1)
invoked from within
"$db eval "$_queryForResults LIMIT ${::TableWin::resultsPerPage} OFFSET [expr {${::TableWin::resultsPerPage}*$_page}]" R {
set data [list]
foreach ..."
(object "::editorWin0" method "::EditorWin::reloadData" body line
invoked from within
"reloadData"
(object "::editorWin0" method "::EditorWin::lastRows" body line 4)
invoked from within
"::editorWin0 lastRows"
invoked from within
".mainWin.d.r.win2.main.tabs.results_tab.tabs.t1.toolbar.tb.tbframe.grp_default.w4 invoke "
invoked from within
".mainWin.d.r.win2.main.tabs.results_tab.tabs.t1.toolbar.tb.tbframe.grp_default.w4 instate {pressed !disabled} { .mainWin.d.r.win2.main.tabs.results_ta..."
(command bound to event)

Googie - Pią Lis 30, 2007 10:11 pm
" />Fixed.

Darmowy hosting zapewnia PRV.PL