Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / Re: Child browse to parent update form
« on: January 08, 2020, 10:34:22 AM »I'm sure the double click is possible but would your customer consider using an in row button to open the form?
If there's no choice, I can do that but they'd clearly prefer the double click.
2
Web Server - Ask For Help / Child browse to parent update form
« on: January 07, 2020, 10:58:32 PM »
In a related matter to the question I posted the other day...
table LAAS_CONTACT -> table LAAS_ACTIVITY
LAAS_ACTIVITY is a child to the LAAS_CONTACT. This child table has netwebbrowse in date order (called ViewFollowUps) – this browse does not have a parent filter on it. Think of it as a list “todo items that relate to a specific contact”. It shows these items for the entire contact list.
Customer wants to open the parent record (LAAS_Contact) update form when double clicking on the child table’s web browse (ViewFollowUps, which is a netwebbrowse for LAAS_ACTIVITY).
I have tried a number of different angles at this, including the settings below. They all result in the form opening, giving an error message and not displaying any data. I’m pretty sure I’m “using it wrong” but it isnt clear how. The activity table has the parent key in it (see Key_ContactID below). Various attempts to add the parent key to the view, set it up via SetValue or SSV at the very top of UpdateContact have yielded similar results.
Note: this contact update form is also used as the form from a standard netwebbrowse for LAAS_CONTACT so I have to be careful not to break it:)
Any ideas? I didn’t see anything like this here in nettalk central that looked quite like this. And yes, this is the same DCT/project from the odd question I posted a few days ago.
Mark
table LAAS_CONTACT -> table LAAS_ACTIVITY
LAAS_ACTIVITY is a child to the LAAS_CONTACT. This child table has netwebbrowse in date order (called ViewFollowUps) – this browse does not have a parent filter on it. Think of it as a list “todo items that relate to a specific contact”. It shows these items for the entire contact list.
Customer wants to open the parent record (LAAS_Contact) update form when double clicking on the child table’s web browse (ViewFollowUps, which is a netwebbrowse for LAAS_ACTIVITY).
I have tried a number of different angles at this, including the settings below. They all result in the form opening, giving an error message and not displaying any data. I’m pretty sure I’m “using it wrong” but it isnt clear how. The activity table has the parent key in it (see Key_ContactID below). Various attempts to add the parent key to the view, set it up via SetValue or SSV at the very top of UpdateContact have yielded similar results.
Note: this contact update form is also used as the form from a standard netwebbrowse for LAAS_CONTACT so I have to be careful not to break it:)
Any ideas? I didn’t see anything like this here in nettalk central that looked quite like this. And yes, this is the same DCT/project from the odd question I posted a few days ago.
Mark
3
Web Server - Ask For Help / Re: Parent browse to parent update to child update - automatically priming PKID
« on: January 07, 2020, 10:15:21 PM »How do you have priming setup under the form(s) priming tab?
Ive tried the tableprefix:field. Ive tried the GetValue(). Ive tried the GSV(). Ive probably tried a few other things that I no longer remember:) None of them have escaped the stale issue, or theyre empty.
4
Web Server - Ask For Help / Parent browse to parent update to child update - automatically priming PKID
« on: January 03, 2020, 12:04:24 PM »
Been using NTWS for over a decade, but almost always for API stuff, so I can never seem to remember the basics of the UI side of things.
I have a browse for customers. The customer update form has browses for child tables. When I insert a child, I expect the parent key to be set properly in the child form, but it isnt. In fact, the GV or GSV values arent correct (they're "stale") so I cant use those.
Example 23 looks like the closest fit, but it isnt really the same thing. Ex 23 uses the advanced tab's "Prime key from parent table" feature, but that doesnt seem to work when going from browse to form to form.
Even when I use "Prime Key from parent table" and have it set to the proper parent table, the value that gets set for the child's FK (parent) value is stale unless i go into the parent update form twice.
Here's a (hopefully) more descriptive version of what I am seeing:
If I browse to customer 1, then open the customer update form for customer 1, then close the update form, then browse to customer 2, then open customer update form for customer 2, then open the update form for customerchild as an insert - customer ID 1 is on the customerchild form. The parent child relationship is defined in the DCT.
If I browse to customer 1, browse to customer 2, open customer update form for customer 2, close the update form, then reopen the customer update form for customer 2, then open the customerchild form for insert, THEN customer ID 2 is on the customerchild form. Obviously, this is not correct, nor is it something youd expect a customer to do.
I fixed it by creating a uniquely named session variable when the parent form opens (set to the parent PKID). That SV gets used in the initform routine of the form procedure to prime the child's PK value (the parent's PKID).
Because of all the fun I had with this, Im wondering if there's a better way to solve the parent browse-parent-update-child-update scenario.
I have a browse for customers. The customer update form has browses for child tables. When I insert a child, I expect the parent key to be set properly in the child form, but it isnt. In fact, the GV or GSV values arent correct (they're "stale") so I cant use those.
Example 23 looks like the closest fit, but it isnt really the same thing. Ex 23 uses the advanced tab's "Prime key from parent table" feature, but that doesnt seem to work when going from browse to form to form.
Even when I use "Prime Key from parent table" and have it set to the proper parent table, the value that gets set for the child's FK (parent) value is stale unless i go into the parent update form twice.
Here's a (hopefully) more descriptive version of what I am seeing:
If I browse to customer 1, then open the customer update form for customer 1, then close the update form, then browse to customer 2, then open customer update form for customer 2, then open the update form for customerchild as an insert - customer ID 1 is on the customerchild form. The parent child relationship is defined in the DCT.
If I browse to customer 1, browse to customer 2, open customer update form for customer 2, close the update form, then reopen the customer update form for customer 2, then open the customerchild form for insert, THEN customer ID 2 is on the customerchild form. Obviously, this is not correct, nor is it something youd expect a customer to do.
I fixed it by creating a uniquely named session variable when the parent form opens (set to the parent PKID). That SV gets used in the initform routine of the form procedure to prime the child's PK value (the parent's PKID).
Because of all the fun I had with this, Im wondering if there's a better way to solve the parent browse-parent-update-child-update scenario.
5
Web Server - Ask For Help / Re: SSL issue on 11.21 on Windows Server 2019
« on: September 26, 2019, 09:36:55 AM »
The cert is correct. That part worked fine. What fails is when you actually try to browse to the site and login.
6
Web Server - Ask For Help / Re: SSL issue on 11.21 on Windows Server 2019
« on: September 26, 2019, 06:42:16 AM »
No progress on this. I installed everything on a Server 2016 system to make sure it wasnt an oddity about 2019 - same issue, so Im still thinking I did something weird.
7
Web Server - Ask For Help / SSL issue on 11.21 on Windows Server 2019
« on: September 25, 2019, 07:03:18 AM »
I'm almost certain this is caused by something I've done wrong, but I haven't found it yet, so I'll post this here so it will come to me seconds after I click "POST" 
I am getting these errors when trying to connect to a HTTPS (LE certificate) NTWS server. The certificate validates fine, the name is correct and the pages not secured by login serve ok, but I see these log entries (below) on every browse attempt. When I attempt to use the login form (which is in out of the box form for testing), I get these errors and the login never succeeds - in fact, ODS displays give the impression that the validateupdate embed in the login form never gets control.
[NetDLL] [2] SimpleServer_Async - ReadData() : rd1
[NetDLL] [2] SimpleServer_Async - ReadData() : rd2
[NetDLL] [2] SSL_Our_ServerRead() : SSL Error calling SSL_Read : SSL_ERROR_SYSCALL [] Some I/O error occurred. SSL Error Code = 5
[NetDLL] [2] SimpleServer_Async - ReadData() : rd3 loc:SSLErrorNumber=0
[NetDLL] [2] SimpleServer_Async - ReadData() : SimpleServer_Async loc:ret (A) = 0 loc:rc=-75
[NetDLL] [2] SimpleServer_Async - ReadData() : SimpleServer_Async loc:ret (B) = 0
[NetDLL] [2] NetErrorStr() : Error (0) = General Winsock Error (unknown by NetErrorStr)
[NetDLL] [2] SimpleServer_Async() : ReadCount = 0
[NetDLL] [2] SimpleServer_Async() : Calling CloseSocket on socket=1228
[NetDLL] [2] SimpleCloseSocket - Graceful Close() : Calling SetSockOpt. Linger = 1 3
[NetDLL] [2] SimpleCloseSocket() : p_lpSSL start
[NetDLL] [2] SSL_Our_Close() : Before SSL_Shutdown 13053232
[NetDLL] [2] SSL_Our_Close() : Result (SSL_Shutdown) = -1
[NetDLL] [2] SSL_Our_Close() : Before SSL_Free 13053232
[NetDLL] [2] SSL_Our_Close() : After SSL_Free
I am getting these errors when trying to connect to a HTTPS (LE certificate) NTWS server. The certificate validates fine, the name is correct and the pages not secured by login serve ok, but I see these log entries (below) on every browse attempt. When I attempt to use the login form (which is in out of the box form for testing), I get these errors and the login never succeeds - in fact, ODS displays give the impression that the validateupdate embed in the login form never gets control.
[NetDLL] [2] SimpleServer_Async - ReadData() : rd1
[NetDLL] [2] SimpleServer_Async - ReadData() : rd2
[NetDLL] [2] SSL_Our_ServerRead() : SSL Error calling SSL_Read : SSL_ERROR_SYSCALL [] Some I/O error occurred. SSL Error Code = 5
[NetDLL] [2] SimpleServer_Async - ReadData() : rd3 loc:SSLErrorNumber=0
[NetDLL] [2] SimpleServer_Async - ReadData() : SimpleServer_Async loc:ret (A) = 0 loc:rc=-75
[NetDLL] [2] SimpleServer_Async - ReadData() : SimpleServer_Async loc:ret (B) = 0
[NetDLL] [2] NetErrorStr() : Error (0) = General Winsock Error (unknown by NetErrorStr)
[NetDLL] [2] SimpleServer_Async() : ReadCount = 0
[NetDLL] [2] SimpleServer_Async() : Calling CloseSocket on socket=1228
[NetDLL] [2] SimpleCloseSocket - Graceful Close() : Calling SetSockOpt. Linger = 1 3
[NetDLL] [2] SimpleCloseSocket() : p_lpSSL start
[NetDLL] [2] SSL_Our_Close() : Before SSL_Shutdown 13053232
[NetDLL] [2] SSL_Our_Close() : Result (SSL_Shutdown) = -1
[NetDLL] [2] SSL_Our_Close() : Before SSL_Free 13053232
[NetDLL] [2] SSL_Our_Close() : After SSL_Free
8
Web Server - Ask For Help / Re: programatically restart the service
« on: September 25, 2019, 06:47:57 AM »
I'd suggest creating another service, accessible via browser, whose only job is to provide admin functions remotely without their having to know much of anything. Give them a browser button to stop the service, start the service, and restart the service. The NTWS service can easily run cmd /c net start and cmd /c net stop, or do the same via oddjob. Then you dont have to worry about them having access to the console, cpanel, admin login, etc.
9
The Rest - Ask For Help / Re: NetWebClient cant reach out to the net - except when elevated
« on: December 10, 2018, 08:19:51 AM »
It turned out that something in windows was terribly upset that the EXE and the dll were both referencing Winevent5 calls. Once I made the exe refer to the dll's instance of WE - everything worked again. <wipes sweat from brow>. Weird situation. No diagnostic data anywhere. Just got lucky.
Mark
Mark
10
The Rest - Ask For Help / NetWebClient cant reach out to the net - except when elevated
« on: December 07, 2018, 10:44:14 AM »
Have you ever seen a situation where a https fetch never gets off the client machine, despite having firewall/AV off, and/or having FW on and inbound/outbound exceptions in place? There's nothing in the eventviewer, nothing in debugview, nothing anywhere that Ive found that is alerting on this connection attempt.
AsInvoker - cant reach out to any machine via Nettalk, but can via C++ web calls.
As admin - nettalk works fine.
This app is using a fairly current (10.15) NT10 in this case.
Mark
AsInvoker - cant reach out to any machine via Nettalk, but can via C++ web calls.
As admin - nettalk works fine.
This app is using a fairly current (10.15) NT10 in this case.
Mark
11
Web Server - Ask For Help / Re: Today's alert_div webinar question
« on: May 08, 2015, 02:41:08 PM »
All I have to say about that is that you should take the rest of the day off, cuz that seemingly little thing is awesome for the overall UX:)
Thanks Bruce, appreciate it.
Mark
PS: I agree, I dont think it was ever on a timer.
Thanks Bruce, appreciate it.
Mark
PS: I agree, I dont think it was ever on a timer.
12
Web Server - Ask For Help / Today's alert_div webinar question
« on: May 07, 2015, 04:15:47 PM »
Today, Bruce and I were searching our memory banks during the NTWS webinar.
I thought I remembered that there was a way to have the code (below) update #alert_div (the red line on shoestrap) with the text in loc:alert, unhide the red line and NOT popup a message with the same text. I think Bruce also seemed to recall that used to exist in some form.
Alas, our older brain cells were at the beach today, so we didn't recall what the cure is. I remember that on NTWS 6 (or maybe 7), this was a relatively simple matter, but many things have improved/moved/changed since then.
While you can certainly use
... this creates other work like hiding the div (and clearing the text) after some acceptable point in time - something that used to happen automatically in the olden days when html was carved from the tusk of a Amazonian piranha.
At least thats how I remember it:)
Mark
I thought I remembered that there was a way to have the code (below) update #alert_div (the red line on shoestrap) with the text in loc:alert, unhide the red line and NOT popup a message with the same text. I think Bruce also seemed to recall that used to exist in some form.
Code: [Select]
loc:alert = 'blarg!'
do SendMessageAlas, our older brain cells were at the beach today, so we didn't recall what the cure is. I remember that on NTWS 6 (or maybe 7), this was a relatively simple matter, but many things have improved/moved/changed since then.
While you can certainly use
Code: [Select]
p_web.Script('$(''#alert_div'').show();')
p_web.Script('$(''#alert_div'').html(''Blarg'!');') ... this creates other work like hiding the div (and clearing the text) after some acceptable point in time - something that used to happen automatically in the olden days when html was carved from the tusk of a Amazonian piranha.
At least thats how I remember it:)
Mark
13
Web Server - Ask For Help / Re: Push notification
« on: May 07, 2015, 04:09:29 PM »
Thats good news. Thanks:)
14
Web Server - Ask For Help / Re: Push notification
« on: May 06, 2015, 04:09:38 PM »
Something else that will do this and is "more modern" than websockets is Server Sent Events. See http://html5rocks.com/en/tutorials/eventsource/basics/
15
Web Server - Ask For Help / Re: C9.1-11139, NetTalk 8.22, ClarionCL
« on: February 12, 2015, 07:36:23 PM »
I sent bruce a fix for this issue a couple of months ago.