Table update from external SQL application

gimix

Hi everybody
i have an external app writing to "staging" tables in a NAV 5 DB - then i have a CU that reads data and updates some standard NAV tables.

Everything works fine if i run the CU once. But i need to execute it in a loop, eg every minute for 1 hour. When i launch it this way the records that are already in the staging table are processed correctly; any record which is inserted subsequently does not seem to be seen by the looping CU.

I am CLEARing the record variable i use at any loop, but it does not seem to refresh properly. Any ideas?

Thank you so much for your help
Gianni

Luc_VanDyck

Search this forum for SELECTLATESTVERSION: http://lmsmfy.com/?q=SELECTLATESTVERSION . Inserting this code will ensure you always retrieve the latest data.