Large SQLite database and appstudioFunctions.js

Right now, it’s looking like it could not have worked in older versions of AppStudio either. The problem is the statement which imports the database chokes because the database is too large.

That’s why I was asking if you had an older version of your app around, so we can see if verify that this is in fact the case.

It has worked reliably for about 5 years, through a number of versions of NSBasic. The database isn’t too large. Keep looking.

Hey guys,

I did finally find an older version of the project. I sent you the OneDrive link to it. Hope it helps.

As I mentioned in another mail, this SQLite utility has been in-use on at-least 3 versions of the iPhone and 2 or 3 versions of NSBasic. There has never been a problem on the iOS device dealing with this sized database.

Thanks,

-bruce

Thanks for sending the project. We’re testing it now.

We managed to reproduce your issue. It has now been fixed and will be in the next build.

It turns out we needed to import SQLite databases differently, depending on whether we are running as a native app or not.

Excellent! Thanks.

Just deployed from 8.5.3.4. Everything is functional again. Thanks guys!

Thanks for the good news!