Skip site navigation (1) Skip section navigation (2)

Bind message has 6 results formats but query has 5 columns

From: J Ottery <jottery(at)becsystems(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Bind message has 6 results formats but query has 5 columns
Date: 2008-12-27 05:47:39
Message-ID: 7744a16c-bdcd-4dce-bcb2-48735a602db6@n33g2000pri.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-general
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.




Responses

pgsql-general by date

Next:From: David FetterDate: 2008-12-27 07:10:43
Subject: Re: WITH AS vs subselect was: count (DISTINCT expression[ , ... ] ) and documentation
Previous:From: Eric WordenDate: 2008-12-27 03:15:44
Subject: "disappearing" rows in temp table, in recursing trigger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group