Alpha Video Training
Results 1 to 4 of 4

Thread: MOBILE - List based on SQLITE

  1. #1
    Member
    Real Name
    Paul Ammoun
    Join Date
    Oct 2012
    Location
    Beirut, Lebanon
    Posts
    224

    Default MOBILE - List based on SQLITE

    Hi,
    how can I make a list based on a sqlite table?
    is it possible to enter new data based on a SQLite ?

    I am looking for a solid way to build an offline application.

    Thank you for any recommendations

    Paul

  2. #2
    Member jgrannis's Avatar
    Real Name
    Jeff Grannis
    Join Date
    Apr 2016
    Location
    New Iberia, LA
    Posts
    344

    Default Re: MOBILE - List based on SQLITE

    I do this a lot. We are currently working on an app with over 30 SQLite tables (holding hundreds of MB of data) which can work for days at a time offline. I'm not sure I would do it again though; especially since the release where it is now possible to persist list data to the filesystem instead of only localstorage.
    In any case, all the Action Javascripts concerning SQLite actions are fairly clear and work well.
    To insert or update data, we simply add your data controls and when you are ready to save that data to the SQLite table, you could add a button that launches the Action Javascript - SQLite Actions - Execute a SQL statement. There you configure your explicit insert or update SQL.

    EDIT: And to populate the list, you again perform an "Execute a SQL statement" using a SELECT statement, get the resultArray which is provided to you and then use something like:
    lObj.populate(resultArray);
    Last edited by jgrannis; 10-04-2017 at 10:27 AM.

  3. #3
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,725

    Default Re: MOBILE - List based on SQLITE

    If you're looking to build an offline, not ever connected to a server, app... then I'd use SQLite. That's what I used for an Apple store app. All work with Lists you must do yourself, all sql statements to query, edit, update... you build yourself... in order to maintain the SQLite tables. I don't use Action Javascript... rather Javascript functions for various SQL activities.

    If you're looking to build an online/offline app then I agree with Jeff... use Lists and their persistent storage to the device filesystem functionality. With the recent addition of enhanced data cache features it's all very powerful stuff.

  4. #4
    "Certified" Alphaholic
    Real Name
    Jetson Lilibeth
    Join Date
    Dec 2011
    Posts
    1,092

    Default Re: MOBILE - List based on SQLITE

    May I ask for any assistance regarding how to query filesystemPreferred? I have some client side data cache on my offline app, How do I query the data on the filesystempreferred?
    Thanks!

Similar Threads

  1. Offline mobile database support (IndexDB, SQLite, ...)
    By nlights in forum Mobile & Browser Applications
    Replies: 3
    Last Post: 05-09-2014, 09:59 AM
  2. Replies: 2
    Last Post: 09-28-2013, 03:16 AM
  3. Replies: 0
    Last Post: 09-22-2013, 11:44 PM
  4. Mobile List - Drill Down Help
    By ssmoore1 in forum Mobile & Browser Applications
    Replies: 5
    Last Post: 09-02-2013, 12:23 PM
  5. Setting a mobile style sheet based upon the users browser
    By gmurph in forum Application Server Version 11 - Web/Browser Applications
    Replies: 7
    Last Post: 04-26-2013, 04:44 AM

Bookmarks

Posting Permissions

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