[Lazarus] SQLite Oddity with simple Select clause

[Luiz Americo Pereira Camara]

On 20/7/2011 06:04, Tommi Prami wrote:
>
> 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....

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