go to post Kyle Baxter · Jun 14, 2017 I think it is important to remember that Row Level Security typically results in worse performance. It is better to create a VIEW and give your users access to the VIEW instead of going through this exercise.
go to post Kyle Baxter · Jun 10, 2017 Arockia,This sounds like something you might want to discuss with the WRC (which is what I do!). You will need to send over a sample table and some test data showing the problem and we'll be able to sort you out in no time. Cheers!Kyle
go to post Kyle Baxter · Jun 8, 2017 I'm unsure, exactly, what you're trying to do here. You could write a Stored Procedure that returns the value of a global pretty easily. If you need to run code before connecting via ODBC you can use "init code" set up via the $SYSTEM.SQL.SetServerInitCode() API. I'm not sure exactly what you're looking for, though.
go to post Kyle Baxter · Jun 5, 2017 So the problem here was likely that you either didn't have the method as an Expression or you weren't QUITting a value. If you have a method that you intend to use as a Webmethod (SOAP method) then you must return a value. Your options are: Method AddInteger(Arg1 As %Integer, Arg2 As %Integer) As %Integer [ WebMethod, Codemode=Expression ] { Arg1 + Arg2 } or Method AddInteger(Arg1 As %Integer, Arg2 As %Integer) As %Integer [ WebMethod ] { QUIT Arg1 + Arg2 } I'd guess you weren't quitting out the value.
go to post Kyle Baxter · Jun 2, 2017 Wellll technically NULL is a valid value for all datatypes. I think what you want to do is to interrogate the metadata information which you can do like so: SAMPLES>s stmt=##class(%SQL.Statement).%New() SAMPLES>w stmt.%Prepare("SELECT ID,Name FROM Sample.Person") 1 SAMPLES>w stmt.%Metadata.%Display() (You'll get lots of output) Note that you can do this even without running the query! You can look at %SQL.StatementMetadata in the Class Reference for more methods and properties that can help you. Note 2 - Sean's method is also perfectly valid. The only advantage to mine is that you don't have to run the query.
go to post Kyle Baxter · May 30, 2017 I agree with Mark. If you do not understand his response and/or if you still have questions, I invite you to open an issue at wrc.intersystems.com and the Support Team will help you get to the bottom of this.
go to post Kyle Baxter · May 10, 2017 While I'm not entirely sure what you are trying to do here as MLLP is a bit foreign to me, the CSP Gateway is just a module added onto a web server. If you can get the setup you want with a webserver, you can use the CSP Gateway to talk to Caché/Ensemble/HealthShare . What exactly are you trying to accomplish here? What's your goal?
go to post Kyle Baxter · May 10, 2017 That's fine - dynamic SQL has only a small overhead in comparison to embedded SQL. If you need free-text search, might I recommend iFind? Quick article here:https://community.intersystems.com/post/free-text-search-way-search-your...you do need an iKnow enabled license, but this should work on %Text fields.
go to post Kyle Baxter · May 10, 2017 If by the 'Web Services testing part' you mean a page like this:http://localhost:57772/csp/samples/SOAP.Demo.clsThat doesn't even use SOAP, it uses an HTML form submission to run the method directly. What that page does is test the logic of your webservice methods in a simple way, to make sure your desired inputs give the desired outputs. You should use something like SoapUI if you want to more completely test your SOAP methods.
