previous:
rescells.Clear;
rc := sqlite3_get_table(db, PChar(selectquery), @selres, @nRow, @nColumn,
@zErrmsg);
Result := rc = SQLITE_OK;
for i := 0 to nRow * nColumn - 1 do
begin
rescells.Add(selres[i]);
end;
if selres <> nil then
sqlite3_free_table(selres);
current, working
rescells.Clear;
rc := sqlite3_get_table(db, PChar(selectquery), @selres, @nRow, @nColumn,
@zErrmsg);
Result := rc = SQLITE_OK;
for i := 0 to (nRow+1) * nColumn - 1 do <---------- nRow+1 - it is works
begin
rescells.Add(selres[i]);
end;
if selres <> nil then
sqlite3_free_table(selres);
pt., 10 sty 2020 o 14:01 Clemens Ladisch <clem...@ladisch.de> napisał(a):
> Andy wrote:
> > I try "select rowid, field1,field2 from table" but first value was not
> > number rowid but literary string "rowid".
>
> Please show the actual code (not SQL, but your program) that you're
> executing.
>
>
> Regards,
> Clemens
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
