1. Forum
  2. Usenet
  3. COMP.LANG.CLIPPER.VISUAL-

  • SQLListTables:Destroy

    From Henry Fidler@21:1/5 to All on Mon Jul 12 04:10:25 2021
    After using the SQLListTables, the program crash with an error "SQLListTables:Destroy is not an exported method".

    At the end of using the class, I tried to assign to it a Null_Object, but it does not help.

    I read in this forum in: “https://groups.google.com/g/comp.lang.clipper.visual-objects/c/DE2TT2Uc0xs/m/pi--85ZIN2UJ”
    That replacing the VO28SQL.DLL from SP2 with that from SP1 helps.
    Not in my case.

    Any help
    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Wolfgang Riedmann@21:1/5 to Henry Fidler on Mon Jul 12 16:32:59 2021
    Hi Henry,

    what VO version dou you are using?

    Wolfgang

    Henry Fidler wrote:

    After using the SQLListTables, the program crash with an error "SQLListTables:Destroy is not an exported method".

    At the end of using the class, I tried to assign to it a Null_Object,
    but it does not help.

    I read in this forum in: “https://groups.google.com/g/comp.lang.clipper.visual-objects/c/DE2T T2Uc0xs/m/pi--85ZIN2UJ” That replacing the VO28SQL.DLL from SP2
    with that from SP1 helps. Not in my case.

    Any help
    Henry



    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Mon Jul 12 22:29:29 2021
    CaVo 2.8, SP2
    I tried to copy the Vo28SQL.dll from 2.8 SP1
    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Wolfgang Riedmann@21:1/5 to All on Tue Jul 13 10:02:05 2021
    Hi Henry,

    CaVo 2.8, SP2
    I tried to copy the Vo28SQL.dll from 2.8 SP1

    the easiest option for you would be to build a class

    class SQLListTablesEx inherit SQLListTables

    add a fancy Destroy() method:

    method Destroy() class SQLListTablesEx

    and use that class in your application.

    I cannot check that as I have VO SP4b running and no access to any
    previous version.

    Wolfgang

    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Henry Fidler@21:1/5 to All on Thu Jul 15 12:44:03 2021
    Wolfgang many thanks

    I did what you have suggested,
    I do not know what the method Destroy() should do, so I have just
    Self:Close()

    Until now it works OK.

    Thanks
    Henry

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Wolfgang Riedmann@21:1/5 to All on Fri Jul 16 09:48:09 2021
    Hi Henry,

    I did what you have suggested,
    I do not know what the method Destroy() should do, so I have just
    Self:Close()

    Until now it works OK.

    I had written an empty method, only to suppress the runtime error.

    Wolfgang


    --

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jamal@21:1/5 to Henry Fidler on Fri Jul 16 10:32:16 2021
    You were getting the error because there is no such Destroy() method for
    the SQLListTables class.

    The only two classes that have the Destroy() method are: SQLStatement
    and SqlParameter classes. Unrelated, but just in case you use
    SQLParameter, according to the SDK, "If you instantiate a SQLParameter
    object, you should explicitly destroy it when you are finished using it".

    And remember the Close() method only closes the cursor, not the connection.

    Jamal

    As you found, the Close() method should work fine.

    On 7/15/2021 3:44 PM, Henry Fidler wrote:
    Wolfgang many thanks

    I did what you have suggested,
    I do not know what the method Destroy() should do, so I have just
    Self:Close()

    Until now it works OK.

    Thanks
    Henry


    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)