02-08-2014, 05:31 AM
Hello Adam,
In the current version of MobileSheets, the table you are looking for is called "Images" (I'm renaming this to "Files" in version 5). For each entry, it has a "SongId" field which has to correspond to the song that owns it, and a path to the file in the "Image" field. So to do what you are asking, for each song you would need to retrieve its id (the primary key field), and then do a query of the images table to see which files it uses, and for each result in the query, look at the Image field to see what the path to the file is.
As I mentioned previously, the column names and structure of the table are changing in version 5 (more fields are being added as well to track additional information), so the database will have better names for tables/columns very soon.
I hope that helps,
Mike
In the current version of MobileSheets, the table you are looking for is called "Images" (I'm renaming this to "Files" in version 5). For each entry, it has a "SongId" field which has to correspond to the song that owns it, and a path to the file in the "Image" field. So to do what you are asking, for each song you would need to retrieve its id (the primary key field), and then do a query of the images table to see which files it uses, and for each result in the query, look at the Image field to see what the path to the file is.
As I mentioned previously, the column names and structure of the table are changing in version 5 (more fields are being added as well to track additional information), so the database will have better names for tables/columns very soon.
I hope that helps,
Mike