Well we don't append anything onto the URL on the form tag of the login page, so it will rely on cookies.

I haven't had it happen to me so I don't know. I've asked them to try refreshing the individual panels (frames) but I've have had no reports of them trying it and whether it succeeded or not.

Hi

Thanks both. Just turned out to be bad coding!

It was a recursive subroutine that called itself to delete the files within a folder then the folder and it wasn't newing the file name, so it was trying to delete the last file it had deleted inside the folder with the RemoveDirectory method. :/

Thanks both for your answers.

Anyone else got any ideas on getting this working so Invalid field always displays 0 or 1, but is also updateable from SQL?  Example class as follows:

In the original post I said I'm trying to do the change without needing to change any existing SQL.  If I can't fix it within Cache then I will likely have to pass the problem over to the front end (VB client)  support, but thanks again for trying.

Yes, the 1's and 0's come out then, but the field isn't updatable from SQL.  Presumably because you've now said it's transcient?

Update Wendy.LTCodes set Invalid=1 where ID = 'N002'

doesn't do anything

It doesn't work in the sense that it's not producing either 0 or 1 in the invalid column. It has blanks where it's not set.

Firstly thanks for your replies.

I've tried to incorporate your ideas into our code, but I find it's still not working.

But then I didn't really understand the use of Parameter InvalidGLVN = "^Utils.GlobalPropP";

I couldn't see that you're tell it where the "INVALID" node is set, so I've tried to create a self-contained class for my example:

Now with the Storage definition for Invalid (highlighted) that seems to override the compute code and the SQL works but it shows blanks on the rows where it's not set.

But when I remove the storage definition for Invalid and try to query the table with SQL it just falls over with

  [SQLCODE: <-400>:<Fatal error occurred>]

  [%msg: <Unexpected error occurred: <UNDEFINED>%0Go+1^%sqlcq.USER.cls2.1 *i%%CursorDatad(12)>]

Class Wendy.LTCodes Extends %Persistent [ StorageStrategy = LTCStorage ]
{

Property Code As %String;

Property Description As %String;

Property Invalid As %Library.Boolean [ SqlComputeCode = { set {*} = ##class(Wendy.LTCodes).GetInvalid({Code})}, SqlComputed, SqlComputeOnChange = Code ];

Index CodeIndex On Code [ IdKey, PrimaryKey, Unique ];

ClassMethod GetInvalid(WSCode) As %Boolean
{
    Quit +$G(^LTCODES(WSCode,"INVALID"))
}

Method InvalidGet() As %Boolean
{
    Quit ..GetInvalid(i%Code)
}

Method InvalidSet(value As %Boolean) As %Status
{
    Set ^LTCODES(i%Code,"INVALID")=value
    quit $$$OK
}

/// Do ##class(Wendy.LTCodes).SetData()
ClassMethod SetData()
{
    S ^LTCODES("N001")="ANYOLD DESC"
    S ^LTCODES("N001","INVALID")=1
    S ^LTCODES("N002")="C5 REPEAT 1"
    S ^LTCODES("N111")="SPECIMEN COMMENT"
    S ^LTCODES("N200")="MSUD SCREEN|MSUD"
    S ^LTCODES("N500")="Sickle Cell Screen"
}

Storage LTCStorage
{
<SQLMap name="LTCMap">
<Data name="Description">
<Delimiter>"|"</Delimiter>
<Piece>1</Piece>
</Data>
<Data name="Invalid">
<Node>"INVALID"</Node>
</Data>
<Global>^LTCODES</Global>
<Subscript name="1">
<Expression>{Code}</Expression>
</Subscript>
<Type>data</Type>
</SQLMap>
<StreamLocation>^Wendy.LTCodesS</StreamLocation>
<Type>%CacheSQLStorage</Type>
}

}

So is there a way I can get the above to work?