Re: Bind message has 6 results formats but query has 5 columns
От | Teemu Juntunen |
---|---|
Тема | Re: Bind message has 6 results formats but query has 5 columns |
Дата | |
Msg-id | 566DC3EA9349426E9BA0D20F524B9328@eng02 обсуждение исходный текст |
Ответ на | Bind message has 6 results formats but query has 5 columns (J Ottery <jottery@becsystems.com.au>) |
Список | 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 по дате отправления: