Android Insert issue

[jamessteer]

I have two databases in my project, one for persistent data and one for dynamic player data.  The persistent data one works fine (this was the one I created first) and although the player database works absolutely as intended in Unity the second I run it on my android phone it just ignores any attempts to edit the player data.  I can Select query it and return values so I know it's looking in the right place but I just can't edit it.  It doesn't give me an error, it just skips past the line of code wherever I try to edit the data.  I can, however, update the other database from within my game running on android.

None of it makes any sense to me and is driving me round the bend.  Has anyone encountered similar before?

Thanks,
James

[jamessteer]

I should add I've got it set to use Android 9+ (now just Android since updating today), doesn't use system.data and I've tried setting the databaseFile.name but had no luck.

[echo17]

It sounds like you are using an older version of SimpleSQL since you are still seeing the Android 9+ option in the SimpleSQL options window. Try updating to the latest version from the Asset Store (v2.8.0 as of this post) and see if that helps.

[jamessteer]

Thanks mate but I already tried that. I was just trying to check that I was getting other error messages so deliberately gave the databaseFile.name a misspelled file name and it oddly triggered it into life and allowed me to write to the database. It feels a little temperamental to leave it that way but does that give any insight into a potential problem?

[echo17]

Not sure. It would just be guesswork, but perhaps Android imposed a read-only lock on the database file. If you renamed the file in the SimpleSQLManager inspector, that probably created a new file that did not have the same restrictions. If you renamed the file directly in the OS file system, that might have also removed the restrictions.

Really couldn't give you a certain answer to that one, unfortunately.