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
1,071
Last Active
Roles
Member

Comments

  • Thanks @DonBakke! Looks like I have some reading to do! Sounds like I will do both. OI 9.4.6 to try and fix the site problem as it is a reasonable next step. I might also use this example to try out these new tools. Even if it doesn't help, hav…
  • I will further add I just tested this setup locally on a different 'iTMS' system and it worked OK. The only (that I *think* is relevant) differnce between the two is the remote OI is 9.4.2. Local is 9.4.6.
  • Fair enough. I will move on from that particulr Gift Horse.
  • First things first. Appreciate all the quick responses. Much appreciated. Secondly. Don for the win...again. Tested and behaves EXACTLY as Don said it would. (why do I even bother testing???) Finally, Interesting changes in OI 10 that Barry po…
  • So I gave this a very quick glance (not at all exhaustive). I ended up copying in the example code as is to my FW_MAIN Create event as all the controls and everything were named appropriately. It seems to have 'fixed' another issue I have noticed …
  • Informative as always @KevinFournier! Thanks for your hard work and best attempts at David Coperfielding the issues for us. could not be fixed with gum and hanger wire Have you not watched MacGyver? If thats enough for him to build a rustic nucl…
  • @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…
  • 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!!!