Titanium Community Questions & Answer Archive

We felt that 6+ years of knowledge should not die so this is the Titanium Community Questions & Answer Archive

Sqllite DB Problem

I have created a Script that Will add and Subtract Users from an Sqllite Db the db is called test.sqlite I Get 2 errors upon running the script
<script src='http://pastie.org/1028962.js'></script>

The Main Script Script is:
<script src='http://pastie.org/1028963.js'></script>

The Sqllite Code is:
<script src='http://pastie.org/1028952.js'></script>

I am new to Sqllite and Titanium so Any help is appreciated and I thank you in Advance. The Script Works just fine when i run it in my test Server it just wont work when i hit the Package and test Button in Titanium.. Thank you

— asked July 3rd 2010 by Robert Skillings
  • appcelerator
  • db
  • desktop
  • problems
  • sqlllite
  • titanuim
0 Comments

4 Answers

  • I don't believe we have SQLite support enabled in our PHP build. You may instead
    want to use our Titanium.Database interface instead.

    — answered July 3rd 2010 by Josh Roesslein
    permalink
    0 Comments
  • Will Somebody please give an Example for this instead of just pasting the link to titaniums db and How do i In fact access it give an example that creates a table and adds an ID,User,Password for Collums. Do not point me to Kitchen Sink because I have tried and it does not work for me at all I cant get the Android or Iphone Sim working

    — answered July 3rd 2010 by Robert Skillings
    permalink
    0 Comments
  • Okay I did a bit of investigation and this SQLite extension should be built into our PHP build.
    I did a quick test on OSX and was able to call the sqlite_open() method just fine.

    I think the issue is the dl() call at the end of your file. Do not use that method.

    — answered July 4th 2010 by Josh Roesslein
    permalink
    0 Comments
  • That worked But Know I have an error with the opening

    Fatal error: Call to undefined function sqlite_open() in C:\Users\Admin\Desktop\Raproductions_Inventory\Raproductions_Inventory\dist\win32\Raproductions_Inventory\Resources\Add_Delete_User.php on line 131

    — answered July 4th 2010 by Robert Skillings
    permalink
    0 Comments
The ownership of individual contributions to this community generated content is retained by the authors of their contributions.
All trademarks remain the property of the respective owner.