Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Question Unanswered: error -309 using order by via ODBC

    Hello,
    we have migrated our database to IDS 9.21 and work with it via ODBC
    SDK 2.81.TC2 and IBM Informix 3.82.
    Starting a select statement with an 'order by', i get now an error message 309, if the field i wish to sort is not a primary key.
    Is this a known problem or can anyone help us?

    Thanks in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: error -309 using order by via ODBC

    Originally posted by MEP
    Hello,
    we have migrated our database to IDS 9.21 and work with it via ODBC
    SDK 2.81.TC2 and IBM Informix 3.82.
    Starting a select statement with an 'order by', i get now an error message 309, if the field i wish to sort is not a primary key.
    Is this a known problem or can anyone help us?

    Thanks in advance
    Hi,

    Verify the syntax SQL.
    column-name must be in SELECT list

    Gustavo.

  3. #3
    Join Date
    Oct 2003
    Posts
    2

    Re: error -309 using order by via ODBC

    Originally posted by gurey
    Hi,

    Verify the syntax SQL.
    column-name must be in SELECT list

    Gustavo.
    Dear Gustavo,

    certainly the ordered column is in the select list.
    The problem is, that the order by only gets a result
    if i try it with primary keys or parts of it.
    The problem isn't as simple as you believe.
    I hope ther exists an other solution.

    Greatings from
    Monika

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •