Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC:

SQLClasses modification? 23 Nov 2021 13:17 #20497

  • kitz


  • Posts: 61
  • Hello!
    I am trying to convert a VO program to X#.
    1.) In VO I have modified the SQL-Classes to not try to get a record count at SQLSelects and just close the selection but stay prepared if called again with same SQL-Statement but other parameters. (SQLString assignment).
    I have done this by just inheriting the SQLSelect class and add own methods/assigns.
    For X# how should that be done: Download the whole source of SQL-Classes and modify it? Or would it work with inheriting and additional methods/assigns?
    2.) since VO28 there is an additional SQL-option set (while connecting?), which is about how many records are allocated, which is fixed set to 1.
    This is in the SQLStatement class, which is called from the SQLSelect class. If I would like to remove this option setting (or make it changeable) I fear there is no other way but downloading the source and modify, because I can not influence SQLSelect to call a inherited class instead of SQLSelect. Or is there another way?
    BR Kurt

    Please Log in or Create an account to join the conversation.

    SQLClasses modification? 23 Nov 2021 14:34 #20500

    • ic2


  • Posts: 1183
  • Hello Kurt,

    Our strategy is that we try to find out how many different calls rely on the VO libraries. If it are not too many, we will try the .Net alternative which often offers more options and is maintained (which actually sometimes means something improves).

    E.g. we are converting the last Internet SDK calls (FTP, cHttP) to Chilkat calls (a library we already use)

    I would do the same for SQL classes I think.

    Dick

    Please Log in or Create an account to join the conversation.

    SQLClasses modification? 23 Nov 2021 15:27 #20503

    • kitz


  • Posts: 61
  • Hello Dick,
    as I use VO-GUI together with SQLSelect, it would be a major change to use .net SQL instead, which I have no time to spend for now.
    For sure I will change this, but that is a long way...
    BR Kurt

    Please Log in or Create an account to join the conversation.

    SQLClasses modification? 23 Nov 2021 18:00 #20504

    • robert
    • robert's Avatar


  • Posts: 2475
  • Kurt,
    I would start with trying to subclass the SQLSelect and SqlStatement classes.
    Of course I do not know what you have changed, but a lot should be possible in a subclass.
    And for 2) you can assign a new value to oStmt in the constructor of your subclass of SqlSelect, after you have called the constructor of the parent class. If you create a subclass of SqlStatement you can assign an instance of that class to oStmt.
    This will result in an extra allocation of a Statement object, but that should not really hurt.
    Make sure you destroy the existing oStmt object, so the allocated handles are freed as early as possible.


    Robert
    XSharp Development Team
    The Netherlands

    Please Log in or Create an account to join the conversation.

    • Page:
    • 1