or this could be TemplateID = a specific template number, to just change one template WHERE (SourceTable.SourceID = CitationTable.SourceID) WHERE SourceTable.SourceID = CitationTable.SourceID ) SET (Fields) = (SELECT cast(Replace(cast(CitationTable.Fields as Text),'','CitItemD' || SourceTable.Name || '') as blob) add extra field for name - at the start so it is used for citation name when converting to v8 or this could be TemplateID = a specific template number to just change one template SET (FieldDefs) = cast(Replace(cast(FieldDefs as Text),'','CitItemDItem NameTextItem NameTo distinguish citationsTrue') as blob) This will only work for user templates, not for supplied ones (SourceTable.TemplateID > 10000)Īdd in new field - CitItemD for citation name and put in source name - creates good citation name in RM8 I have taken advantage of this concatenation to get meaningful names by inserting a new field in my own templates as the first one in a citation and then setting the value in the citations to the source name. So I run this script on my RM version 7 database so that it is ready for importing into RM version 8. In RM8, citations are re-useable and have a name which is made by concatenating the contents of the citation fields.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |