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-






--
_______________________________________________
Lazarus mailing list
[email protected]
http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

Reply via email to