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

ODBC Insight Distribution Systems ERROR

From: gefi <gefi(at)gefi(dot)at>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: ODBC Insight Distribution Systems ERROR
Date: 1998-09-01 15:36:42
Message-ID: 35EC148A.6F9A4696@gefi.ml.org (view raw or flat)
Thread:
Lists: 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



pgsql-interfaces by date

Next:From: Mark FlemingDate: 1998-09-01 15:54:38
Subject: ODBC interface
Previous:From: Markus SchlupDate: 1998-09-01 13:07:36
Subject: JDBC ResultSet Serializable ???

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