ABMaterial For Dummies provides examples for MySQL. The DBM code module in ABM shows how to init MySQL or SQLite (SQL) objects.
Personally, IMHO, I would
NOT use SQLite for a server DB - if it can be avoided (which is usually the case). Just search the hoops and bounds (headaches) you must accomplish to use it successfully on your server (on the forums).
Again, IMHO, SQLite is a compact DB - designed for
mobile devices - where it works flawlessly. Use an
industrial DB on servers (or lose your hair from stress (bad) - not from headboard extraction (good) ).
Your request is exactly how I started on my path with B4X - and ABM.
I use SQLite Expert to create (maintain) the device DB to include with the mobile app.
I use RDC to send data from devices (SQLite tables - device side) to server MySQL tables (server side) - effortlessly and seamlessly!
Same thing in reverse (server to device).
The SQL dialect is so similar (if not exact - between the two) that there are few times where you need to compensate for differences ( creating table structures does differ slightly - be aware - easily overcome ).
@Cableguy , I think you already know 99 percent of this - based on your many informative posts (and your Expert forum status confirms).
You are reaching for confirmation, of which you already know and understand, to assure your assumptions are correct.
I only wish that I would use this (your) reach out for support - before I steer myself down the wrong path based on my (flawed) assumptions.
Re-review (you went thru it once) the (specific) lessons on ABM for Dummies. However, it does not discuss SQLite connectors (jars) specifically.
Thanks
