Syndicate content 0  
 
All time
Question
· Apr 3, 2017
Weekend

how to exclude weekend(Friday) in sql statement i trade use select datediff(WK,date1,date2) but not working even i chose (Dialect mssQL)

Thank You

0 1
0 391
Article
· Jun 24, 2016 1m read
2016.2 Field Test Kit 2016.2.0.677.0

I am pleased to announce the next 2016.2 field test kit, 2016.2.0.677.0.

I haven’t sent an update to this thread in a while and it should come as no surprise that there has been quite a lot of development going on since I wrote about build 632. In fact, there have been almost 300 changes covering most areas of the product.

The accumulated list of fixes to problems found in the field since build 632 includes the following changes:

0 0
0 392

Every thriving community relies on members whose quiet dedication and deep expertise keep it growing stronger year after year. In the InterSystems Developer Community, one such pillar is @Megumi Kakechi, a long-time engineer and support specialist whose 17 years with InterSystems and 9 years on the Developer Community reflect a true passion for helping others learn, solve problems, and innovate.

👏 Let’s take a closer look at Megumi's remarkable journey and her impact on the InterSystems ecosystem.

21 10
0 191

Hey Developers,

See how you can get high-performance relational access using SQL to manage data within your InterSystems products:

⏯ Using SQL with InterSystems IRIS

https://www.youtube.com/embed/7l-YT5y-nJo
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 2
0 351
Question
· Mar 24, 2022
Insert Row by enforcing ID

Hi Guys,

Can I insert a new row and enforcing my own ID not the default id increment?

&sql(INSERT INTO Sample.Person
(ID,Name,SSN)
VALUES ('205','Swift,Jonathan','111-22-3333'))

IF (SQLCODE = 0) {
Write "New Person inserted with ID: ", %ROWID,!
}
else
{WRITE !,"SQLCODE=",SQLCODE," ",%msg }

0 1
0 390

Hi,

Im wondering if its possible to pass a SQL query through to the Power BI IRIS Connector? I can't currently see an option - and have tried through advance editor to use M Query syntax to attempt this with no luck.

Has anyone else in the community had any luck or know if this is supported?

Thanks.

0 2
0 389
Question
· Jun 17, 2020
Atelier in a zip

Hi,

I'm trying to install Atelier in my Eclipse installation, but due to network restrictions I am unable to reach the server. Is there any way to download the zip file to install it locally?

0 5
0 386
Question
· Mar 17, 2020
Building $lb from C

I have a C string and I need to build a $lb from it.

This code works fine for strings shorter than 254 characters:

char *str = "some string";
int len = strlen(str);
int add = 2;
char *list = malloc(len + add + 1);
char lenChar = len + add;
sprintf(list, "%c\x01%s", lenChar, str);

Thought maybe someone can share the code for longer strings?

0 1
1 390

I have one REST service extending %CSP.REST

I am trying to call one method using JOB, its not getting called does anyone have any idea if i am doing anything wrong here.

works : do ##class(TestFramework.API.E2E.Service).RunCases()

does not work : JOB ##class(TestFramework.API.E2E.Service).RunCases()

0 6
0 385
Question
· Mar 9, 2019
%SYS.TasK Related query

Hi Community,

I have to make a daily task (Job) which will run (7 am to 7 pm) in a day at an interval of 3 hours. Timings are as (7:00 am, 10:00 am,13:00 pm,16:00 pm,19:00 pm). But at each time when task will run i have to set a variables as per below condition

Sample:

1) If task run at 2019-03-19 07:00 am in morning

I have to set two variables (start and end) whose value will become like this

(set starttime= 2019-03-09 07:00:00.00 and set endtime=2019-03-09 10:00:00.00)

0 3
0 388
Question
· Mar 5, 2019
.INT file not generated

After compilation of routine .int file is not generated and toggle breakpoint is also not visible for that routine.
It is showing error #5001 Editing of INT file is not allowed. How can I resolve this ?

0 2
0 389

I downloaded and installed the trial version of Caché.
it is installed in c:\intersystems\Trycache
I changed the system environment settings so that
GLOBALS_PATH = c:\intersystems\Trycache
and PATH includes c:\intersystems\Trycache\bin
Caché works, and I can login, use the globals, etc...

0 1
0 390

HealShare 2017

Hi dev community,

I am currently working on an interface that needs to communicate to a SOAP/ITK endpoint.

I am using the EnsLib.ITK.AdapterKit.Operation.SOAPOperation to interface with an ITK
service, but it is proving to be more complex than originally expected to set up the web client
against that particular end-point since I haven't been provided with a WSDL from ITK service side as
the vendor state they are following the ITK standard and no WSDLs are needed.

0 1
0 390

We upgraded from 2017.1 to 2017.2 today and noticed that when shutting down we must do it as an administrator. Attempting to shut down as a non-admin result in a failure to shut down message. We are curious if there was an issue with our upgrade or if there is a change that requires an administrator to shut down Cache in 2017.2.

edit:

Operating System is Windows Server 2012 R2. We run Cache in a cluster using Windows Failover Cluster where we swing the drive from one machine to another when failing.

0 5
0 386

Hi Community!

Please find the Developer Community video of the week on the InterSystems Developers YouTube Channel:

Upgrades - Minimizing Business Disruption

https://www.youtube.com/embed/CrY-vPVcJdM
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

3 2
1 351

I would like to know how to get the key value from a dropdownmenuitem placed on a navbar.

I have tried to get from onselect and onchange events of the template class, but it didn´t work.

According to the snapshot attached I am trying to retrieve the values from 'action-1' and 'action-2'.

I have attached a ZIP file with a snapshot which value I am trying to retrieve and example classes.

Thanks.

1 8
0 383