Delete Row Button

[astahl]

Hi All,

Have a delete row button which deletes the record, but when returning to browse the browse disappears until F5 key is pressed.
So it looks like there is a refresh problem on deletes or the filter is removed. Using NT11.24 and Win10.

I checked other browses and they work properly. So the question, why would this browse not refresh after a delete when others do?


Ashley

[Bruce]

Hi Ashley,

check the console log in the browser developer tools for errors.
Also check if the returned xml is valid xml.

Cheers
Bruce

[astahl]

Hi Bruce,

Not sure why I would be missing an icon when I copy all of the folders under the web folder to the site.

See attached zipped log file.


Thanks

Ashley

[Bruce]

unfortunately that log means nothing to me - I suppose we'll have to look at this during Thursday's webinar.

Cheers
Bruce

[astahl]

Hi Bruce,

Problem Resolved!! I had code under the PostDelete routine to mark records as archived in a child file. Moved the code to a source procedure and that fixed the problem.

Question since this is updating the child file this could have thousands of records to update, should one Start this proc on a thread using (NetWebServerWorker p_Web)?
The code is very simple,

DO OpenFiles
CLEAR(pre:Record)
File{PROP:SQL} = 'UPDATE File SET archived = 1 WHERE batchno = '& pbatch
DO CloseFiles
Return


Ashley

[Bruce]

that's a server-side update, so will go pretty fast I think. No need to start a new thread.

cheers
Bruce

[astahl]

Thanks Bruce

Ashley