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.freepascal.org/pipermail/lazarus/attachments/20110719/72b66262/attachment.html>

I dont know since you did not show your code. But i would bet is in your code.

Refetch data is for statement already executed.

Try calling Open.

Also please ready the tutorials:
http://sqlite4fpc.yolasite.com/documentation.php

Luiz

OK, it was my code, and I made some places where I change the SQL it to use

.Active := False;
.SQL := 'Select * from anywhere';
.Active := True;

And it started to work...

Weird part is that it worked some times/parts of my program and others not....

But anyways... thanks!!!

-TP-

This is because RefetchData requires the field list to be exactly the same:

Select x from table

Select x, y from table

RefetchData

Wont work

Luiz

OK,

That explains a Lot...

-TP-