Hi,

I'm trying to store a time in a hfsql databaase. Its a time inputed by
the user and so is held in a variable before trying to add it to the
file. However when trying to write it in the database I get a read only
error.

Here is the code:

HSeekFirst(RoadShow,RoadShowID,Form)
IF HFound(RoadShow) THEN
IF EDT_Authorisation = RoadShow.Authorisation THEN
Client_RoadShow.ClientID = ClID
Client_RoadShow.RoadShowID = Form
Client_RoadShow.TrackTime = Time
Client_RoadShow.Comments = Comments
HAdd(Client_RoadShow)
MySelf..Visible = False
ELSE
Info("Incorrect Authorisation","Please get a SAM member to
confirm your track time")
END
END

The code is on a button press and causes this error message:

'The "TrackTime" item is read-only.'

Note that I can't ScreenToFile this as it is on an authorisation
internal window which shows after entering the information and sending it.

How can I avoid this? I can't find any mention on how to change it.

Cheers,

Ben Clarke

I am quite sure. I cannot see any reason for TrackTime to have issues.
What could cause a Time database item to appear read only?

Here is exactly how the database file is setup






Its definitely set to a Time variable...