查找

问题
· 十月 24, 2024

I want to test if two fields are numeric and positive, do subtraction, and test if the result is positive.

If both fields are numeric and the result of subtraction of field1-field2 is positive, only then put the result is a data field.

I am doing this within an Iris DTL.

I don't find any functions like IsNumeric(). Once I get that, I can test if field1>0 and field2>0, do the subtraction, and test if diff>0.

I just need a function to determine if they are numeric, rather than some cumbersome way like a regex where the only characters are 0-9.

I see functions in documentation but don't see them used at tests, only in WRITE statements.

Thanks,

Jonathan

10 Comments
讨论 (10)2
登录或注册以继续
文章
· 十月 24, 2024 阅读大约需 1 分钟

Maximum Number of Namespaces and Databases

InterSystems FAQ rubric

The maximum number of namespaces that can be created in one instance is 2047. However, to use a large number of namespaces, you will need to configure memory accordingly.

The maximum number of databases (including remote databases) that can be created in one instance is 15998. Depending on the type of license, there may be restrictions on the number that can be created. For details, please refer to the following document.
Database Configuration [IRIS]
Database Configuration
 

讨论 (0)1
登录或注册以继续
讨论 (0)1
登录或注册以继续
摘要
· 十月 24, 2024

Join the InterSystems Tech Video Challenge!

Dear Community member,

We'd like to invite you to participate in our first-ever video contest:

📹 InterSystems Tech Video Challenge 📹

Submit a video on any topic related to InterSystems IRIS products or services from October 21 - November 10, 2024.

🎁 Gifts for everyone + main prizes!

🔍 What’s the challenge?
Create a short video (up to 15 minutes) demonstrating a unique use of InterSystems technology. Whether it’s an innovative solution, a creative project, or a cool use case, we want to see it all!

📢 How to Enter:
To participate, you have to fill out the form where you will be required to upload your video. After we upload it to Developer Community YouTube we will post the link in the comments to this post for you to use everywhere. 

>> Full details here.

Get ready to shine and inspire others with your tech skills! We can't wait to see what you come up with. ✨

公告
· 十月 24, 2024

Seeking "Community Opportunity" Ideas!

Mullins School - PUT ON YOUR THINKING CAP! Help us... | Facebook

Do you have an idea that could make a real impact on InterSystems technology and be realised by Community members? Now’s the perfect time to share your thoughts!  

We’re preparing something exciting and would love to see the ideas you think could take InterSystems to the next level. To achieve this, we need you to come up with new ideas for our Ideas Portal that could be considered as "Community Opportunity" ideas*.

Thus, put on your thinking cap and submit your ideas on the Ideas Portal by mid-November, and stay tuned for more updates. 

We’re excited to see what you come up with! 😉


*"Community Opportunity" ideas are those that are open to be implemented by the members of the Developer Community. 

2 Comments
讨论 (2)3
登录或注册以继续