Android Question SQLCipher cursor

Discussion in 'Android Questions' started by RB Smissaert, Apr 17, 2019.

  1. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    As I understand it, the SQLCipher library (using the new 1.6 now) as it's own cursor. We are using though the regular standard SQL cursor. Is it possible to use this SQLCipher cursor instead of the standard one?
    Not sure there is any benefit in doing so, but just interested to know and compare.

    RBS
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    You always use SQLCipher cursor when you use SQLCipher. There isn't any other cursor.
     
  3. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    So, why then if I don't set a reference to the regular SQL library do I get:

    Unknown type: cursor
    Are you missing a library reference?

    On this line:

    Code:
    Dim Cursor1 As Cursor
    RBS
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    The wrapper object is implemented in SQL library. The wrapped object is in the native SDK.
     
  5. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    Sorry, don't understand this quite.
    Where does the SQLCipher cursor come into it then?

    RBS
     
  6. Erel

    Erel Administrator Staff Member Licensed User

    I'm sorry but you are asking about internal implementations. As I answered in the second post, there is no other cursor that you can use.
     
  7. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    OK, thanks.
    I don't understand what is going on exactly, but I understand that somehow I am using the SQLCipher cursor and that there is no other one to be used
    unless there is no reference to the SQLCipher library.

    RBS
     
  8. Erel

    Erel Administrator Staff Member Licensed User

    (Don't use Cursor. Use ResultSet instead.)

    Both Cursor and ResultSet are wrappers of interfaces. The actual implementation is hidden inside the specific SQL engine library.
     
  9. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    > (Don't use Cursor. Use ResultSet instead.)

    Yes, meant to be changing over, but is quite a bit of work and I have no plans for now to code in anything other than B4A.

    RBS
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice