[Lazarus] SQLite Oddity with simple Select clause

[Tommi Prami]

On 20.7.2011 4:34, Luiz Americo Pereira Camara wrote:
> On 19/7/2011 03:55, Tommi Prami wrote:
>> 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 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
>
>
> -- 
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus

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-