News Feed Comments

LiveCode for Developers

Creating release quality applications with LiveCode

  • Home
  • Tutorials & Manuals
  • Articles
  • LiveCode Tools
    • Professional Application Development With Revolution (Now LiveCode)
      • About the Course
      • Watch Session I: Organizing For Success
      • Purchase the Course
    • Libraries
      • SQL Yoga
      • GLX Application Framework
      • libDatabase
    • Externals
      • EQT
    • Plugins
      • Script Format Helper
      • Improve LiveCode Handler Finder
      • BBEdit Language Module
  • About
Tutorials & Manuals » SQL Yoga » Creating a Table Object

Subscribe to our feed

Topics

  • Introduction 1
    • About SQL Yoga and This Manual
  • SQL Yoga Primer 3
    • The Primer Stack
    • Connect to a Database By Creating Database and Connection Objects
    • Getting Data From the Database and Displaying It in the UI
  • Notes on Error Reporting 3
    • How SQL Yoga Reports Errors
    • Errors Thrown From Password Protected Stacks
    • Revolution Message Box
  • General Concepts 4
    • How To Use the sql_yoga.rev Stack File In the IDE
    • Unlocking The SQL Yoga Library
    • Building a Standalone Application With SQL Yoga
    • How SQL Yoga Represents Objects
  • Database Objects 5
    • Introduction to the Database Object and Database Schema
    • Creating A Database Object
    • Saving A Database Object Across Sessions
    • Loading The Database Object When Your Stack Opens
    • How To Work With Multiple Database Objects
  • Database Connections 5
    • Introduction to Connection Objects
    • Connecting to a Database Using a Connection Object
    • Telling SQL Yoga When Your Database Schema Changes
    • How To Work With Multiple Connection Objects
    • My Database Schema Has Columns/Tables That Are Reserved Words? What Can I Do?
  • SQL Query Objects 6
    • Introduction to SQL Query Objects
    • Creating A SQL Query Object
    • How Do I Create Records In a Database Table Using a SQL Query Object?
    • How Do I Delete Records From the Database Table Using a SQL Query Object?
    • How To Use Cursors With a SQL Query Object
    • How Can I Convert a User Search String Into An AND/OR Search When Generating a Query?
  • Record Objects 5
    • Introduction to SQL Record Objects
    • Create Records in the Database Using SQL Record Objects
    • Retrieve Records from the Database Using SQL Record Objects
    • Update Records in the Database Using SQL Record Objects
    • Delete Records from the Database Using SQL Record Objects
  • Table Objects 4
    • Introduction to Table Objects
    • Familiarizing Yourself With The "table objects behavior" Property
    • Creating a Table Object
    • How Do I Add Custom Properties To Tables?
  • Table Relationships 3
    • Introduction to Relationship Objects
    • Creating a Relationship Object
    • How Can I Use Relationship Objects When Generating Queries?

SQL Yoga: A Flexible Database Library for Revolution.

SQL Yoga page

Buy now

Last Updated

Dec 31, 2010

Download Manual PDF

Other Resources

  • How-tos

  • Lessons
  • Signing Your Applications and Building Installers
  • GLX Application Framework

  • GLX Application Framework 1.1
  • Converting An Existing Application To Use The Framework
  • SQL Yoga

  • SQL Yoga
  • SQL Yoga Examples
  • SQL Yoga To-Do Application
  • SQL Yoga IDE Plugin
  • Plugins, Externals and Libraries

  • Plugins

Comments

0 for this lesson

  • Prev: Familiarizing Yourself With The "table objects behavior" Property
  • Next: How Do I Add Custom Properties To Tables?

Creating a Table Object

Table Objects are created in the dbobject.createTables handler of the button object script that is assigned to the table objects behavior property of the Database object. If you are not familiar with the table objects behavior property please see this lesson.

Create A Table Object

Here is an example how to create a table object for some tables named "projects", "todo_items" and "people".

on dbobject.createTables
    ## Create Table Objects
    tableobj_createObject "projects"
    tableobj_createObject "todo_items"
    tableobj_createObject "people"
end dbobject.createTables

  • Prev: Familiarizing Yourself With The "table objects behavior" Property
  • Next: How Do I Add Custom Properties To Tables?

Comments (0)

Add your comment

E-Mail me when someone replies to this comment
  • This site is brought to you by the creators of ScreenSteps

  • ScreenSteps

    Screen capture, image editing and document authoring in a single application.

  • Simple, Affordable Software Documentation

    • Capture or import images
    • Add lines, arrows, boxes and other image annotations
    • Author your text and publish to blog/wikis, Word, PDF, HTML and more…

  • Learn more about ScreenSteps

    Visit the ScreenSteps website to learn more.

© 2009-2013 LiveCode for Developers