Messages

1

Web Server - Ask For Help / Re: Table update Netwebform with popup memory forms

« on: August 21, 2025, 02:23:13 AM »

Hi Ron

Thanks, that is a very clear explanation.

You have confirmed what I understand it to do with some more information that is very helpful

thanks

Johan

2

Web Server - Ask For Help / Table update Netwebform with popup memory forms

« on: August 20, 2025, 11:56:16 PM »

Hi,

I have a table update FORM, the master.

On it I have a few buttons that call small popup forms that also update some of the same table fields, the popup form are memory forms.
These fields are sometimes display fields on the master FORM, sometimes not.

It all seems to work and the table fields from the popups are updated and saved, but still testing the process to make sure all is reliable.

The way I undestand is that the Table update form will write the record from the session variables?

Is there anything to follow to make this process 100% reliable?
eg. call a certain sync routine to ensure all is good?

Is there perhaps a webinar or resource that discusses simialr process that will be of use?


thanks

Johan

3

Web Server - Ask For Help / Re: How to debug this slow request?

« on: August 08, 2025, 10:32:16 AM »

Hi Ron

Yes have to agree with that.
However it's good to attempt and get things to look as PRO as possible as well as easy as possible

regards

Johan

4

Web Server - Ask For Help / Re: How to debug this slow request?

« on: August 08, 2025, 02:45:43 AM »

Hi Bruce/Jane/Ron

Thanks for all your input and ideas thus far, thought I should give some feedback.

There are 2 seperate issues that have contributed to my slow request problem.

1)
Initially I thought it was the DB access but this only seems to be an issue if the Browse row is refreshed, then it seems to read through the whole file.
If the whole Browse is refresh this is not an issue.

2)
The other issue which Jane alluded to was the dropbox creation.
Each EIP dropbox has about 30 options and on a large browse (80 lines) this is a fair amount as each line has all the options.

The code that generates the dropbox is very quick and the page completes however it seems that once it's done and hands back to the browser,
the JS could have a problem with the complex html and there is a slowdown with the refresh.
I don't have any experience in this area, so can't confirm 100%
Again hoping that the example will either confirm or point our where I'm going wrong.

Have created and submitted 2 example apps, either to confirm the issues or where I am doing something wrong.



To solve my issue for now, I refresh the whole browse, and I removed the EIP dropdown , instead used a popup update window to update the qty.

thanks,

Johan

5

Web Server - Ask For Help / Re: How to debug this slow request?

« on: July 31, 2025, 10:00:56 PM »

Hi Jane

Asked in the NT user group last night, still no resolve,
but the problem is outside of the procedures.

Once I have more info will post what I've found


thanks

Johan

6

Web Server - Ask For Help / Re: How to debug this slow request?

« on: July 30, 2025, 10:53:08 AM »

Hi Jane

Thanks for that idea, will have a look,
it's a decent length, perhaps 20 entries, so will play a roll, but don't think that's the culprit.

Also need to cleanup my procedure and all debug lines, and look with fresh eyes. 

thanks


Johan

7

Web Server - Ask For Help / Re: How to debug this slow request?

« on: July 30, 2025, 03:07:59 AM »

Hi,

Currently have had to remove the EIP dropbox and replaced it with a popup UpdateForm.

Will return to the problem when I get a chance, and will post any findings.

thanks

Johan

8

Web Server - Ask For Help / Re: How to debug this slow request?

« on: July 29, 2025, 10:27:15 AM »

Hi Bruce

Any advice on how to find this possible problem?

Been chasing all sorts of things past few days, but still having an issue.


From your post earlier
>>>>>>>>>>>>>>>>>>>>
My guess is that the reply to the browser is not completing. ie you have some code in the thread, after the drop down is populated, which delays the ending of the thread. In that case the connection is not closed, so the browser does not start processing the reply.
>>>>>>>>>>>>>>>>>>>>

thanks

Johan

9

Web Server - Ask For Help / Re: How to debug this slow request?

« on: July 27, 2025, 09:50:16 PM »

Hi Ron

thanks for the idea, am looking into it.
The key is Case sensitive and the filter is constructed by the EIP code

My understanding is if Case sensitive key then UPPER not required?


thanks

Johan

10

Web Server - Ask For Help / Re: How to debug this slow request?

« on: July 26, 2025, 12:43:26 AM »

Hi Bruce

Think I found the line that takes roughly 5secs
In the LoadViewRecord

It's the next(p_view) between 5555 and 6666
Still using TPS, not sure if this is an issue

Below the code and the view structure.

My next step is going to duplicate and handcode the action of the view and see if it does the same and also to see if there is something to be done.

Any ideas highly appreciated.

Johan


NetWebServerWorkerBase.LoadViewRecord  Procedure(View p_View,File p_File,Key p_Key)
err Long
f   String(1024)
  code

  self.trace('TVCweb LoadViewRecord 1111:' & format(clock(),@t06))     
  f = p_view{prop:filter}
  self.trace('TVCweb LoadViewRecord 2222:' & format(clock(),@t06))     
 
  p_view{prop:filter} = ''
  self.trace('TVCweb LoadViewRecord 3333:' & format(clock(),@t06))     
  self.trace('TVCweb LoadViewRecord 3333Filter=:' & p_View{prop:filter})     
 
  self.AddKeyToFilter(p_View,p_File,p_Key)
 
  self.trace('TVCweb LoadViewRecord 4444:' & format(clock(),@t06))     
  self.trace('TVCweb LoadViewRecord 4444Filter=:' & p_View{prop:filter})     
 
  set(p_view)
 
  self.trace('TVCweb LoadViewRecord 5555:' & format(clock(),@t06))     
  next(p_view)
  self.trace('TVCweb LoadViewRecord 6666:' & format(clock(),@t06))     
 
  err = errorcode()
  self.trace('TVCweb LoadViewRecord 7777:' & format(clock(),@t06))     
 
  p_view{prop:filter} = self.AssignFilter(f)
  self.trace('TVCweb LoadViewRecord 8888:' & format(clock(),@t06))     
 
  return err



View:item       View(item)
                      Project(ite:item_isn)
                      Project(ite:item_desc)
                      Project(ite:item_amt)
                      Project(ite:item_qty)
                      Project(ite:item_gr_total)
                    END ! of ThisView

11

Web Server - Ask For Help / Re: How to debug this slow request?

« on: July 25, 2025, 06:08:01 AM »

Hi Bruce

Thanks for the reply.

Are you referring to the code in the "Client Side" server code button embed
the only code I have there executes super fast.

      ds_OutputDebugString('TVCweb MyCode Start:' & format(clock(),@t06))
      do calc_rest_of_flds 
      ds_OutputDebugString('TVCweb MyCode End:' & format(clock(),@t06))

Or is there code somewhere else that is still executing on a thread even though the page is populated?

thanks

Johan

12

Web Server - Ask For Help / How to debug this slow request?

« on: July 25, 2025, 03:46:25 AM »

Hi,

I have a browse list with EIP on a dropdown to update the item qty
Only the row is updated currently.
I have also attached a debug logfile of when I click the dropdown to when the page is updated.
The update code is super quick, but lines below is the problem.
How and where can I debug this?


These lines in the attached debug log take 7secs to execute with the busy wheel displaying

Currently trying the browser devtools to see but was hoping there might be some feedback from someone.

thanks
Johan


63   13:20:21.239   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
64   13:20:21.239   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
65   13:20:22.249   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
66   13:20:22.249   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
67   13:20:23.240   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
68   13:20:23.240   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
69   13:20:24.242   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
70   13:20:24.242   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
71   13:20:25.239   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
72   13:20:25.239   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
73   13:20:26.241   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
74   13:20:26.242   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end
75   13:20:27.246   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 start
76   13:20:27.246   28064   xtvcweb.exe   [NetDLL] [2] CallBackWindowSrc() : NTThread Event : 523 end

I've had a similar issue before with a different procedure and when I reworked the procedure it resolved the issue without me knowing what caused the problem.

13

Web Server - Ask For Help / Re: Multi-Site host flashes error message

« on: July 24, 2025, 02:17:51 AM »

Hi Jeff

If it is a MessageBox screen perhaps the time is too short.
It's 100's of a second, try to increase, and there are also logging options

regards

Johan

14

Web Server - Ask For Help / Re: Error in Site Javascript Flash at the top of the page

« on: March 05, 2025, 11:35:32 PM »

Hi Jane

Thanks!
Time to change my spectacles,
my mistake was to click the Deployment option button and assumed that the settings would be correct to deploy, and did not check that page closely enough.

cheers,

Johan

15

Web Server - Ask For Help / Error in Site Javascript Flash at the top of the page

« on: March 04, 2025, 01:52:25 AM »

Hi,

Can't recall on how to fix this or what is causing it.
I thought it was a check when in Debug mode that it does java script check and if disappears all is well, but I am in Prod mode and suppress errors are clicked on?

Any other settings I've missed?

regards

Johan