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.
136
Web Server - Ask For Help / Re: SQL browse problem
« on: September 09, 2021, 05:02:05 PM »
Bruce was kind enough to take a look at today's NetTalk webinar.
He found that a call to p_web.RestoreValue is needed to reset loc:vordernumber to the correct value at the beginning of the SetVorder routine in the browse procedures.
Otherwise the browses use the correct sort order when you click the header but then revert to the default loc:vordernumber for subsequent pages and choke and die.
This is a side effect of some of the new stuff he's been building involving the change to using &View for ThisView.
So one line of code in each browse and now they work fine.
He found that a call to p_web.RestoreValue is needed to reset loc:vordernumber to the correct value at the beginning of the SetVorder routine in the browse procedures.
Otherwise the browses use the correct sort order when you click the header but then revert to the default loc:vordernumber for subsequent pages and choke and die.
This is a side effect of some of the new stuff he's been building involving the change to using &View for ThisView.
So one line of code in each browse and now they work fine.
137
Web Server - Ask For Help / Re: SQL browse problem
« on: September 09, 2021, 10:09:22 AM »
Resolved.
138
Web Server - Ask For Help / Re: SQL browse problem
« on: September 09, 2021, 06:48:40 AM »
I'm using 11.0.13401
139
Web Server - Ask For Help / Re: SQL browse problem
« on: September 08, 2021, 07:14:00 AM »Hi Jane, it worked perfect for me in NT 12.23 and NT 12.25Well... why does it love you and hate me ??
140
Web Server - Ask For Help / SQL browse problem
« on: September 07, 2021, 01:39:02 PM »
Hi, Bruce,
I'm going to see if you can help me with this in this week's NT webinar.
I've been converting an app from 11.x to 12.25. I've resolved most of the issues but still have one that's flummoxing me.
Some of the sort headers I've customized, others are just the field value. They all work fine in the 11.x app.
But with the 12.25 version, I click on a header and it sorts correctly. But then clicking the Next button gives a "no records" message and an empty browse.
Attached is a wizarded app that illustrates the problem. There's also a script to create a test MSSQL database and table with data for the test app.
Looking forward to Thursday
Cheers,
Jane
I'm going to see if you can help me with this in this week's NT webinar.
I've been converting an app from 11.x to 12.25. I've resolved most of the issues but still have one that's flummoxing me.
Some of the sort headers I've customized, others are just the field value. They all work fine in the 11.x app.
But with the 12.25 version, I click on a header and it sorts correctly. But then clicking the Next button gives a "no records" message and an empty browse.
Attached is a wizarded app that illustrates the problem. There's also a script to create a test MSSQL database and table with data for the test app.
Looking forward to Thursday
Cheers,
Jane
141
Web Server - Ask For Help / Re: Select list greybar 12.25?
« on: September 07, 2021, 08:39:02 AM »
Dang-it, Bruce. I hunted for that.
Thanks!
Easier for me is to put the tweaked variables into my custom CSS rather than modifying nt-theme.css. That way I don't have to redo if you ship a new version of nt-theme.css.
Now, is there a similar variable that will squeeze the line height a bit on those dropdowns without modifying the --Line-height value for the entire site?
Cheers,
Jane
Thanks!
Easier for me is to put the tweaked variables into my custom CSS rather than modifying nt-theme.css. That way I don't have to redo if you ship a new version of nt-theme.css.
Now, is there a similar variable that will squeeze the line height a bit on those dropdowns without modifying the --Line-height value for the entire site?
Cheers,
Jane
142
Web Server - Ask For Help / Re: Select list greybar 12.25?
« on: September 06, 2021, 06:40:46 PM »
So I added some lines to my custom css file:
Is there an easier way?
Quote
.nt-select-height>.ui-menu-item:nth-child(odd){
background-color: #EEEEEE;color: #333;
}
.nt-select-height>.ui-menu-item:nth-child(even){
background-color: #FFFFFF;color: #333;
}
Is there an easier way?
143
Web Server - Ask For Help / Select list greybar 12.25?
« on: September 06, 2021, 12:45:00 PM »
I'm converting an app from 11.47 to 12.25.
For a droplist entry field, the old app lists the items with a greybar effect. The rows alternate with a SelectList1 and SelectList2 class.
12.25 just has a uniform light blue background in the list. Those classes no longer exist in Base/nettalk-ui-css.
Is there an easy way to restore the greybar to this droplist?
Thanks.
Jane
For a droplist entry field, the old app lists the items with a greybar effect. The rows alternate with a SelectList1 and SelectList2 class.
12.25 just has a uniform light blue background in the list. Those classes no longer exist in Base/nettalk-ui-css.
Is there an easy way to restore the greybar to this droplist?
Thanks.
Jane
144
Web Server - Ask For Help / Re: Session timeout??
« on: September 05, 2021, 12:17:32 PM »
Never mind.
Jane getting burned by session values surviving restart because they're hiding in the *.state.xml file. And the session EXPIRYAFTERHS overrides the site setting even if it hasn't been explicitly set.
(Note to self to delete that XML file before tweaking the appearance of the session manager notification window.)
Never mind....
Jane getting burned by session values surviving restart because they're hiding in the *.state.xml file. And the session EXPIRYAFTERHS overrides the site setting even if it hasn't been explicitly set.
(Note to self to delete that XML file before tweaking the appearance of the session manager notification window.)
Never mind....
145
Web Server - Ask For Help / Session timeout??
« on: September 03, 2021, 01:32:46 PM »
I'm missing a piece here.
The SessionManager in PageFooterTag uses the new (as of 12.13) p_web.GetSessionTimeout method.
On a server I'm working on I set the timeout on the server window to 3 minutes.
The "old" p_web.site.SessionExpiryAfterHS/100 correctly gets set to 180.
But the p_web.GetSessionTimeOut()/100 that the SessionManager uses stubbornly says 900 (stuck at 15 minutes).
Do I need to call p_webSetSessionTimeOut when a user logs in and pass in the "site" value?
Or what is the best way to make these things line up?
Thanks for any insight.
Jane
The SessionManager in PageFooterTag uses the new (as of 12.13) p_web.GetSessionTimeout method.
On a server I'm working on I set the timeout on the server window to 3 minutes.
The "old" p_web.site.SessionExpiryAfterHS/100 correctly gets set to 180.
But the p_web.GetSessionTimeOut()/100 that the SessionManager uses stubbornly says 900 (stuck at 15 minutes).
Do I need to call p_webSetSessionTimeOut when a user logs in and pass in the "site" value?
Or what is the best way to make these things line up?
Thanks for any insight.
Jane
146
Web Server - Ask For Help / p_web.Authenticate(String pBearerToken) bug still there in NT Christmas (12.25)
« on: September 01, 2021, 06:34:27 PM »
Hi, Bruce,
I showed this at a webinar a couple of months back but probably should have emailed you as well.
Steps to reproduce:
1. Put some embed code AFTER the parent call in the BearerToken version of p_web.Authenticate in the WebHandler.
2. Save the procedure.
3. Open the procedure. The code has magically moved to BEFORE the parent call.
Cheers,
Jane
I showed this at a webinar a couple of months back but probably should have emailed you as well.
Steps to reproduce:
1. Put some embed code AFTER the parent call in the BearerToken version of p_web.Authenticate in the WebHandler.
2. Save the procedure.
3. Open the procedure. The code has magically moved to BEFORE the parent call.
Cheers,
Jane
147
Web Server - Ask For Help / Re: Avoiding doing time consuming work in the WebServer procedure
« on: August 10, 2021, 01:21:19 PM »
Gordon,
Maybe when User B opens a form on MRN 100 he gets a message "Record 100 is locked for update by User A since 9:14AM. Click here to clear the lock and any edits he may be making."
If User B clicks the button you remove User A's lock and make a new lock for User B.
You also check the lock before saving, so if 5 minutes later User A tries to save what's on his open form he gets a "Sorry, Skippy" message.
People may not be happy (are they ever??) but at least they know what happened.
JAT.
Jane
Maybe when User B opens a form on MRN 100 he gets a message "Record 100 is locked for update by User A since 9:14AM. Click here to clear the lock and any edits he may be making."
If User B clicks the button you remove User A's lock and make a new lock for User B.
You also check the lock before saving, so if 5 minutes later User A tries to save what's on his open form he gets a "Sorry, Skippy" message.
People may not be happy (are they ever??) but at least they know what happened.
JAT.
Jane
148
Web Server - Ask For Help / Re: NT12 and .trace problem
« on: July 30, 2021, 07:30:58 PM »
From the Clarion help:
The ERROR procedure returns a string containing a description of any error that was posted. If no error was posted, ERROR returns an empty string. You should interrogate ERROR immediately after the statement which you suspect may post an error because processing any other statement which could post an error will clear the internal errorcode.
The ERROR procedure returns a string containing a description of any error that was posted. If no error was posted, ERROR returns an empty string. You should interrogate ERROR immediately after the statement which you suspect may post an error because processing any other statement which could post an error will clear the internal errorcode.
149
Web Server - Ask For Help / Re: API Client (NT 12.19) not communicating
« on: July 22, 2021, 05:27:54 PM »
Ah. I thought the https://ausmkd.dcisionrt.com/ link was to the API. I can connect to it now.
Sure it's possible to PING (which uses ICMP ) successfully and not be able to connect. (If you click the Ban button on your webserver, for example, that just tells the NT webserver not to respond; Windows will still happily reply to the PING unless the firewall blocks it.)
(As I also work with medical software I'm aware of how often whitelisting is used. One of our 340B third party administrators just emailed us today that they're switching to a new admin system and we'll need to whitelist any IPs that need to be able to access it.) Just a thought...
Maybe upload the netdemo.exe example program to your server and use the webClient procedure to try to connect to the API. The logs may give you some insight as to what's happening.
Jane
Sure it's possible to PING (which uses ICMP ) successfully and not be able to connect. (If you click the Ban button on your webserver, for example, that just tells the NT webserver not to respond; Windows will still happily reply to the PING unless the firewall blocks it.)
(As I also work with medical software I'm aware of how often whitelisting is used. One of our 340B third party administrators just emailed us today that they're switching to a new admin system and we'll need to whitelist any IPs that need to be able to access it.) Just a thought...
Maybe upload the netdemo.exe example program to your server and use the webClient procedure to try to connect to the API. The logs may give you some insight as to what's happening.
Jane
150
Web Server - Ask For Help / Re: API Client (NT 12.19) not communicating
« on: July 22, 2021, 03:35:49 PM »
FWIW, I can't even get a header response from https://ausmkd.dcisionrt.com/
Maybe the client's IP needs to be whitelisted?
Maybe the client's IP needs to be whitelisted?