LiteDac latest version
Using Firemonkey to develop multi device app although mainly intended for iPhone5. Using SQLite3 database containing 6 tables. The app has menu option to retrieve data from a database on a remote server (over a VPN) and populate some tables in the database. The main function of the app is to select a site and a problem from the data retrieved and stored in the tables and send either Email/SMS to selected person/s. Details of the site/problem are then uploaded back to the remote database on server. When compiled for Win32, all works perfectly as it should.
When I compile to iOS device (iPhone5) data is retrieved and stored correctly (so the database is there and seems to work). However when I select a site and problem the data is not stored to the database table for that purpose (using TLiteQry). Have included a data grid only for testing purposes and it also shows there is no record created. The code used to insert a record is:
Code: Select all
TempServQry.Insert; ...assign values to fields TempServQry.Post;
Any help or advice would be greatly appreciated.