[Lazarus] SQLite Oddity with simple Select clause

[Tommi Prami]

Hello,

I have Day or two old SVN (Trunk) Lazarus with FPC 2.4.4

I have simple select with simple where clause. Nothing fancy.

If I run exact same SQL with SQLite Expert Personal I get the rows as 
expected.

I looked my code, and did some debugging into the SQLite code, and this 
happened.

1. I call the .RefetchData;

Then I Step into the  Sqlite3DS unit TSqlite3Dataset.BuildLinkedList method.

It successfully calls the sqlite3_prepare() etc...
  This code seems odd to me, but some parts of my App works perfectly so 
maybe this is just something that it does not seem to be :

...
   FRecordCount := 0;
   ColumnCount := sqlite3_column_count(vm);
   FRowCount := ColumnCount;
...

Then comes the :
   FReturnCode := sqlite3_step(vm);
   while FReturnCode = SQLITE_ROW do
   begin

loop, Which I think would fetch the Actual data.

And first call (Outside the Loop returns ReturnCode 101 
(SQLITE_DONEhttp://www.sqlite.org/c3ref/c_abort.html )...

What in earth is going on... Any ideas What might be wrong in here? In 
mY Code or the SqLite Code.

I have similar selects in other parts of the Code and even in same File 
and Same Table and they seem to work... Is there anything I should 
try??? Any ideas are welcome...

-TP-






-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20110719/72b66262/attachment-0002.html>