TPgQuery fails if the select looks like this:
set enable_sort to off;
select
CATALOG_LINE_ID,
FIELD_2_VALUE
from CATALOG_LINE
where ZERO_CATALOG=false
order by FIELD_2_VALUE
First row causes the error:
Unexpected server response : þ
It can be solved. Please check it if you have time...
TPgQuery: Unexpected server response
-
- Posts: 15
- Joined: Tue 10 Oct 2006 09:06
TPgQuery: Unexpected server response
Last edited by meszarosistvan on Thu 10 Feb 2011 12:44, edited 1 time in total.
Hello
I executed the following SQL query and it works correctly:
Please provide me a SQL script for creating the CATALOG_LINE table. Also please provide delphi code that you are using to execute your query.
I executed the following SQL query and it works correctly:
Code: Select all
begin
PgConnection1.Open;
PgConnection1.ExecSQL('set enable_sort to off', []);
PgQuery1.SQL.Text := 'select * ' +
' from btest0 '+
' where id>1 ' +
' order by name';
PgQuery1.Open;
end;
-
- Posts: 15
- Joined: Tue 10 Oct 2006 09:06
Yes...
Hello,
You are absolutely right, I use the same.
Next week we should buy this component (everything is ok). After it, I will test it, and if I got something, I inform you.
Best regards.
You are absolutely right, I use the same.
Next week we should buy this component (everything is ok). After it, I will test it, and if I got something, I inform you.
Best regards.