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
OK, first row is always header, next rows are values of query,
pt., 10 sty 2020 o 13:56 Andy napisał(a):
> I don't know why sqlite3_get_table
> for 'SELECT rowid, id, Bytes, BytesCompr, flags FROM Articles where id=5
> limit 1'
> give me column names:
> rowid id Bytes BytesCompr flags
> instead
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 li
I don't know why sqlite3_get_table
for 'SELECT rowid, id, Bytes, BytesCompr, flags FROM Articles where id=5
limit 1'
give me column names:
rowid id Bytes BytesCompr flags
instead od values of this columns
pt., 10 sty 2020 o 13:36 Andy napisał(a):
> I successfully insert blob. I use sqlite3_last_
I successfully insert blob. I use sqlite3_last_insert_rowid afer calling
sqlite3_step.
But how to retrieve blob?
I try "select rowid, field1,field2 from table" but first value was not
number rowid but literary string "rowid".
I can get blob if I know rowid.
_
5 matches
Mail list logo