Results 1 to 4 of 4

Thread: SQL Issue

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Posts
    2,165

    Default SQL Issue

    The issue where Text fields had to be at the end of a eSQL query was solved back in 19.1 or maybe earlier.

    the code when the fix was implemented was as below added to my code
    as suggested by Martin here

    https://support.dataaccess.com/Forum..._CURSOR_STATIC

    Code:
         Get SQLOpen of hoConnect to hoStmt
          If (hoStmt<>0) Begin
             Send SQLSetStmtAttribute of hostmt SQLSTMTATTRIB_CURSOR_TYPE SQL_CURSOR_STATIC
    This seems to not be ok in DF20

    This error/issue seems to have crept back into df20 as I have code that executes ok in 19.1 now throwing the Invalid Descriptor index error in DF20 for the same query and the above code no longer allows the query to execute.

    Is this an issue with Argument_Size being removed within df20 or something else?
    Last edited by Chris Spencer; 23-Aug-2022 at 06:42 AM.

Posting Permissions

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