Bind message has 6 results formats but query has 5 columns

Hi,

I am using Delphi 2007 and turining property active false/true on
table/query component will refresh the component (and its fields). If you
are really using this query to drop columns of a table, then you shouldn't
add the fields of the table in the query component. After dropping a column
you could have a select result of 5 columns and fields for 6 columns.

Best regards,
Teemu Juntunen

----- Original Message -----
From: "J Ottery" <jottery@becsystems.com.au>
To: <pgsql-general@postgresql.org>
Sent: Saturday, December 27, 2008 7:47 AM
Subject: [GENERAL] Bind message has 6 results formats but query has 5
columns

On Dec 29 2008, 5:22 am, teemu.juntu...@e-ngine.fi ("Teemu Juntunen")
wrote:

Hi,

I am using Delphi 2007 and turining property active false/true on
table/query component will refresh the component (and its fields). If you
are really using this query to drop columns of a table, then you shouldn't
add the fields of the table in the query component. After dropping a column
you could have a select result of 5 columns and fields for 6 columns.

Best regards,
Teemu Juntunen

----- Original Message -----
From: "J Ottery" <jott...@becsystems.com.au>
To: <pgsql-gene...@postgresql.org>
Sent: Saturday, December 27, 2008 7:47 AM
Subject: [GENERAL] Bind message has 6 results formats but query has 5

columns

Windows XP, Using Delphi 7 ADO SQL Query Component to Drop/Delete a
Column from a simple table.
When I then try to query the table I get this error:

"Bind message has 6 results formats but query has 5 columns"

Obviously I need to refresh the connection or table but how?

I have tried
ADOConnection.Connected:=False;
ADOConnection.Connected:=True;

SQLTable.Close;
SQLTable.Open;

SQLTable.Fieldefs.Refresh;

All to no avial.

What is my solution to this?? Your contrib would be highly
aprreciated.

--
Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

--
Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general

Thank. I am nott adding fields in the query, just dropping one column
then trying to query the whole table again
As you stated "After dropping a column you could have a select result
of 5 columns and fields for 6 columns" is what is happening.
turining property active false/true on is not fixing this.
Any suggestions??