Hi, folks!

I'm sending emails with %Net.MailMessage.

How can I add a new line for the email body?

The code is:

dim msg as %Net.MailMessage = ##class(%Net.MailMessage).%New()
set msg.Charset="UTF-8"
do msg.TextData.Write("Dear  "_Username)
do msg.TextData.Write("Line1")
do msg.TextData.Write("Line2")
And I'm getting in email:
Dear UserLine1Line2

How can I get:

Dear User

Line1

Line2
0 8
1 1.8K
Question
· Aug 25, 2017
Runtime type detection

SOLVED

tl;dr how can you tell if a number is really a string

The original question has been updated/improved.

Equality comparisons on floating point numbers will produce different results...

"1.1"=1.1 //is true!

"0.1"=0.1 //is not true :(

This second comparison can be fixed with...

+"0.1"=+0.1 // is true!

0 31
0 1.2K
Question
· Aug 25, 2017
Zen Report - ErrorNo: 5540

I'm working on an existing Zen Report that uses queryClass/queryName to retrieve data using a class that has a Stored Procedure method. Which works fine.
I have created second class with a Stored Procedure method, I modified the zen report to use this class and now I'm having the following error.

Error: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation
ErrorNo: 5540

Regards,

Rui

1 4
0 470

Is there a way to omit or skip rollback of some data changes during a transaction rollback? Maybe some sort of "autonomous transaction"?

The issue is with error logging in transaction. For example we may have in nested calls the following structure:
TS
<some code>
<error happens>
TRO 1
<error log to database>
but if this code is in another transaction, and that rolls back we lose error data.

0 7
0 968
Question
· Aug 24, 2017
Error on SQL update service

I have a simple SQL service that does a simple select from an SQL database. After the select, I do an update to set the ProcessedFlag to "Y" for yes, so my next pass doesn't select records already processed. The service works fine, except when it's done I get the error below, anybody know what is causing this error?

0 3
0 381

There seems to be a problem with the sync/save. If I open a CSP file, add a CRLF to end of it and save the file I get a sync conflict. This can't be right.

To make matters worse I can then select to the local version and will then end up in an infinite loop where the CSP import/compiler keeps adding more and more CRLFs to the file.

You can see an example here: https://youtu.be/EY-_FA-kOpI

0 4
0 401

When I add a parameter to dataCombo for loading it on runtime and the property editable set to 0, dynamically loading content for dropdown through parameter works fine.

But, when I set editable to 1, to implement user search in dataCombo, loading through parameter is not working, it is loaded all rows, but I need loading on some parameter. It don't see the parameter, when editable is 1.

Is it normal behavior of dataCombo? But how about user search in dataCombo on this case? When editable is 0, we can't enter any character in dataCombo.

0 2
0 356
Question
· Aug 22, 2017
%SYS.GSET

Hi

Does anybody know what happend to %SYS.GSET routine in Cache 2016 ?

In Cache 2013 it still existed, I didn't find anything about it in Cache realese notes 2014 and 2015.

Uri

0 10
0 438

The dataCombo property columnHeaders is a comma-delimited list of column headers displayed in the dropdown list.

Comma is a delimiter.

But, if I want add comma to columh header, for instance "House number, apartment" - this is value for header of one column.

How can I escape comma in this case?

"House number\, apartment" - is not working.

0 26
0 574
Question
· Aug 21, 2017
Zen Reports error

Hi,

I'm having the following error visualizing a PDF report.

An invalid XML character (Unicode: 0x3) was found in the value of attribute "Reaction" and element is "Allergies".

Aug 18, 2017 10:50:29 AM org.apache.fop.apps.FopFactoryConfigurator configure

INFO: Default page-height set to: 11in

Aug 18, 2017 10:50:29 AM org.apache.fop.apps.FopFactoryConfigurator configure

INFO: Default page-width set to: 8.26in

Aug 18, 2017 10:50:30 AM org.apache.fop.cli.Main startFOP

SEVERE: Exception

0 3
0 446

Hello everybody,

We have a piece of Caché software which calls an external utility using $zf(-1,command). It works fine under Linux, but under Windows an external process occasionally hangs (due to some internal problems out of the scope here) and need to be killed programmatically. Having PID, it's easy to kill a process. If a Caché process is called with JOB command, the caller can easily get its PID from $zchild, but alas $zf(-1) does not seem to return the similar info. Is it possible to get it somehow?

0 4
0 694

I was wondering if there was a way to if the user is using Studio and changes a file to get the users name and have a function run when the file is changed.

Ive got this working for .int files but not for .csp or .js or .css or any other kinds of files.

When we edit code we are logged in to the Cache backend’s server through Studio by using an iPaddress (which is on our network).

I know now there are concepts of file locks and logs for when certain tasks are ran or when a user maybe edits a file

0 5
0 415
Question
· Aug 18, 2017
%Dictionary.StorageSQLMapDefinition

I want to manipulate all the objects whose type is%Dictionary.StorageSQLMapDefinition by %OpenId

However, I don't know the exact id to feed into %OpenId, is there a way to query all the existing ids of %Dictionary.StorageSQLMapDefinition in a namespace?

Thanks.

0 3
0 411

Hello everybody.

What I have is a criteria how to select "my" strings. What I need is to replace all of them with macro calls (using the same strings as arguments) in all classes of current namespace.

I was ready to write straightforward code, but at the last moment decided to ask the community: maybe I've overlooked a smarter option?

Any comments and advices would be great appreciated.

1 6
0 556

Is it possible to dynamically adjust the RetryInterval andFailureTimeout settings in a BPL?

I've got a business process that calls a web service operation to get a session ID from an external system. There is a string property returned in the body of the response that indicate an exception occurred in the external system. I have code in the BPL that examines the property and sets the status property to an error status when that occurs.

0 3
0 784
Question
· Aug 16, 2017
PROTECT error

I try to run below two statements

Set tRS = ##class(%ResultSet).%New("%Dictionary.ClassDefinition:SubclassOf")
​set tSC = tRS.Execute("%Persistent")

and I always get <PROTECT>check+5^%Dictionary.ClassDefinitionQuery.1

The login user is _SYSTEM and should have all the permissions.

I cannot run queries in the $SYSTEM.SQL.Shell(). I would get <PROTECT>%GenerateMetadata+16^%SQL.StatementMetadata.1

However, when I run the query through SMP, everything is fine.

Any idea where could I start to investigate ?

Thanks.

1 5
0 3K