A second question along the same lines.
I modified the SQL Example to use my own SQLite db for testing purposes and compiled it.
The compilation merged possible files into it, minus one which it says should be distributed with the executable: SQLNative\Device\Syatem.Data.SQLite.dll
Basically what it comes down to is knowing what I need to compile and how to implement and include any necessary file along with the app so that it is functional.
I believe that the conversion of my project from HanDBase to Basic4PPC should be fairly easy, here's hoping, as the PPC side of it ONLY dealt with viewing a db, or in HDB's case multiple flat files, and making changes to one file that was then re-imported back into the main DB, mySQL at this time.
With the versatility of Revolution, which I use as my main programming environment, and Basic4PPC, I can convert my entire project to SQLite, and use Basic4PPC to manage a smaller SQLite db based off the main db for the handheld which will later be imported back into the whole.
Also, unless I'm wrong from what I've already gathered on the forums, it should be possible to:
- Have the main app installed and working (always nice, grin)
- the app can save the info locally to where the sqlite db is for access, typically a storage card, without constantly asking the user where the db is
- have the db on a storage card which is updated as required
- then either have the user copy the file back to there system (mac/pc) or possibly an activesync setup (pc)
Hmm, didn't really mean to go that far in depth, honestly.
But, I'm sure that someone has done something similar, so I thought I'd ask up front.
Best regards!