Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
DonBakke
About
- Username
- DonBakke
- Joined
- Visits
- 3,177
- Last Active
- Roles
- Administrator
Comments
-
-
SRP_JsonX_ReadMyMindAndGoThere() works for me.
-
A "GoUp" alias would be useful. I would say, however, that part of the problem (for me at least) was not recognizing that performing a "Go" into a specific element of an array is jumping two levels deep rather than one level. That's why I intuitivel…
-
Something like that...:) Did you test with the additional "GoBack" yet?
-
Mark, I've fallen into this trap before. The problem is with your inner "Go" command: SRP_JsonX_Go('line_items[':liCount:']') This works, but you are technically jumping forward two levels from the current element. The "GoBack" command doesn't reve…
-
We've used that, or something like it, to launch actual OpenInsight sessions before. Therefore, it can work. However, as I recall, since it launches as a service without a desktop login, there is some odd behavior due to OI being invisible. I cannot…
-
The SRP Engine Server does not have the ability to run as a service in and of itself. It is a desktop app at its core. However, we have clients who use the Task Scheduler to launch it with the appropriate triggers. This should get you close to what …
-
Is this not simply a matter of attaching the table?
-
I think that much was self-evident. But why an environment variable? How would this be set in a production environment? Is this meant to be user-controlled or something your software decides? The main point is that there are so many ways to identif…
-
Maybe there still is an alternative solution. It would help to understand your use case.
-
Roger - Did you find a solution?
-
That won't work for the reason I already gave you. How about calling SetEnvironmentVariable from within OI, such as when application starts up?
-
Are you running the Set command first and then launching OI from the same command prompt?
-
Are you running the "Set" command from a different session than OpenInsight? My understanding is that "Set" only creates a temporary environment variable for that command prompt session.
-
Actually, try this: mybuffer=STR(char(0),4096) result = GetEnvironmentVariable(Variable:char(0),mybuffer,4096) return mybuffer[1,result]
-
I don't think the Win API functions are documented. I can't remember the exact calling syntax, but I imagine you just need to pass in the variable name, perhaps appended with Char(0).
-
Depending on how new your OI is, the GetEnvironmentVariable function should be defined.
-
Dude...that was a joke! I assume, and hoping, that Mark and Will understood. This is a bug, likely due to the reasons that Mark proposed. Kevin is on holiday until next week. I'm certain he will look into it when he returns.
-
May I ask why does the tab control have to make those changes. Could it made a global option. I'm not understanding you. What changes are you referring to?
-
Self-deception is a wonderful drug. If that's what Down Under is peddling then I'll continue to say, "Just say no". All joking aside, I do see some merits in right aligned labels. I think the greatest benefit is that it associates the label with it…
-
That's 0 for 3, Mark. Ain't no such thing as coffee that tastes good. Facts.
-
No. I told Kevin to always left justify text controls because that is always the right (I mean correct) way. ;-)
-
Jim - You ought to be able to use Perplexity to help you with the Basic+ code. Give it Barry's code so it will learn how Basic+ interacts with COM. Also let it know this is for Excel Automation. Armed with those two pieces of information, it should …
-
Or you can get a friendly code snippet from Barry to get you most of the way there! I haven't tested his code, but he is using the COM/Office Automation solution I mentioned. I imagine you could adapt it to your needs. Note, this is not pulling dat…
-
Jim - There is no native OpenInsight function that will read data from Excel. There is, however, functionality within OpenInsight to achieve this. The underlying solution is to use COM to interact with Excel Office Automation. There are several pos…
-
Roger - I'm glad that worked, but that is likely not a long term solution unless you set the width to be so big that it will handle any number of @SVM items.
-
Roger - Very good. I just wanted to rule out any interference from the "BY" keyword. If the column that is being sorted is multivalued, it could impact how the entire report is rendered. That said, I would remove "BY BIG04" since it serves no purpos…
-
Why does the original LIST statement filter BIG04 to a specific value and also sort by that column? Is BIG04 a single value or multivalue column
-
Roger - That does help somewhat. Which of these columns are associated? Which ones are unassociated? Finally, exactly how do you want this to look in the Run_Report output? Are you trying to flatten out all @SVMs? Perhaps if you mocked up the layout…
-
I'm at a disadvantage because I don't know how the data is stored in its natural state nor do I know what these fields represent. For example, why were @SVMs used in the first place? Ordinarily I would expect an @SVM to only be used when the field i…