SQLite and Basic4PPC

Discussion in 'Questions (Windows Mobile)' started by 2220, Jul 19, 2008.

  1. 2220

    2220 Member Licensed User


    I've just purchased the Basic4PPC for first time few days ago and I have some doubts about it. I'm just a newbie.

    I've been programming with Borland tools for a long time and I need to make some projects for PPC and I choose B4PPC. I need to know more abour SQLite and the GPS library. I actually work with MSSQL, MySQL and Interbase/Firebird.

    I'd like to know how I install the SQLlite in the PPC or if it's embedded within the application with a DLL. I'm acostumed to external engines, so I don't know.

    How can I mantain the Database? Can I use 2 Db at the same time, for example?

    Thank you.
    Last edited: Jul 19, 2008
  2. ceaser

    ceaser Active Member Licensed User


    Hi There

    I think it is very unfair of you to judge and come to a conclusion about B4PPC after only using it for a couple of days. I have been programming as a hobby for the last 20 years on a number of different platforms, ie. C++, Visual basic, OPL, Visual Studio, Fortran IV, NSBasic and now with B4PPC.

    Give the platform a fair chance and you will be surprised by the power of the platform.

    Don't be in a hurry!!!

  3. Erel

    Erel Administrator Staff Member Licensed User

    There is no need to install SQLite on the device.
    When you'll compile your application a native dll named System.Data.SQLite.dll will be copied to the executable folder.
    This dll should be distributed with the executable (to the same folder).

    Yes, you can work with more than one database. For each database create one Connection object and Command object.
  4. 2220

    2220 Member Licensed User


    Hi Michael,

    I choose B4PPC because it's great!
    I'm not judging, I just want to know how SQLite works with it. If it's embedded or not.
    I'm developer since 80's, so with very few days I cannot Jugde of course.

    I was just making a question. Nothing else.

    I've things very clear and I'll need some months to learn the whole package.


  5. 2220

    2220 Member Licensed User


    Thank You, that's what I want to know.

    I've searched a DB manager called SQLite Maestro. What's your opinion?

    As I can see, You have done a very great job. Congratulations!


    Last edited: Jul 19, 2008
  6. Erel

    Erel Administrator Staff Member Licensed User

  7. 2220

    2220 Member Licensed User

    Hi Erel,

    Sorry I'm not talking about Basic4Pcc yet, I'm building my dev platform at this time. First I need to build some automatic routines for transferring SQL Server Data to SQLite DB. Then I can begin to develop in B4PPC. I've purchased a ADO DB Driver for SQLite and it works fine.

    My question would be how can I protect my SQLite database. User's Login/Passwords exists? How do you make?


  8. Erel

    Erel Administrator Staff Member Licensed User

    You can use one of the Crypto libraries: Crypto or CryptoEx to encrypt the required fields in your db.
  9. 2220

    2220 Member Licensed User

    Thank You again Herel,

    Can I look up de code to rewrite this functions to Delphi to make encryption compatible with the PPC app. side?

    Which version of SQLite is best stable for Basic4PPC?

    Regards from Barcelona,


  10. Erel

    Erel Administrator Staff Member Licensed User

    You can find the code of Crypto.dll under Basic4ppc libraries folder (Crypto.cs).
  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