pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedODBC Insight Distribution Systems ERROR
2+ messages / 2 participants
[nested] [flat]
* ODBC Insight Distribution Systems ERROR
@ 1998-09-01 15:36 gefi <gefi@gefi.at>
0 siblings, 0 replies; 2+ messages in thread
From: gefi @ 1998-09-01 15:36 UTC (permalink / raw)
To: pgsql-interfaces
Hi!
When quering Postgres with Access 7.0 and the Insight ODBC-Driver I get
the error message "The field being orderd by must appear in the target
list".
My query was:
SELECT prog_name,prog_id FROM PROGRAMME ORDER BY PROGRAMME.prog_name;
I already applied the junkfilter-patch and updated the new Jet Engine.
The ODBC-Log says:
conn=76613756, query='BEGIN'
conn=76613756, query='declare SQL_CUR76770660 cursor for SELECT
"programme"."prog_id" FROM "programme" ORDER BY "prog_name" '
ERROR from backend during send_query: 'ERROR: The field being ordered
by must appear in the target list'
conn=76613756, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'
------------------------------------------------------------
hdbc=76613756, stmt=76770660, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT
"programme"."prog_id" FROM "programme" ORDER BY "prog_name" '
stmt_with_params='declare SQL_CUR76770660 cursor for
SELECT "programme"."prog_id" FROM "programme" ORDER BY "prog_name" '
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR76770660'
----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR: The
field being ordered by must appear in the target list'
------------------------------------------------------------
henv=77660292, conn=76613756, status=1, num_stmts=16
sock=77660308, stmts=77660348, lobj_type=-999
---------------- Socket Info -------------------------------
socket=69, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=76620048, buffer_out=76624148
buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2
Where is the problem??
mfG/GeFi
^ permalink raw reply [nested|flat] 2+ messages in thread
* ODBC Insight Distribution Systems ERROR
@ 1998-09-04 17:41 Gerald Fischer <pgsql@gefi.at>
0 siblings, 0 replies; 2+ messages in thread
From: Gerald Fischer @ 1998-09-04 17:41 UTC (permalink / raw)
To: pgsql-interfaces
Hi!
When quering Postgres with Access 7.0 and the Insight ODBC-Driver I get
the error message "The field being orderd by must appear in the target
list".
My query was:
SELECT prog_name,prog_id FROM PROGRAMME ORDER BY PROGRAMME.prog_name;
I already applied the junkfilter-patch and updated the new Jet Engine.
The ODBC-Log says:
conn=76613756, query='BEGIN'
conn=76613756, query='declare SQL_CUR76770660 cursor for SELECT
"programme"."prog_id" FROM "programme" ORDER BY "prog_name" '
ERROR from backend during send_query: 'ERROR: The field being ordered
by must appear in the target list'
conn=76613756, query='ABORT'
STATEMENT ERROR: func=SC_execute, desc='', errnum=1, errmsg='Error while
executing the query'
------------------------------------------------------------
hdbc=76613756, stmt=76770660, result=0
manual_result=0, prepare=0, internal=0
bindings=0, bindings_allocated=0
parameters=0, parameters_allocated=0
statement_type=0, statement='SELECT
"programme"."prog_id" FROM "programme" ORDER BY "prog_name" '
stmt_with_params='declare SQL_CUR76770660 cursor for
SELECT "programme"."prog_id" FROM "programme" ORDER BY "prog_name" '
data_at_exec=-1, current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1, lobj_fd=-1
maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0,
scroll_concurrency=1
cursor_name='SQL_CUR76770660'
----------------QResult Info
-------------------------------
CONN ERROR: func=SC_execute, desc='', errnum=10, errmsg='ERROR: The
field being ordered by must appear in the target list'
------------------------------------------------------------
henv=77660292, conn=76613756, status=1, num_stmts=16
sock=77660308, stmts=77660348, lobj_type=-999
---------------- Socket Info -------------------------------
socket=69, reverse=0, errornumber=0, errormsg='(null)'
buffer_in=76620048, buffer_out=76624148
buffer_filled_in=2, buffer_filled_out=0, buffer_read_in=2
Where is the problem??
mfG/GeFi
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~1998-09-04 17:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-09-01 15:36 ODBC Insight Distribution Systems ERROR gefi <gefi@gefi.at>
1998-09-04 17:41 ODBC Insight Distribution Systems ERROR Gerald Fischer <pgsql@gefi.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox