ODBC Insight Distribution Systems ERROR
От | gefi |
---|---|
Тема | ODBC Insight Distribution Systems ERROR |
Дата | |
Msg-id | 35EC148A.6F9A4696@gefi.ml.org обсуждение исходный текст |
Список | 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 по дате отправления: