go to post Robert Cemper · Jul 25, 2017 Sébastien,<COLLATION NOT SUPPORTED>tells you that you have different NLS setting between your servers.e.g. FRAW on one side and something else not supporting French collation on the other end eg. ENUW or simiaror not wide characters ...Should be easy to change on the fly from Mgmt Portalhttp://localhost:57772/csp/sys/mgr/%25CSP.UI.Portal.NLS.zenSalue,
go to post Robert Cemper · Jul 25, 2017 I just got this information: Developer group worked at it and version 2018.1 1 will contain the new pattern.
go to post Robert Cemper · Jul 25, 2017 And if you also want to be sure that also the Method %New exists you my usewrite $$$comMemberDefined(ClassName,"m","%New")[just reading through %occReference.inc]
go to post Robert Cemper · Jul 24, 2017 I'm fully with you.Using hidden %System.whatever Classes is as bad practice as using undocumented $zu(anynumber, , , )
go to post Robert Cemper · Jul 23, 2017 Using the term MACRO for code saved as .INC is quite a challenge to beginners working in .MAC and more in .CLSAlways a nice check for a trainer to verify attention of his victims
go to post Robert Cemper · Jul 23, 2017 set exist=##class(%Dictionary.CompiledClass).%ExistsId(ClassName)will tell you the status
go to post Robert Cemper · Jul 22, 2017 If there is an index defined on PBD_PBO_ParRef is it correctly generated?If not sure, do rebuild index from MgmtPortal.
go to post Robert Cemper · Jul 21, 2017 What about chopping your query like this or similarlastID=0"Select TOP 10000 ID,Text from eprinstance.isegment where ID > ?"passing lastID as query ParameterNow you loop on it until you collected all records.The basic idea is to limit your result set by TOP as your partition allows. it's definitely independent of Cache versions.
go to post Robert Cemper · Jul 21, 2017 I wish I had this half a year ago when I was teaching Caché basics to total fresh developers.Great stuff.Robert
