Page 7 of 7

Support for local SQLite datasources

Posted: Fri Aug 16, 2013 2:13 pm
by Rutger van Dijk5994263

Don't know what you mean? You have some database with data and you want it to be stored in local db.

You must create inserts based upon this db file. You can do without internet connection, but I prefer to do it with online db cause than I can import when I have internet and use it without.


Support for local SQLite datasources

Posted: Fri Aug 16, 2013 3:01 pm
by Toblerone

Yes, I have a .db already filled with products, i dont want to have to create the DB using a load of inserts etc. I just want to attach the .db file I already have and use that.


Support for local SQLite datasources

Posted: Fri Aug 16, 2013 8:09 pm
by Kateryna Grynko

Hi,

Please take a look at here:
http://hansjar.blogspot.com/2013/04/h... and http://www.raymondcamden.com/index.cf...

You can't add file with prepopulated database to your app yet. You can add this in Eclipse/xCode.


Support for local SQLite datasources

Posted: Wed Aug 21, 2013 3:03 pm
by ApperyAmateur

If anyone manages to do this with eclipse, could you post a tutorial.

Thanks


Support for local SQLite datasources

Posted: Fri Aug 23, 2013 9:24 pm
by Ravi Wayne

Hello,

I am trying to implement sqllite interface based on the tutorial referenced in this link. My goal is to populate the local DB from REST services instead of using the appery DB.

I am trying to implement the javascript logic in the Complete event of the service. Able to get to create the local table, but run into problems with populating data.

I want to see if this is the best place to implement the javascript logic to create local tables and populate data from rest service.

Thank you.


Support for local SQLite datasources

Posted: Sat Aug 24, 2013 8:06 am
by Dan Sweeney

Thanks for that.

I've got my label within the collapse block setting the color now.

I've put the code in the expand event because it doesn't seem to work in the value change event.

I do need to change the collapse block header text color too if possible and have tried putting the following in the value change event of the collapse block and the list item but it's not doing anything:

var thisItem = this;
Appery('mCollapseHeaderWOut',this).css('color', 'DarkOrange');

I've also put an alert in the value change event but it's not firing at all.

Any ideas?


Support for local SQLite datasources

Posted: Tue Aug 27, 2013 6:18 am
by Maryna Brodina

Hi,
[quote:]I want to see if this is the best place to implement the javascript logic to create local tables and populate data from rest service[/quote] it's better to use not Complete event, but service Success event. See http://docs.appery.io/documentation/u...


Support for local SQLite datasources

Posted: Sat Sep 07, 2013 9:19 am
by William Lewis

would you or anyone else """"KINDLY"""" fill in the missing steps to this...

http://docs.appery.io/tutorials/build...

dubious tutorial especially line 12 - specific step by step instructions would help greatly. Talk about frustration - this is turning into a wild goose chase!


Support for local SQLite datasources

Posted: Sat Sep 07, 2013 9:27 am
by William Lewis

if ANYBODY has figured out how to do will you kindly upload a "FOLLOWABLE" tutorial? I'm tired of "hints" that go nowhere.


Support for local SQLite datasources

Posted: Sat Sep 07, 2013 9:36 am
by Alena Prykhodko

Check this http://docs.appery.io/tutorials/build...
You can execute it on page load. Screen-Load-Invoke service.