Ed BellChange your cover photoUpload Change your cover photoUpload Ed Bell This user account status is Approved About About Posts Posts Comments Comments Perfect! So an Event that is linked to a PlaceDetail (i.e., PlaceType == 2), will have PlaceTable.PlaceID set to the… On RM9 Data Definitions #datadefinitions In the EventTable, what are the roles of PlaceID and SiteID? I assume the former relates to the PlaceTable PlaceID,… On RM9 Database Diagram #rm9 #database I assume the PlaceID value in the EventTable refer to the PlaceID value in the PlaceTable? What is the SiteID… On RM9 Data Definitions #datadefinitions Can this be modified to search for all Places with "Cemetery" and split those? On Places to Place Details Conversion #places #placedetails #update Okay, using "SQLite Expert" I was finally able to get this query to run! Thanks! Can I request another query?… On Places – Delete Unused #places #placedetails #delete #phantom When I run this in SQLLite3, I get the error "Parse error near line XX: no such collation sequence: RMNOCASE"… On Places – Delete Unused #places #placedetails #delete #phantom
