TIBConectinon   SQLQuery.edit;   PROBLEM
lazarus / 16-Databases

----------------------------------------------------------------------
Fortuna1 · 2010-11-21 15:53

I install
fpc-2.4.2-20101120.i386.rpm
fpc-src-2.4.2-20101120.i386.rpm
lazarus-0.9.29.28360-20101120.i386.rpm
Suse 11.2
FirebirdSS-2.1.3.18185-0.i686


my data in table
data_key
111111
222222
333333

****** These case  work OK
********************************************* 
SQLQuery1.Close;
SQLQuery1.SQL.Clear;
SQLQuery1.SQL.Add('select  * from DATA ');
SQLQuery1.Open;
if not  SQLQuery1.EOF then
    begin;
    SQLQuery1.First;

    SQLQuery1.Edit;
    SQLQuery1.FieldByName('data_key').asInteger:=1234567;
    SQLQuery1.Post;
    end;   
*** These case  work OK
************************************************




****** These case  is PROBLEM ***************************************
SQLQuery1.Close;
SQLQuery1.SQL.Clear;
SQLQuery1.SQL.Add('select  * from DATA  where(data_key=111111)');
SQLQuery1.Open;
if not  SQLQuery1.EOF then
    begin;
    SQLQuery1.Edit;
                                  ERROR; 
***********************************************
SQLQuery1:   Dataset i read-only 
************************************  ************


    SQLQuery1.FieldByName('data_key').asInteger:=1234567;
    SQLQuery1.Post;
    end;   
****** These case  is PROBLEM ***************************************


                                  ERROR; 
***********************************************
SQLQuery1:   Dataset i read-only 
************************************  ************
What is wrong ?
Why Dataset i read-only ?
why  these case 
SQLQuery1.SQL.Add('select  * from DATA ');
edit work fine.

and these case 
SQLQuery1.SQL.Add('select  * from DATA  where(data_key=111111)');

SQLQuery1.edit;  -->  send message:

     **** SQLQuery1:   Dataset i read-only ****

----------------------------------------------------------------------
Lacak2 · 2010-11-22 04:05

Try put space between
"where" and "(data_key=111111)" so:
'select  * from DATA where data_key=111111'

----------------------------------------------------------------------
Fortuna1 · 2010-11-22 05:16

Quote from: Lacak2 on November 22, 2010, 05:05:12 amTry put space
between

'select  * from DATA where data_key=111111'
Amazing.

Thanks works great.

where(data_key=111111)
This is really utterly stupid example, because the error does not
answer but read the DataSet set read-only

and this works great.
where (data_key=111111)
I can not believe.
Very  crazy.

Big thanks.