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.
Pages: [1]
1
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
2
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.
3
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
4
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
5
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
6
Web Server - Ask For Help / jQuery and NTWS
« on: September 16, 2009, 03:58:59 PM »
Im trying to implement an accordion menu from DynamicDrive in a NTWS site. It uses jQuery and needless to say, there is a conflict somewhere.
Ive tried all the jQuery recommended strategies to eliminate the conflict (.noConflict, hard coding, etc), but none of these things offers progress.
Any ideas would be welcome.
Mark
Ive tried all the jQuery recommended strategies to eliminate the conflict (.noConflict, hard coding, etc), but none of these things offers progress.
Any ideas would be welcome.
Mark
7
Web Server - Ask For Help / passing javascript values on forms
« on: August 16, 2007, 05:21:33 PM »
Bruce,
The inline javascript Ive tried works fine, but for some reason, I cannot get the functions like the one Alan Cochran did (and others built like it) to work. It's like they don’t have access to this.value or something.
function toProperCase(s)
{
return s.toLowerCase().replace(/^(.)|\s(.)/g,
function($1) { return $1.toUpperCase(); });
}
This is one Bob found on the net (at http://www.codeproject.com/jscript/propercase.asp ) that works fine in a regular page, but I cannot get it to return a capitalized value - or ANY value for that matter.
At one point, I had it doing this, just to see if it would give me anything.
In the validation field in the Nt4 app for this field, it says 'toProperCase(this.value);'
function toProperCase(s)
{
var txtstr = s;
txtstr.toUpperCase();
alert('after upper ' + txtstr);
txtstr.toLowerCase();
alert('after lower ' + txtstr);
txtstr.toLowerCase().replace(/^(.)|\txtstr(.)/g,
function($1) { return $1.toUpperCase(); });
alert('after replace ' + txtstr);
return txtstr;
}
When I type "firstname" in the field and press tab, the alerts produced these messages:
after upper firstname
after lower firstname
after replace firstname
IE: none of the toUpperCase stuff ever took. Tested on FF 2.006 and IE7 on Vista. Same results.
Clearly I missing something. Got an idea what it might be?<g>
Mark
The inline javascript Ive tried works fine, but for some reason, I cannot get the functions like the one Alan Cochran did (and others built like it) to work. It's like they don’t have access to this.value or something.
function toProperCase(s)
{
return s.toLowerCase().replace(/^(.)|\s(.)/g,
function($1) { return $1.toUpperCase(); });
}
This is one Bob found on the net (at http://www.codeproject.com/jscript/propercase.asp ) that works fine in a regular page, but I cannot get it to return a capitalized value - or ANY value for that matter.
At one point, I had it doing this, just to see if it would give me anything.
In the validation field in the Nt4 app for this field, it says 'toProperCase(this.value);'
function toProperCase(s)
{
var txtstr = s;
txtstr.toUpperCase();
alert('after upper ' + txtstr);
txtstr.toLowerCase();
alert('after lower ' + txtstr);
txtstr.toLowerCase().replace(/^(.)|\txtstr(.)/g,
function($1) { return $1.toUpperCase(); });
alert('after replace ' + txtstr);
return txtstr;
}
When I type "firstname" in the field and press tab, the alerts produced these messages:
after upper firstname
after lower firstname
after replace firstname
IE: none of the toUpperCase stuff ever took. Tested on FF 2.006 and IE7 on Vista. Same results.
Clearly I missing something. Got an idea what it might be?<g>
Mark
8
Web Server - Ask For Help / Span prompt/value/comment
« on: August 15, 2007, 03:30:48 PM »
What does "Span prompt/value/comment" do? It isnt obvious from checking the box
This is on the webform template.
Mark
This is on the webform template.
Mark
9
Your Views and Comments / Wiki?
« on: August 12, 2007, 11:15:45 AM »
There are a number of sizable gaps in the documentation for the web server.
Would it be worthwhile to create a wiki from the existing docs, place it here, have us update it as we discover the meaning of things and offer the changes to Bruce as he sees fit?
Mark
Would it be worthwhile to create a wiki from the existing docs, place it here, have us update it as we discover the meaning of things and offer the changes to Bruce as he sees fit?
Mark
10
Web Server - Ask For Help / Refresh frame menu?
« on: August 10, 2007, 04:01:08 PM »
Im working on an app for a guy and need to refresh the frame menu, which is partly driven by session variable contents. Thing is, the nature of the frame menu portion of the frame is that it isnt refreshed.
How should I get the menu portion of the frame to refresh?
My thought is figure out a way to get javascript to do it if possible (note: refresh must be initiated from a different part of the frame), but I thought perhaps there was a better idea out there.
Mark
How should I get the menu portion of the frame to refresh?
My thought is figure out a way to get javascript to do it if possible (note: refresh must be initiated from a different part of the frame), but I thought perhaps there was a better idea out there.
Mark
11
Web Server - Ask For Help / FORM: setting values based on a change in a drop down
« on: August 02, 2007, 11:21:33 PM »
I have webform that has a drop down on it.
Drop down is state code. State file has a country field on it. Country name is coming back properly when state code is selected.
There is a country table as well. For whatever reason, this code has countrytable:countryfield on the form - even though the table being updated is the customer table (which oddly enough has no country field).
Clear as mud, right?
I have the statetable:statecode field set to reset the countrytable:countryfield field when it changes.
Mostly due to LPS, in the countrytable:countrynamefield value routine, i do a countrytable:countrynamefield = statetable:countrynamefield (and Ive confirmed that the statetable:countrynamefield field has the proper data in it).
BUT, the countrytable:countrynamefield on the form (displayed) NEVER has any text in it.
This occurs whether countrytable:countrynamefield is marked on the form as read only, or not.
I know, confusing. I inherited it (several times a day, in fact) and Im trying to get it to work the way it is.
A) is that a pipe dream
B) what'd I miss here re: displaying that field?
thanks,
Mark
Drop down is state code. State file has a country field on it. Country name is coming back properly when state code is selected.
There is a country table as well. For whatever reason, this code has countrytable:countryfield on the form - even though the table being updated is the customer table (which oddly enough has no country field).
Clear as mud, right?
I have the statetable:statecode field set to reset the countrytable:countryfield field when it changes.
Mostly due to LPS, in the countrytable:countrynamefield value routine, i do a countrytable:countrynamefield = statetable:countrynamefield (and Ive confirmed that the statetable:countrynamefield field has the proper data in it).
BUT, the countrytable:countrynamefield on the form (displayed) NEVER has any text in it.
This occurs whether countrytable:countrynamefield is marked on the form as read only, or not.
I know, confusing. I inherited it (several times a day, in fact) and Im trying to get it to work the way it is.
A) is that a pipe dream
B) what'd I miss here re: displaying that field?
thanks,
Mark
Pages: [1]