venus light wrote: > This looks like an awesome tool. What would be a good resource to > discover how to write different SQL queries on this database? > > I'm not super versed on SQL, but am pretty computer-savvy, so I think I > could figure it out if someone pointed me in the right direction. > > The pre-sets are great, but I'd like to do a little customization and > don't want to bother folks in this thread to create new code just for > me. > TIA Earlier in this thread get.amped posted some helpful snapshots of the primary tables of interest in the LMS database. Those should give you the table & field names for just about everything you're likely to be interested in. There is plenty of documentation for SQLite available online, to give you some guidance for putting queries together. With the presets and other code examples from this thread, that should be a good start.
------------------------------------------------------------------------ Dogberry2's Profile: http://forums.slimdevices.com/member.php?userid=18883 View this thread: http://forums.slimdevices.com/showthread.php?t=101600 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
