User Tag List

Page 2 of 2 FirstFirst 1 2
Results 11 to 18 of 18

Thread: SQLite3 and SQLite3 PRO for Clickteam Fusion 2.5

  1. #11
    Clicker Fusion 2.5 Developer

    Join Date
    Jun 2011
    Location
    East of Africa
    Posts
    213
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

  2. #12
    Clicker Fusion 2.5 Developer
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)
    Fetito's Avatar
    Join Date
    Nov 2012
    Location
    Buenos Aires, Argentina
    Posts
    54
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    @Nyc: Thank you! Could you also recommend a book or a video tutorial?

    I am rather interested in an "offline"-database, because I do not want to upload the SQLite DB.

  3. #13
    Clicker Fusion 2.5 Developer

    Join Date
    Jun 2011
    Location
    East of Africa
    Posts
    213
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    SQL works almost the same regardless of the database system you use. The syntax for SQLite, MySQL, and other SQL based system is almost the same. I don't know any video tutorial perhaps searching the web may help.

  4. #14
    Clicker Fusion 2.5 Developer
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)
    Fetito's Avatar
    Join Date
    Nov 2012
    Location
    Buenos Aires, Argentina
    Posts
    54
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    @Nyc: Yay! Thanks!

  5. #15
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export Module
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)

    Join Date
    Jul 2014
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Did the Unicode version ever eventuate? Got problems ordering results on a Unicode dataset. (Work around is read results into an object and sort them there) - but some results may be obscured.

    - Or is there another option, like ODBC?

    Also apols for digging up a long dead thread.

  6. #16
    Clicker Fusion 2.5 MacFusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export ModuleXNA Export ModuleUnicode Add-on
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Fusion 2.5+ DLC (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)Universal Windows Platform Export Module (Steam)Firefly 3D Module (Steam)
    Phi's Avatar
    Join Date
    Jan 2010
    Location
    England
    Posts
    2,056
    Mentioned
    25 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by feral View Post
    Or is there another option, like ODBC?
    SQL ODBC object (my one) is the most recent SQL ext, and I believe it can handle Unicode text. Been a while since I worked on it, though.
    If you want it, you can get via signing up to my Patreon. One off payment is fine, but monthly helps pay for more exts and service maintenance (like Darkwire ext list and Lacewing servers).

  7. #17
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export Module
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)

    Join Date
    Jul 2014
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks @phi yes, aware of your Patreon, I know you have other cool stuff locked away in there too. Thanks for making me re-aware of it Jumped right in!

    Excuse: I stuck this issue on the backlog and have finally returned to it.

    And apologies I missed your response, really don't check in here often enough!

  8. #18
    Clicker Fusion 2.5 DeveloperAndroid Export ModuleHTML5 Export ModuleiOS Export ModuleSWF Export Module
    Fusion 2.5 (Steam)Fusion 2.5 Developer (Steam)Android Export Module (Steam)HTML5 Export Module (Steam)iOS Export Module (Steam)

    Join Date
    Jul 2014
    Posts
    8
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Further research, as the DB is Sqlite, generated by another app (Mediamonkey) that I can probably use this driver: http://www.ch-werner.de/sqliteodbc/, some mucking around in ODBC admin and potentially your object.. (Heaps of problems trying to automate it into mysql or something more sensible, lots of rows and complications) Got any more info on your object? Probably just willing to try it out, as the web query one is also interesting.

Page 2 of 2 FirstFirst 1 2

Similar Threads

  1. SQlite3
    By byo in forum Released Extensions
    Replies: 16
    Last Post: 28th December 2013, 04:25 AM
  2. listview and sqlite3
    By Blackwolfdave in forum Multimedia Fusion 2 - Technical Support
    Replies: 0
    Last Post: 4th June 2012, 02:33 AM
  3. SQLite3 version 2.0
    By byo in forum Released Extensions
    Replies: 0
    Last Post: 12th October 2009, 11:41 PM
  4. SQLite3 example for dingdong
    By byo in forum File Archive
    Replies: 3
    Last Post: 28th June 2008, 07:41 PM
  5. SQLite3
    By Sphax in forum Multimedia Fusion 2 - Technical Support
    Replies: 5
    Last Post: 15th March 2008, 01:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •