18052 results


  • Answer:

    Referring to Projecting Caché Objects to XML Done by using class parameter: Parameter XMLIGNORENULL = 1; ...

    Answer to the post "How to project a null property to an empty XML element?" by Lin Zhu, 1 hour 23 min ago


  • Question: How to project a null property to an empty XML element?

    Caché Objects, XML Hi folks, One of my clients want to project a null property of a cache object to an empty XML element. Say, if we have a class: Class Diabetes.BS.Message.LabReportMessage Extends Ens.Request {Property Report As %String; Property IsRisky ...

    Post by Lin Zhu 1 hour 39 min ago


  • Answer:

    You can also create your own conversion function like this: Class  SQL.ext  [Abstract ] {ClassMethod  fromUTC(ts  As  %TimeStamp) As  %TimeStamp  [SqlName  = fromUTC, SqlProc ] {  quit  $ZDT ($ZDTH ($ZDTH (ts,3),-3),3,1,2)}} Then you simply use  SELECT ...

    Answer to the post "Convert UTC to local time via SQL" by Robert Cemper, 7 hours 56 min ago


  • Announcement: New Video: Treating Patients with REST and iKnow

    iKnow, REST Services, Video Hi Community! New video " Treating Patients with REST and iKnow " is available now on   DC YouTube Channel:   Task:   Leverage unstructured data through iKnow’s REST APIs and other productivity-enhancing capabilities. ...

    Post by Brian Fives 8 hours 34 min ago


  • Comment:

    You can always follow the instructions on the Atelier download page, intersystems.com/atelier. If you've already got Java 8+ and Eclipse installed, you can skip over to step 2. We're still working on...

    Comment to the post "Atelier 1.2 Stable Release" by Nicole Aaron, 6 days ago


  • Answer:

    Well, there is mostly only one reason, why you can't mount your database and this issue mostly happens when anybody tries to migrate between different versions on different machines. And it is different localization settings. Like, your database uses ...

    Answer to the post "CACHE.DAT upgrade from Cache 2015 to Cache 2017" by Dmitry Maslennikov, 11 hours 18 min ago


  • Answer:

    Function $zf (-1) just executes a command passed as the second argument, you passed only file name. it is not complete, you should add command del  for Windows. set status = $zf(-1, "del c:\sys\text.txt") it should return 0 if the command was ...

    Answer to the post "COMANDO $ZF" by Dmitry Maslennikov, 11 hours 45 min ago


  • Answer:

    This format does not contain information about timezone, so, you don't have any direct way how to convert it to the local time. You can use DATEADD function, to correct time, but you should use constant correction, or in another field. SELECT DATEADD ...

    Answer to the post "Convert UTC to local time via SQL" by Dmitry Maslennikov, 11 hours 49 min ago


  • Question: Convert UTC to local time via SQL

    Caché Hello, I’m running  a query to drive a report.   I have a persistent class that includes this: Property  CreationTime As %TimeStamp  [InitialExpression  = {$ZDateTime ($ZTimeStamp, 3, 1, 2)}];   So the above populates the column with UTC time.   Is ...

    Post by Nicholas Chimera 12 hours 39 min ago


  • Question: COMANDO $ZF

    Caché Hello everyone I have a problem with $ ZF (-1) I need to delete file from windows folder example c: \ sys \ text.txt, when executing the w $ zf (-1, "c: \ sys \ text.txt") command, the file does not delete. There is some other cache ...

    Post by Davidson Espindola 13 hours 13 min ago