1 Topic by ian

  • ian
  • ian
  • Veteran
  • Offline
  • From: Herts
  • Registered: 26-10-2009
  • Posts: 74

Topic: Sample Admin Areas

I'm looking to script the addition of Sample Admin Areas to some of our Samples in R6 v6.28. To check what changes in the underlying tables I've manually added Sample Admin Areas to two of our Samples. The keys that were generated in the Sample_Admin_Areas table don't look like standard R6 keys:

LC0000141      !
LC0000141      "

Obviously keys with special characters in are bad news! We've not used this part of R6 before so prior to my manual addition of a couple of sample admin areas the Sample_Admin_Areas table was empty. I've checked the LAST_KEY table and the LAST_KEY_TEXT for Sample_Admin_Areas is: LC0000141      "

Thanks

Ian

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,620

Re: Sample Admin Areas

That doesn't look good. I will investigate immediately.

Mike Weideli

MikeWeideli's Website

3 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,620

Re: Sample Admin Areas

Doesn't seem to be anything wrong with adding or changing them in my copy of R6. It may be that Last key table has been corrupted somehow.  The key in the lastkey table shouldn't be in that format. Try changing it to 00000000.

Mike Weideli

MikeWeideli's Website

4 Reply by ian

  • ian
  • ian
  • Veteran
  • Offline
  • From: Herts
  • Registered: 26-10-2009
  • Posts: 74

Re: Sample Admin Areas

Thanks Mike, that's done the trick!

Ian