Troble with SQL

Results 1 to 4 of 4

Thread: Troble with SQL

  1. #1
    Lozza Guest

    Default Troble with SQL

    When re-using the same piece of code to move backwards through <BR>a recordset based on an SQL stored procedure (I&#039;m not at the begining!) it fails on one of my stored procudures but not another but only when I add an ORDER BY clause. Does anyone know why?

  2. #2
    Join Date
    Dec 1969

    Default RE: Troble with SQL

    I&#039;ve had a similar problem once, it was solved by using OLEDB in stead of ODBC. What kind of connection are you using?

  3. #3
    Lozza Guest

    Default RE: Troble with SQL

    OLEDB. I can&#039;t understand why the problem occurs. On the complex SP (using CASE statements etc and the ORDER BY clause) the code works. But on my simple SP which is more or less a SELEXT * FROM TABLE as soon as the ORDER BY clause is added it errors.

  4. #4
    Lozza Guest

    Default RE: Troble with SQL

    FYI. Found the problem. Started using a Keyset type recordset and use the default lock type, works fine.Ta

Posting Permissions

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