Ed Bell Change 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
