go to post David Hockenbroch · May 10, 2023 I still can't see my csp files or .bas routines in VS Code. What do I have wrong?
go to post David Hockenbroch · Mar 21, 2023 Where I've used that second option to get an IP address, I've noticed that if the client has more than one IP address, it can return different ones different times, and I'm not sure how it determines which one.
go to post David Hockenbroch · Mar 21, 2023 You can send texts through SMTP if you know the SMS gateway for the service provider. Several of these should be preconfigured on your instance of Cache or IRIS under System Administration, Security, Mobile Phone. You use the phone number @ that server as the email address to send to. For instance, if the phone number was 999-999-9999 and it was on AT&T, you'd send the email to 9999999999@txt.att.net. So that's one way to do it, but I'm sure there are better ones.
go to post David Hockenbroch · Mar 18, 2023 The last couple of times I tied this, it told me it couldn't find the jar file to download. I got it from the dev directory on my IRIS server and configured it manually.
go to post David Hockenbroch · Feb 9, 2023 Make sure your user account has an appropriate role (like %Developer or %All) and also make sure you aren't using all of your licensing.
go to post David Hockenbroch · Jan 31, 2023 We're still using a combination of Crystal Reports and ZEN reports, but also looking into Intersystems reports. I don't have much to say yet, other than that I'm also interested in this topic.
go to post David Hockenbroch · Jan 18, 2023 Here's some documentation on the INTO clause. As Robert already said, though, it's a way to do an embedded query and store the result columns into variables in the host language.
go to post David Hockenbroch · Jan 12, 2023 A parameter is a shared, constant value that's available to all instances of a class. It can be calculated when the class is compiled, but it generally can't be altered at runtime. A property is a variable that each instance of a class stores it's own value for, and it can be set changed at runtime.
go to post David Hockenbroch · Jan 10, 2023 Are you sure that's where your problem is? If I do: select MONTH(dateadd(mm,-1,GETDATE())) I get 12. If I create a query with a where clause similar to yours on my data, it works as expected.
go to post David Hockenbroch · Jan 3, 2023 I'm not sure you can do that, but is there any reason you can't define it as two web applications, one with the dispatch class and one without?
go to post David Hockenbroch · Dec 6, 2022 Where is the function func1? If it's in a routine, you'd use do $$func1^MyRoutine where MyRoutine is whatever the routine is called.
go to post David Hockenbroch · Dec 5, 2022 If you have a routine that's saved as MyRoutine.mac, that would be: do $$^MyRoutine If you have a method within the MyRoutine.mac called Process, it would be: do $$Process^MyRoutine(myargs)
go to post David Hockenbroch · Nov 18, 2022 Is that what you want to do, or should you be defining your property as: Property Status As %String(VALUELIST = ",InProgress,Done,Canceled") [ InitialExpression = "InProgress" ]; This makes InProgress the default status when a new CarDealer.Order is created.
go to post David Hockenbroch · Nov 15, 2022 Where are you seeing this error? What's running and trying to connect?
go to post David Hockenbroch · Nov 15, 2022 The only way I can get it to succeed at a test from the SSL configurations setup screen is if I check SSLv3 under the Protocols in the Crytographic settings, then have it test smtp.gmail.com, port 465.
go to post David Hockenbroch · Nov 15, 2022 This might be easier to do with XPath rather than a loop. First, you'll need to create a %XML.XPATH.Document object, maybe using the create from string method: set sc = ##class(%XML.XPATH.Document).CreateFromString(xmlstring,.mydoc) Check that the status you get back from that is not an error. If it isn't, you mydoc should be an XPath document. Then you should be able to use the EvaluateExpression method of that document to get what you want, something like: set sc = mydoc.EvaluateExpression("/Msg/Parties/Party[AgentId=1]/OrgCode","",.value) If that status is okay, the value you're looking for will be in value, unless there are multiple XML nodes that match that path. W3 provides the XPath syntax specification here.
go to post David Hockenbroch · Nov 9, 2022 SQL gateway connections provide a way to make an ODBC or JDBC connection to an external data source. It can be another IRIS instance, but doesn't have to be. So whatever you can do with either of those kinds of connections, you can do with the SQL gateways.
go to post David Hockenbroch · Nov 7, 2022 I've had to do this a time or two in a development environment. Sometimes you can find it under System Operation > Processes and terminate the process. If that doesn't work, you can look at the process ID of the process and kill it at the OS level (the kill command in Linux, or taskkill in Windows). Just be aware that depending on what it's doing and how the task was written, you may end up with some weird stuff.
go to post David Hockenbroch · Oct 14, 2022 This is good work, but there's actually already a built-in function for this in %SYSTEM.SQL.Functions.LASTDAY().
