TADOQuery.Parameters on PostgreSQL

Hi,

Before switching on PostgreSQL, I was using MySQL where the following Code
(D7) was working well:

At design time, I have defined 2 parameters, by editing the SQL property:

select * from model where id_ctype = :id_ctype and
id_constructor = :id_constructor
and at run-time Active := True;

Further on, at run time I need to change the SQL property and then bring it
back to the original select:

with dmRef.qyModel do
begin
Close;
SQL.Clear;
SQL.Add('select * from model where id_ctype = :id_ctype and ' +
'id_constructor = :id_constructor');
Open;
end;

With MySQL, no problem. With PostgreSQL, I get an error with Open:

"An object parameter is not correctly defined. Non consistent or incomplete
information input"

Thanks for your answers.
hubert retif


.

Relevant Pages

  • Re: Effect of MySQL being acquired by Sun Micro
    ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... I didn't know SQL support was added that late. ...
    (comp.lang.php)
  • Re: Python, xml, databases, ...
    ... I think you want to be clear whether you want a database or not. ... Any machine can run a service (such as MySQL or PostgreSQL), ... both MySQL and PostgreSQL rely on the Cygwin dll. ...
    (comp.lang.python)
  • Re: Effect of MySQL being acquired by Sun Micro
    ... PostgreSQL did, so new developers (who only knew how to boot into ... Windows) picked MySQL. ... By the time Postgres became PostgreSQL, mSQL already had a strong foothold ...
    (comp.lang.php)
  • Re: pro- foreign key propaganda?
    ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
    (comp.databases.theory)
  • Re: Looking for a database
    ... >> The obvious choices on fedora will be MySQL and postgresql ... > If I was to chose between Postgresql and another free database it would ... > be between Postgresql and Firebird, ...
    (Fedora)