[Lazarus] SQLite Oddity with simple Select clause

[Tommi Prami]

On 21.7.2011 2:50, Luiz Americo Pereira Camara wrote:
> 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

OK,

That explains a Lot...

-TP-