Updating columns in a table not in current thread

[pdeetlefs]

Hi.

I am new to Clarion programming and would like to know how best to populate a column in a different table than the one that is being edited. This must happen on a close or update event in the current window.

 

[ShankarJ]

Could you give more specific information (table & field names, etc) on what you want and also tell which version of Clarion you are working with and whether you are using LEGACY or ABC templates.

 

[pdeetlefs]

ShankarJ.

Thanks for you response. I am working with Clarion 5b and ABC templates. I am busy writing a video rental system, and I want to update the main table containing video information when a video is checked out. I have an indicator in the table plus a rented date. I also need to reset this indicator when a video is returned. I have found something similar in the invoice.app demo. Will try that and see what happens.

Philip

 

[ShankarJ]

I would suggest that you have a browse showing all the videos which have been checked out. Have a button called Returned. In the Event:Accepted embed -> After Generated Code of that button do the following :

GET(Browse:Queue, CHOICE(?List))

BRW1.UpdateViewRecord()

! if the TABLE has not been retrieved as part of the browse retrieve it now

! CHANGE THE REQUIRED FIELDS IN THE TABLE

Relate:TABLE.Update()

BRW1.ResetSort(True)

DISPLAY(?List)

assuming Browse:Queue is the Queue of the Browse, ?List is the name of the List Control,BRW1 is the browse object and TABLE is the table to be updated.

Make sure that the Table is retrieved by making it part of the browse with all the relevant fields either displayed in the Browse or defined as Hot Fields.