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,096
- Last Active
- Roles
- Administrator
Comments
-
My very simple tests are showing that indexing empty strings (a term I prefer to use over "null" since the latter is generally considered a datatype) will index properly. By "simple" I mean I used the SRP Editor to alternatively change the value of …
-
...that otherwise sets one of the Global @USERs variables to return my MV data string.
-
That is good news although it still leaves questions in my mind, especially since DSBFS uses ADO as well. I am somewhat curious how your SRP_Com based ADO code would have worked in OI 9.
-
I see. I don't have any insight into this issue so I can only offer some high-level ideas to help isolate the problem. First, while I'm skeptical that this is an SRP_Com specific issue, it would be worthwhile to swap out your SRP_Com calls with the …
-
I think I misunderstood your original question. I thought this was an SRP_Com problem and you were trying to figure out how to setup your MySQL calls to resolve the problem. This seems to me that you simply have a MySQL query problem. That is, if yo…
-
This is my theory based on my understanding of how Dialog_Box works in OI 9. It's been overhauled in OI 10 to avoid the problems I'm going to describe below. Dialog_Box creates a modal behavior by disabling the parent window and going into a tight …
-
This is unfamiliar to me. Do you have an example of how this is coded in straight SQL?
-
I don't know whether mixing single keys and two-part keys in the same table is valid. That depends on how you want to define valid. It is certainly valid from the standpoint that the flexibility of OpenInsight's database will allow it. Since dicti…
-
Even so, no editor can currently recognize a column lock, so the potential for data to be overwritten still exists. Locking in OI is fundamentally a social contract, so ALL locks allow the potential for data to be overwritten. You trust that other…
-
I don't have any experience with this message. I searched all of my existing archives of articles and notes and came up empty. I see the error in REVERROR.DAT next to other lock-related errors but I'm unsure what specifically generates this error.
-
I think your principles are sound but I don't think they are applicable to OI. Given that using Lock() against a column also locks the record, I question whether locking a column does anything meaningful. If anything, it seems to me that more overhe…
-
I assume you are just using the WriteV statement to update these individual date fields?
-
do you know if OpenInsight can guarantee that the dummy KeyID won't match a real keyID for an existing row? I have absolutely no idea about this. See my answer below. Is ColumnName concatenated with KeyID with nothing between them? Yes, that is …
-
Just a quick correction to your code (which I assume was not tested but quickly typed out). Unlock() uses the name of the table not the handle to the table. You can also use Unlock() for the record key itself without having to resort to the Unlock s…
-
Vince, sorry. I don't think I read your original post correctly when I first responded. Your second post set me straight. I am able to duplicate the issue. Lock and Unlocking columns still leaves the record locked. You have to explicitly unlock the…
-
I don't know the underpinnings of RTI_Lock_Owner(), but I have no doubt that editors only look for record locks.
-
Maybe it is an old bug that will disappear with an upgrade to OI 10. Just tested. Sadly this is not the case.
-
I see. I thought you already came to the conclusion that this likely a problem with the compiler being overly zealous with the variable starting with the name of a keyword and this isn't anything on you. It just seems to be an unexpected (and unwant…
-
What specifically are you wondering about? You make some interesting observations (which were honestly a surprise to me) but somewhat par for the course with Revelation. I am not sure I caught the issue you are still puzzled about.
-
That should definitely help. In our early efforts to do what you are doing we discovered these "memory leaks" after running our code for extended periods of time. I think the sample code I included in this blog post does a proper release of each obj…
-
Stopping the event flow (aka stopping the event chain) is limited to the links associated to the currently running event. By "links", I'm referring to: * Script Event handler * Promoted Event handlers (pre system) * System Event handler * P…
-
Right. I agree with your expectations in principle but you do know that the SRP Editor relies upon Blint, which is the routine that the Revelation Editor uses to identify potential VNAVs, correct? We do a little post-analysis to clean up their findi…
-
So again...
-
Does this mean you do not need any help at this point?
-
I agree that there is a false positive being recorded on line 1516, but the OI editor is reporting the same false positive...correct?
-
I just want to commend you for creating a unit test for this!
-
That's a good question. I don't know if I have ever had that situation come up before. I think BASE_MFS should be updated to identify if the table is an alias and attempt to find the table commuter for the original name, but in the meantime you prob…
-
You don't need the "OLE.". Just use the eventname. Agreed, as long as we are only discussing the registering of OLE events. When interacting with properties or calling methods, we consider prepending with "OLE." to be best practice.