All
Accepted answers
Chris Stewart · Feb 18, 2021 go to post

That would be an easy adjustment to make.  In my use case I'm also interested in knowing which fields are mismatching, and there may be multiple mismatches (hopefully not) per export 

Chris Stewart · Sep 24, 2018 go to post

HI Denny

Trakcare publishes it's CSPs as Deployed, so a standard install will not contain a user friendly way to view them


HTH

Chris

Chris Stewart · Apr 23, 2018 go to post

If I'm writing something that will  maybe run 2 or 3 times, and is less than 10 lines of code, I might use a .mac.  For anything more than that, I would use a class, as the time saved in setup is pretty negligible compared to the rest of the work done

Chris Stewart · Mar 2, 2018 go to post

Hi Jay


This has happened a few times, and I've readded them a few times.  I'll see if I still have the images handy and get them reattached again

Chris Stewart · Feb 15, 2018 go to post

Could you try making the call with a REST client like RESTLet for Chrome, and seeing if the request comes through on that method?

Chris Stewart · Feb 15, 2018 go to post

Try reading the Request data with this

Set updateJSON = %request.Content.Read()

Edited because I missed that you already tried this?

Chris Stewart · Feb 7, 2018 go to post

HI Fabio


I've built it into my Authentication routine on my REST services, as all of my functionality goes through REST.  I created a simple Audit class, and had each call to the Authentication include information specific to which service called it.

HTH

Chris

Chris Stewart · Jan 19, 2018 go to post

Hi Wendy,

I would need to see some details of what your class is doing to comment further.  

Chris Stewart · Jan 19, 2018 go to post

HI Gary

There's an example of this in the SAMPLES database if you have that installed.  Take a look for upload.csp in /csp/samples

HTH

CHris

Chris Stewart · Jan 15, 2018 go to post

Reposting as an answer to get this removed from the "Unanswered questions" list

HI Rui

Unicode 0x3 is the ETX character, which can be used as newline in certain text editors.  Any control chars are disallowed in XML processing, so these should be stripped from whatever query you are using to drive this report

HTH

Chris

Chris Stewart · Nov 20, 2017 go to post

Are there locks against this global?  You can check this with View Locks in the Management Portal

Also, are you sure that the Backup was taken using an appropriate backup tool?   Generally a backup will be taken from a consistent state, and would not include locking

Chris Stewart · Oct 27, 2017 go to post

So I think you're encoding it as an Authorization Header?  

In that case, you can extract this from

set Auth = %request.GetCgiEnv("HTTP_AUTHORIZATION")

then process this however you need to (for example if you have something like "Basic 123908109abc", this will unpack it and decode the Base64)

 set AuthType = $P(Auth," ",1)
  set AuthString = $P(Auth," ",2)
    set DecodeAuthString = $SYSTEM.Encryption.Base64Decode(AuthString)
    set userid = $p(DecodeAuthString,":",1)
    set token  = $p(DecodeAuthString,":",2)

Chris Stewart · Oct 27, 2017 go to post

HI Soufiane

I'd need more info about the format of the data and how you are sending it to comment any further

Chris Stewart · Sep 6, 2017 go to post

If you're iterating that would typically be done with a CURSOR.  Each fetch cycle would pop the new state of the variables in, in line with each row (make sure you check for SQLCODE while doing this, to determine if there is a row to fetch).

More documentation on this is at

http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…

EDIT:

Mixed my dynamic SQL methods there.  You would use rset.%Next to do this iteration in %SQL.Statement, but the general theory still holds

http://localhost:57773/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_dynsql#…

Chris Stewart · Sep 5, 2017 go to post

Hi Paul

You will need to execute it after Preparing it

  SET rset = tStatement.%Execute()
Chris Stewart · Aug 21, 2017 go to post

HI Rui

Unicode 0x3 is the ETX character, which can be used as newline in certain text editors.  Any control chars are disallowed in XML processing, so these should be stripped from whatever query you are using to drive this report

HTH

Chris

Chris Stewart · Aug 8, 2017 go to post

HI Minu


GBLOCKCOPY is used to create a smaller database, after some data is removed and leaves sparse space in the database.  If your database is full, then copying it will not save space.  Before anything else, you should check the size of your globals and remove any data that you do not need.  GBLOCKCOPY should then reclaim some space for you

Chris Stewart · Aug 7, 2017 go to post

Hi Kishan

A method is attached to a specific instance of an Object class.  A Classmethod can be called without having to instantiate the object.

So, we could have a Method on a Person object to update address

do person.UpdateAddress("New address")

Whereas, for a ClassMethod, we could define a Classmethod to give us as object instance to then work on

set person = ##class(User.Person).CreatePerson("FirstName","LastName",Age)

 

Hope that helps?

Chris Stewart · Aug 3, 2017 go to post

Hi Confused

If you're a Trak customer, your best option is to raise a TRC to have the appropriate Support team assist.  However, IE11 isn't a fully supported platform for Layout Editor, though it will work.  You will need the Microsoft DHTML Editing Component at a minimum, this can be obtained from

https://www.microsoft.com/en-gb/download/details.aspx?id=8956

Hope this helps

Chris

Chris Stewart · Aug 3, 2017 go to post

Jeffrey, there's usually free parking on Cambridge Parkway, which is a short walk from the ISC Office