Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

Opto_Will

About

Username
Opto_Will
Joined
Visits
753
Last Active
Roles
Member

Comments

  • @KevinFournier, I seem to be getting the Runtime Error 'Variable not assigned' when F9ing on a Record in 3.4.3.4. (F9 is my habit in the Editor to Save and Compile, even on a record where no compilation takes place). The record Saves OK so the is…
  • Ahhh, so it does. Obviously newer versions of the Controls are available, though we know Kevin is looking into an issue with the latest. I take the forum release hotfixes as 'Beta' that only I play with (unless I know it fixes a particular issue I…
  • @BarryStevens I have a downloaded history of the 4.2.x series Controls and I can verify that the registered 4.2.1.6 Is showing as such, both via Windows properties and SRP_ACTIVEX_INFO Thats is for a Control grabbed via the forums. The latest Prod…
  • We also use MDI with the Ribbon Control @BarryStevens is correct. I opened the form and went away and did something else. Came back and the form was fully accessible with no other intervention...
  • I just downloaded 4.2.2.6 (x32) to have a little preview. However, I now can't seem to enter in any (enterable) EDLs in my forms now. In my quick play it seems to be an issue on Form Open. Edit Tables are still accessible, as are Checkboxes, Radio …
  • I can confirm that I have seen this happen. Bullguard I think was the product. Avast and AVG have also triggered some false positives on client's sites for some SRP stuff, as well as oinsight.exe! We try and convince IT to exclude those folders …
  • Thanks Kevin. That makes sense although that is both tricky and scary! Clearly not adhering to MS's baseline password principles. Picking a default user password ofr MS is nothing short of frustrating. There is a B in your username? Therefore In…
  • Thats true. Security 101: 1. Install device/app/etc. 2. change default Auth details! Well, at least I can vouch for the accuracy of Don's extended response.
  • Makes perfect sense @DonBakke but now I am confused. I suspect now we do not have a SYSPROG password. However, I know I have typed what I thought the password was that I inherited and it has been 'accepted'. Would you expect success on a non-set…
  • Is that true @DonBakke? I thought that in my early days here so diligently put in the password when requested. However, someone, not naming names, said that wasn't required and to just hit Enter so I did and everything still seemed to work! Now, I…
  • Oh, and @MattCrozier, I liked your Graph! Thanks for that legwork.
  • Thanks @DonBakke and all who contributed. Very informative. Picked up two good tips for my efforts!
  • @DonBakke, Yes, Collect.IXVals would indeed be my best option. Exactly what I would be looking for an indexed field. Now if only there was a Collect.NonIXVals!!!!! I have already learned my new thing for the day so it looks like I can pack up an…
  • @BarryStevens. Thanks for that. I was counting RTI_DistinctList and SRP_ARRAY('CLEAN') as some of my 'several mechanisms' I could use to processing that list. I was more interested in more efficient ways to get that list in the first place (for a…
  • Unfortunately It is not @DOnBakke. Otherewise BTree.Extract would be the way I would go. I was trying to be simple in my example but to give a little more color, the field is actually a UDF. We are giving users the capability to use some UDFs in c…
  • I dont know if this is helpful as it is probably not related to your particular scenario but maybe it could help someone else parsing this post. Once upon a time I had an issue where the debugger wouldnt pop no matter how hard I tried. Everything …
  • Actually, now I am second guessing myself. I keep trapping a FS200 error when running the Delete_Index in the procedure as a service but no such issue when via running the procedure via TCL. I think more testing on my part is required.
  • It didnt for me from TCL. Thats why there was an assumption it was a Attach/Detach of the tables. There is a GUI there.
  • I didnt take information at face value and did some testing n my own (as I probably should have done in the first place TBH) Firstly, It doesn't appear to be UNC or permissions. The drive the service runs from is local to the server . I also st…
  • Thats a fair point @DonBakke. I try to setup services via UNC for that very reason but I have other people doing that now and they arent always quite as thorough (and definately aren't mind-readers!). I shall investigate the scenario I was present…
  • @AusMarkB Its the Copy. I am doing a Set_Status(0) PRE and a Get_Status POST so am not even getting to the Attach on subsequent runs. I am actually doing a TABLE_EXISTS check first. First Time If it doesnt exist it is a Copy_TABLE then Attach and…
    in COPY_TABLE Comment by Opto_Will July 18
  • I have done some testing comparing a Baseline (unindexed Table) with indexes created both with TableBuilder and Indexes created programatically with the Create_Index function. I will present my findings for those interesting in reading. I used two…
  • Sorry @DonBakke, yet again I have not explained myself clearly. Its not the field name but the position. Maybe this example will help: Before: Position ColumnName [Indexed] 1 CLIENT_CODE 2 ENTER_DATE Create_Index("1"", "CLIENTS", "ENT…
  • @AusMarkB The likeness is uncanny!!!
  • @FrankTomeo, That is another good idea. Easy enough to append to and delete from as a toggle. Basically maintaining my own index. I like it!
  • Makes sense @AusMarkB If I am being honest, I have done that once or twice before but didnt even thnk of it this time because I was too busy looking at the trees to see the forest. Of course, in the moments since I wrote this trying to get an effi…
  • Thanks Kevin. Its nice to not be a party of one!
    in OI Debugger Comment by Opto_Will May 31
  • Sorry for not being clear @DonBakke. @BarryStevens was right. I meant the values of the EQU in the $Insert. We often use $Inserts entries for as positional pointers (EditTables, delimited formulas, etc.) Great for what a value is representing in…
    in OI Debugger Comment by Opto_Will May 30
  • Understood. Top Left is always going to be Top Left but everything else is up for discussion....
  • Actually @KevinFournier, while I have you.... I have an oberservation/question that is roughly in the realm of what we have been talking about here. I dont know if it a Ribbon Control thing or a OI9 thing. Unfortunately we are not far enough along …