Hi,

xPa 2.5 / MSSQL

I am having issues to get View Refresh to work.

I have a program P with task A (filters) calling task B as sub form (header record) which in turn has task C (line items) as a sub form. When I create a new item in task C I call a program X to ask the user what they want to create. Once data is entered they press a button which runs a batch task and creates the new record and closes X. When I return to task C I do a View Refresh and locate on the line no of the item I have just created (passed from Prog X to task C as a share memory value). This works fine.

Prog X is sized / positioned so that you can see P (A, B and C) behind it so the user can see what line items there are.

I then modified the call from task C to be Block While Z=True where Z is a virtual “Keep Looping the create call”. This virtual is sent to X as an argument and depending on which button you press in X you either return to C with Z  = True or False. If Z=False it does the view refresh / locate OK pretty much as above and stays at C locating on the last item created. If Z = True then it re-calls X for the user to create another item BUT it does not do the view refresh/locate  so the user cannot see that the item they have just created is there. They’re not sure it is there so they create same again and get duplicate index and it all gets messy. Once you have looped around as many items you want to create and press the button that sets Z=false it goes back to C, refreshes and jumps to the last line just created.

I have put in a user event to capture View Refresh and it is either not firing at all or it is firing after X is opening so does the VR there. My user event has a verify in it along the lines of <some text>&prog()&level(0)&level(1). The prog() value is that of Prog X but I cannot find any View Refreshes there.

I have even tried query/modify instead of VR and it definitely switches modes but the view does not refresh.

I have set the transaction at C to be Physical/none to see if it was transaction not completing until the Block-While was still happening but got same.

I have checked in SQL to see if records appear after each iteration of X which they do.

I have checked for open locks after each iteration of X – there are none.

I did not think what I was trying to achieve was excessively complicated but it seems I have gotten into a muddle.

Can anyone help?

TIA

Adam

Hi,

I have two parameters in C – first is the header ID to range the items by – second is one I added for the purpose you mentioned below. It is a variable in task B that I update with the shared memory value in the block while loop (I have a debug verify and the update is happening) but there is no subform refresh going on (I have another debug verify in TP of C). There is only one table in the A-B-C chain with cache turned on which I cannot turn off as it is used as data source for a combo box. Could this be issue? Like you I would expect that if I change a parameter in a subform the subform should refresh.

Thanks for help,

Adam

I deleted the combo box and the cached table went from Ctrl+D screen. Tried again and still same