0 Replies Latest reply on May 12, 2011 12:18 PM by Kristin95762

    can I extract sqlite column data to a variable?

    Kristin95762 Level 1

      I THINK I would like to retrieve some table data to a variable instead of a dataProvider like a list or grid. Can that be done?

       

      Currently I have an authors table and a book table. I have an authorID field and a bookID field in the book table, and naturally just an authorID in the authors table. So I have a one to many relationship (one author has multiple books).

       

      When I enter a book into the book table, I want an associated authorID from the authors table to go along. What is the best method for retrieving the authorID so that I can enter the associated authorID, bookID, bookTitle into the book table?

       

      I was thinking that I could extract the authorID to a variable and then include that in my INSERT statement.

       

      Kristin