Re: Bind message has 6 results formats but query has 5 columns

On Dec 29 2008, 5:22 am, teemu(dot)juntu(dot)(dot)(dot)(at)e-ngine(dot)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(dot)(dot)(dot)(at)becsystems(dot)com(dot)au>
> To: <pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)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(dot)(dot)(dot)(at)postgresql(dot)org)
> > To make changes to your subscription:
> >http://www.postgresql.org/mailpref/pgsql-general
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)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??