1 Reply Latest reply on Mar 28, 2011 4:29 PM by Trigon_15

    How to create multiple tables in Adobe air?

    Trigon_15 Level 1

      Hi, I am using Flash CS5 coding for adobe air 2.0.

       

      How do you create a database with multiple tables and link them together?

       

      I know how to do it in SQL just can't seem to get it to work in Flash CS5 Adobe air.

       

      The following is ONLY an example of a database layout that shows linking tables together.

       

      Table CUSTOMER

      ---------------------------

      customerID - PK

      customerName

      ---------------------------

       

      Table ITEMS

      ---------------------------

      itemID- PK

      itemName

      ---------------------------

       

      Table ORDERS

      ---------------------------

      orderID- PK

      ---------------------------

       

      data

      ------------------------

      customerID = 1

      customerName = bob

      itemID = 1

      itemName = cup

      orderID = 1

      ------------------------

       

       

      output example

      -----------------------

      1,bob,1,cup,1

      -----------------------

       

      Thankyou