Re: Bind message has 6 results formats but query has 5 columns - Mailing list pgsql-general

From Teemu Juntunen
Subject Re: Bind message has 6 results formats but query has 5 columns
Date
Msg-id 566DC3EA9349426E9BA0D20F524B9328@eng02
Whole thread Raw
In response to Bind message has 6 results formats but query has 5 columns  (J Ottery <jottery@becsystems.com.au>)
List pgsql-general
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


> 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-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Reg Me Please
Date:
Subject: Re: [PGSQL 8.3.5] Use of a partial indexes
Next
From: "dbalinglung"
Date:
Subject: Re: Load Image File From PostgreSQL DB