Retrieve the entire table data into an two dimensional director list.
Usage:
dbTableData (object me, string tableName)
Parameter:
tableName - (string) the name of the table in the data file. Use dbTableNames() to obtain the list of tables available in your data file.
Returns:
(2 Dimensional list), with the inner list storing column data for each row, and the outer list storing the lists for each row
Example:
xtRose = xtra("Rosetta").new( )
xtRose.dbOpen( "Provider=MSDASQL;ExtendedAnsiSQL=2;DRIVER={Microsoft Access Driver (*.mdb)};Dbq="&the moviepath&"main" )
myData = xtRose.dbTableData( "MSysAccessObjects" )
Notes:
Use this method to quickly obtain the entire table data back into Macromedia Director. This function is only limited by the available memory available on the target machine. If you believe the data set is larger than needed, consider using dbDataBySQL( )