User Tag List

Results 1 to 3 of 3

Thread: SQLite3 example - for Corentin

  1. #1
    Clicker Fusion 2.5 Developer

    Join Date
    May 2007
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    SQLite3 example - for Corentin

    Hi.

    Here's your example with a few adaptations. Unfortunately I'm using SQLite3 inner API language for most of the time so if it can't be done it's because SQLite doesn't support it originally.

    One way to do what you want is using the AS keyword when selecting columns (it's used in cases like this in most DBMSs).
    This way even if the column names between two tables are identical you force SQLite to name it the way you want it thus it will show that alias when using the Get Column Name expression.

    See if that works out for you.
    Attached files Attached files

  2. #2
    No Products Registered

    Join Date
    Jun 2006
    Posts
    625
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQLite3 example - for Corentin

    Thanks for making this, it's very kind of you !

    I knew about AS statements (and I use them a lot actually), but I can't use them in this particular case, I think... Or maybe I could, I'll have to check again... Maybe I didn't think of this solution.

    I'll try it, but I guess I had a good reason not to use AS.

    Anyway thank you once again for the time you spent on this extension and my questions.

  3. #3
    Clicker Fusion 2.5 Developer

    Join Date
    May 2007
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: SQLite3 example - for Corentin

    Anytime.

    Now I think there's the only way to have identical column names from different tables. I may be wrong though.

    A new version is on the works and will be a total rewrite because I'm not satisfied with some parts of my messy code.

    Regards,

    Andre Guerreiro (byo)

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
  •