Returns a list of library names, one per line, which have API entries in the dictionary.
function ideDocsFetchLibraryNames # Ensure we have a connection try ideDocsInitialize catch tError return tError end try local tRecordSet, tData, tDataSet, tSQL put "SELECT library_name FROM libraries" into tSQL put revQueryDatabase(sConnection, tSQL) into tRecordSet if the result is not a number then return "error fetching library names" & return & the result end if # Get the docs data from the record set local tCount, tMoreRecords put true into tMoreRecords repeat while tMoreRecords add 1 to tCount get revDatabaseColumnNamed(tRecordSet, "library_name", "tData") put tData into tDataSet[tCount] revMoveToNextRecord tRecordSet put the result into tMoreRecords end repeat # Close the record set revCloseCursor tRecordSet combine tDataSet with return return tDataSet end ideDocsFetchLibraryNames