Hello Tim,
  Lines:
    SQL.Add('INSERT INTO Data');
    SQL.Add(Format('VALUES (%d, %d, %d, ''%s'', %d, :Param1, :Param2,
      NULL, CURRENT_TIMESTAMP, %d, ''test'')',
    [1, 0, 1, 'test', 1, 1]));
    Params[0].Text := 'Param1';
    Params[1].Text := 'Param2';
    ExecSQL;

  Error:
   An error was found in the statement at line 2 and column 69
   (Invalid expression ? found, dynamic parameter references not
   allowed).

I'm getting this #700 error only when using parameters.

--
Charalabos Michael - [Creation Power] - http://www.creationpower.com -
http://www.creationpower.gr

Michael,

<< I'm getting this #700 error only when using parameters. >>

I can't replicate this.  This code:

  with EDBQuery1 do
     begin
     SQL.Text:='INSERT INTO Customer (CustNo, Company) VALUES (:Param1,
:Param2)';
     Params[0].AsInteger:=100;
     Params[1].AsString:='Test';
     ExecSQL;
     end;

doesn't do it, for example.  Could you send me the catalog that you're using
?  There's no need to send the table itself.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

> << I'm getting this #700 error only when using parameters. >>
>
> I can't replicate this.  This code:
>
>    with EDBQuery1 do
>       begin
>       SQL.Text:='INSERT INTO Customer (CustNo, Company) VALUES (:Param1,
> :Param2)';
>       Params[0].AsInteger:=100;
>       Params[1].AsString:='Test';
>       ExecSQL;
>       end;
>
> doesn't do it, for example.  Could you send me the catalog that you're using
> ?  There's no need to send the table itself.

You've fixed in Build 7 but it doesn't intert the data into the table.
Eg.

Params[0].Text := 'Hello';

after posting the record the field's data is empty instead of 'hello'.

--
Charalabos Michael - [Creation Power] - http://www.creationpower.com -
http://www.creationpower.gr

Michael,

<< You've fixed in Build 7 but it doesn't intert the data into the table.

Eg.

Params[0].Text := 'Hello';

after posting the record the field's data is empty instead of 'hello'. >>

Thanks, it's fixed.  It was an assignment issue with CLOB fields.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello Tim,

> << You've fixed in Build 7 but it doesn't intert the data into the table.
>
>  Eg.
>
>  Params[0].Text := 'Hello';
>
>  after posting the record the field's data is empty instead of 'hello'. >>
>
> Thanks, it's fixed.  It was an assignment issue with CLOB fields.

I'm still having the same problem in build 8. Are you sure it's fixed ?

--
Charalabos Michael - [Creation Power] - http://www.creationpower.com -
http://www.creationpower.gr

Michael,

<< I'm still having the same problem in build 8. Are you sure it's fixed ?
>>

Most definitely.  I just tried it again and it worked fine.

--
Tim Young
Elevate Software
www.elevatesoft.com