Congratulations @Alberto Fuentes , you are the best.
- Log in to post comments
Congratulations @Alberto Fuentes , you are the best.
Hi,
You can find all ODBC drivers is this link
https://intersystems-community.github.io/iris-driver-distribution/
Thank you Luis Angel,
I've followed the steps of the documentation and now it works.
Fortunally, the code of that namespace it was a dummy code just to create a documentation about how to rename a namespace.
Thanks Julian.
If there is any error in the query, always throw a generic error code (ERROR #6022: Gateway: Execute fail), but I don't know if it is due a a duplicate value (code 2061) or is due other sql error code.
Using this code, err.Code always is 6022
Note: I've done the following code to catch the native error... but it is a bit "smell code"
// run the query
Set tSC = ..Adapter.ExecuteUpdateParmArray(.nrows,SQL,.param)
// Check if there is any error
If $$$ISERR(tSC)
{
Set msgError = $System.Status.GetErrorText(tSC)
// Check here if the native error code is 2601 (Cannot insert duplicate key row into object 'MYPATIENTS' with unique index 'UQ_UNIQUE_INDEX')
if $FIND(msgError, "[2601]") > 0
{
// This is a insert/update that violates the unique code
// remove duplicate record
quit $$$OK
}
else
{
// Generic error... thow excepction
quit tSC
}
}Congratulations to all winners. iterm is super useful. Great job by @Dmitry Maslennikov
Thanks Thomas,
Indeed, I have tried to use IntegratedML as a neural network, if I really need my model to learn to find what the pattern of converting degrees Celsius to Fahrenheit is, it is to "feed" the data with more data.
Thanks so much for the explanation.
I don't believe that training is working as poorly as I'm experiencing. Does anyone have any answers to this problem?
Thanks, using this code I've converted it to a Strem.GlobalChar and read the content correctly
But I need a string, not another GlobalBinary
Congratulations to the winners. Thanks for all, we must to repeat 😉
I'm afraid you need a Office 365 subscription, because it is a functionality for full version. Sorry.
The webhook is associated with an account and is managed by the Microsoft server, a personal account does not have a service that is "listening" for external requests.
Updated OEX. Version 1.1.0 with URL for images in your cards.
He is more than a hero... he is our inspiration. I have no words to express my admiration for @Robert.Cemper1003.
Congratulation, I hope we can meet together soon
ding, ding, ding... we have a winner!!!
Yep... the event OnEndRequest is the correct answer... I can get the end of the process.
Thanks for your help
Thanks for your help.
But I am trying to use a common class, all the BS are inherited from this BS.ApiBase.cls, this way I don't need to modify the rest of the productions and we can implement this feature for all of them.
Anyway, you have solved me how to get the SessionId, using the OnProcessInput
Thanks for your replay.
Indeed, there is a package using pyhton, but not all of us can have access to use Python on client servers. The idea of using only objectscript arose from the need to not be able to implement Python on those servers.
Thanks for all
If you want to know how it works... check the following video
Coming soon, I was doing the video for the last article.. Enjoy it
And it won't be the last, I threaten with more articles, hehehe

Thanks @Robert Cemper, your words are an inspiration to me
Hi,
Try this
do ##class(myDt).Transform(dataEntry, .dataTransform)
Then you call to your BO and your content tranformed
Hi,
It seems that is a problem with your VS Code.
Could you check that you have updated the Intersystems ObjectScript extensions?
https://marketplace.visualstudio.com/items?itemName=intersystems-commun…
When you save and compile your code, in the case of a persistent class, it adds the SQLMap, but it is retrieve in this moment.
Check your configuration, I have setted the following one:
✔ Auto Adjust Name
✔ Compile Flags: cuk
✔ Compile On Save
And this configuration of export in .code-workspace
"objectscript.export": {
"folder": "src",
"addCategory": false,
"map": {},
"atelier": true,
"generated": false,
"filter": "",
"exactFilter": "",
"category": "*",
"noStorage": false,
"dontExportIfNoChanges": false,
"maxConcurrentConnections": 0,
"mapped": true
}Let me know if it works
Best Regads
I LOVE IT!!!

Thanks for your answers. Good idea using a global as key to unlock the loop.
Thanks for the article. We need to create a complex process to update information in a production and it will be a good idea for the developers.
It's not a bad idea, but the last value has very little chance of appearing
FOR I=1:1:100 {W $Piece("SAD,MED,TEN,BOB,RAN",",",$r(4)+1),"-" }
TEN-TEN-BOB-TEN-SAD-MED-MED-MED-MED-MED-TEN-MED-BOB-MED-MED-TEN-TEN-MED-SAD-BOB-MED-SAD-BOB-
TEN-TEN-BOB-BOB-SAD-BOB-TEN-MED-BOB-BOB-MED-TEN-MED-SAD-BOB-BOB-BOB-MED-MED-TEN-MED-TEN-MED-
TEN-BOB-MED-TEN-SAD-MED-MED-MED-BOB-SAD-SAD-MED-SAD-BOB-SAD-TEN-BOB-BOB-TEN-BOB-TEN-BOB-SAD-
SAD-TEN-MED-TEN-SAD-BOB-MED-SAD-SAD-BOB-MED-TEN-TEN-SAD-SAD-SAD-BOB-BOB-BOB-TEN-MED-BOB-BOB-
TEN-BOB-SAD-SAD-BOB-BOB-BOB-MED
SAD 20%
MED 27%
TEN 23%
BOB 30%
RAN 0%I've tried to user other way, for example, using a GUID, get the checksum and get the module 5
Something like $Piece("SAD,MED,TEN,BOB,RAN",",",($ZCRC(##class(%SYSTEM.Util).CreateGUID(),0)#5) + 1)
for i=1:1:100 {W $Piece("SAD,MED,TEN,BOB,RAN",",",($ZCRC(##class(%SYSTEM.Util).CreateGUID(),0)#5) + 1),"-"}
TEN-SAD-BOB-MED-BOB-BOB-MED-MED-BOB-RAN-MED-BOB-RAN-MED-RAN-BOB-BOB-MED-RAN-SAD-RAN-MED-MED-
BOB-TEN-BOB-RAN-MED-TEN-TEN-TEN-SAD-BOB-MED-BOB-BOB-BOB-RAN-RAN-TEN-MED-RAN-RAN-BOB-RAN-TEN-
MED-TEN-TEN-MED-RAN-BOB-TEN-SAD-SAD-TEN-TEN-TEN-BOB-RAN-MED-SAD-MED-SAD-RAN-RAN-RAN-BOB-MED-
SAD-MED-RAN-RAN-SAD-RAN-RAN-BOB-MED-TEN-TEN-RAN-BOB-TEN-TEN-RAN-BOB-BOB-TEN-MED-SAD-SAD-BOB-
BOB-BOB-SAD-TEN-MED-TEN-BOB-SAD
SAD 13%
MED 20%
TEN 20%
BOB 25%
RAN 22%I have best percentage to get a different value.
Sorry, it's a mistake. Indeed, I've forgotten write the [ ], but still the error.
I've fixed the JSon in the post.
Thanks John,
According to that solution, I need to ask to WRC an a ad-hoc fix for my IRIS instance, isn't it?