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.
16
Web Server - Ask For Help / Re: Calling Source procedure from Menu
« on: October 06, 2023, 04:49:31 PM »
Well, your menu and javascript are in the browser. Your ClearFile procedure is in the server. Your menu item is trying to make an AJAX call to the server. The server is confused.
Attached may give you some ideas. Not saying it's the best way, but it's an approach.
changed the action on your menu item.
added 5 lines of code to the PageHeaderTag procedure
added your ClearFile procedure to the Calls list for PageHeaderTag
and I changed ClearFile to use regular Open and Close statements, rather than file manager. Emptying a file requires exclusive access. In a real-world multi-user environment you'd need to do something more robust to make sure that any other people who had that file open were dealt with.
HTH,
Jane
Attached may give you some ideas. Not saying it's the best way, but it's an approach.
changed the action on your menu item.
added 5 lines of code to the PageHeaderTag procedure
added your ClearFile procedure to the Calls list for PageHeaderTag
and I changed ClearFile to use regular Open and Close statements, rather than file manager. Emptying a file requires exclusive access. In a real-world multi-user environment you'd need to do something more robust to make sure that any other people who had that file open were dealt with.
HTH,
Jane
17
Web Server - Ask For Help / Re: Generate GUID in SQL - Part 2
« on: September 27, 2023, 10:49:05 AM »
I think that at least part of the reason Bruce recommends against using SQL Uniqueidentifier GUIDs is so one is not tied to a specific backend.
And another is that if you need to generate a unique identifier in a disconnected mobile app, it's much easier to generate a 16-character random string using javascript than to generate a SQL GUID with javascript.
Also, it's advantageous to have the client generate the row's unique identifier. That way, for example, you can create invoice items before you've saved an invoice header (because you have the invoice GUID as a variable). So you generate the GUID *before* saving any rows, rather than having SQL create a NEWID on insert which you then need to try to get.
If you don't care about simplicity of creating the GUID with javascript and want to use the MS SQL uniqueidentifier you could use prop:sql to have SQL make one for you, or use String Theory, or use one of the various Windows API methods. Some recent discussion on Clarion Hub: https://clarionhub.com/t/function-to-create-a-guid/6580/5
And another is that if you need to generate a unique identifier in a disconnected mobile app, it's much easier to generate a 16-character random string using javascript than to generate a SQL GUID with javascript.
Also, it's advantageous to have the client generate the row's unique identifier. That way, for example, you can create invoice items before you've saved an invoice header (because you have the invoice GUID as a variable). So you generate the GUID *before* saving any rows, rather than having SQL create a NEWID on insert which you then need to try to get.
If you don't care about simplicity of creating the GUID with javascript and want to use the MS SQL uniqueidentifier you could use prop:sql to have SQL make one for you, or use String Theory, or use one of the various Windows API methods. Some recent discussion on Clarion Hub: https://clarionhub.com/t/function-to-create-a-guid/6580/5
18
Web Server - Ask For Help / Re: Access Violation after upgrading to NT14.04 from NT 12..
« on: September 16, 2023, 03:22:27 PM »
Jeff,
I've only experimented briefly with multi-site host, so just speculation here.
Have you made sure to compile all the NetTalk sites with the same version of NetTalk that you're using for the host?
Will the host run by itself?
Will the host run with just a static site (such as with the multi-site example app)?
Is yours like Richard's situation - his runs in debug mode but crashes in deployment mode? If so, another thing to try would be one-by-one enabling the different items that get set by switching to "deployment" and seeing if you can isolate the crash down to one switch.
I've only experimented briefly with multi-site host, so just speculation here.
Have you made sure to compile all the NetTalk sites with the same version of NetTalk that you're using for the host?
Will the host run by itself?
Will the host run with just a static site (such as with the multi-site example app)?
Is yours like Richard's situation - his runs in debug mode but crashes in deployment mode? If so, another thing to try would be one-by-one enabling the different items that get set by switching to "deployment" and seeing if you can isolate the crash down to one switch.
19
Web Server - Ask For Help / Re: Access Violation after upgrading to NT14.04 from NT 12..
« on: September 16, 2023, 09:56:14 AM »20
Web Server - Ask For Help / Re: Mobile App that is NOT Disconnected
« on: September 11, 2023, 12:53:39 PM »
Hi, Ron,
If it only runs when connected, one option would be a plain web-app with CSS focused on usability on a mobile screen. Use big buttons, only needed functionality, etc. By definition, that would only work when connected.
As for a PWA, you might find it valuable to spend an hour or two working through some of the MDN tutorials.
This is Creating your first PWA
And this page is the basic everything-you-ever-wanted-to-know page: https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps
Cheers,
Jane
*edited to fix link
If it only runs when connected, one option would be a plain web-app with CSS focused on usability on a mobile screen. Use big buttons, only needed functionality, etc. By definition, that would only work when connected.
As for a PWA, you might find it valuable to spend an hour or two working through some of the MDN tutorials.
This is Creating your first PWA
And this page is the basic everything-you-ever-wanted-to-know page: https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps
Cheers,
Jane
*edited to fix link
21
Web Server - Ask For Help / Re: Possible NT14 settings bug (ACME challenge type setting)
« on: September 10, 2023, 12:32:19 PM »
Thanks! 
22
Web Server - Ask For Help / IP V6 bit me
« on: September 08, 2023, 03:23:42 PM »
This is, admittedly, an edge case that most people will probably not encounter. But worth awareness...
Aside - Bruce, the NetWebClient in NetDemo has an IPV6 checkbox but it doesn't do anything. For my testing I replaced it with radio buttons for Net:IPvAuto, Net:IPv4, Net:IPv6
I would suggest you modify the NetDemo app that way... it's useful for testing.
/Aside
I have various apps running on a Windows 2019 server in an Active Directory domain that is set up with only IPv4 DNS.
The two apps involved in this problem are both ones I'm in the process of converting from NT12 to NT14. One is an API server, the other has an API client.
After rebuilding, I set the server to serve IPv4.
I did not change the client.
Its default behavior (Net:IPvAuto) did not work for me.
I guess that whatever is happening takes place inside the NetTalk DLL, so I'm not sure how you're doing the auto.
Your docs say: "By default, and if Family is set to Net:IPvAuto or Net:IPv4 then an IPv4 DNS Lookup will happen on this name first".
But what shot me in the foot (I did not shoot MYSELF in the foot!!) is apparently how Windows handles a lookup when it "knows" that the server in question is itself.
As you can see from the first pic, doing an NSLOOKUP (which uses the DNS server) resolves to an IPv4 address (which is all that our DNS handles).
But doing a PING of the same FULLY-QUALIFIED DNS ADDRESS returns a loopback IPv6 address.
I don't know if that is the cause... but the net client compiled without specifying IP family refuses to connect to my API server. If you were actually doing a DNS lookup I would have thought that "auto" would have figured out to use IPv4. If you're doing a PING internally, it would have found the IPv6.
If I force the client to use IPv4, all is well in the world. So at least in my edge case, "auto" is not bullet-proof.
More grey hairs... sigh...
Cheers,
Jane
Aside - Bruce, the NetWebClient in NetDemo has an IPV6 checkbox but it doesn't do anything. For my testing I replaced it with radio buttons for Net:IPvAuto, Net:IPv4, Net:IPv6
I would suggest you modify the NetDemo app that way... it's useful for testing.
/Aside
I have various apps running on a Windows 2019 server in an Active Directory domain that is set up with only IPv4 DNS.
The two apps involved in this problem are both ones I'm in the process of converting from NT12 to NT14. One is an API server, the other has an API client.
After rebuilding, I set the server to serve IPv4.
I did not change the client.
Its default behavior (Net:IPvAuto) did not work for me.
I guess that whatever is happening takes place inside the NetTalk DLL, so I'm not sure how you're doing the auto.
Your docs say: "By default, and if Family is set to Net:IPvAuto or Net:IPv4 then an IPv4 DNS Lookup will happen on this name first".
But what shot me in the foot (I did not shoot MYSELF in the foot!!) is apparently how Windows handles a lookup when it "knows" that the server in question is itself.
As you can see from the first pic, doing an NSLOOKUP (which uses the DNS server) resolves to an IPv4 address (which is all that our DNS handles).
But doing a PING of the same FULLY-QUALIFIED DNS ADDRESS returns a loopback IPv6 address.
I don't know if that is the cause... but the net client compiled without specifying IP family refuses to connect to my API server. If you were actually doing a DNS lookup I would have thought that "auto" would have figured out to use IPv4. If you're doing a PING internally, it would have found the IPv6.
If I force the client to use IPv4, all is well in the world. So at least in my edge case, "auto" is not bullet-proof.
More grey hairs... sigh...
Cheers,
Jane
23
Web Server - Ask For Help / Re: Possible NT14 settings bug (ACME challenge type setting)
« on: September 08, 2023, 02:59:32 PM »
Changing the declaration to a LONG on line 825 of netweba.tpw seems to give the behavior I was expecting.
24
Web Server - Ask For Help / Possible NT14 settings bug (ACME challenge type setting)
« on: September 06, 2023, 02:41:00 PM »
Bruce,
Converting my first app to NT14 from 12.63. Thanks for the walk-through on ClarionLive.
I set Challenge Method to Manual (hoping that's a handy new setting for not using Let's Encrypt for a website that has a manual cert.)
The radio button sets the value to -1
set:AcmeChallenge is a byte.
The serverSettings XML translates that -1 to 255.
Is this the intended behavior? Should set:AcmeChallenge be a LONG? (Since net:manual is declared as equate(-1) in NetAcme.inc I don't think it should be a BYTE).
Cheers,
Jane
Converting my first app to NT14 from 12.63. Thanks for the walk-through on ClarionLive.
I set Challenge Method to Manual (hoping that's a handy new setting for not using Let's Encrypt for a website that has a manual cert.)
The radio button sets the value to -1
set:AcmeChallenge is a byte.
The serverSettings XML translates that -1 to 255.
Is this the intended behavior? Should set:AcmeChallenge be a LONG? (Since net:manual is declared as equate(-1) in NetAcme.inc I don't think it should be a BYTE).
Cheers,
Jane
25
Web Server - Ask For Help / Re: RUnning 2 web apps on 2 different ports - Warning <Display Name> could not load
« on: September 06, 2023, 02:31:16 PM »
Are you using Self Service?
26
Web Server - Ask For Help / Re: JavaScripts problem
« on: September 06, 2023, 08:02:33 AM »
Probably The Old "web folder isn't where I think it is" Trick.
If you copied the myappname.ServerSettings.xml file from your development machine you've hard-copied folder settings from that machine.
Either delete that XML file and let NetTalk recreate it or else edit the path in the settings on your web server window while it's running.
If you copied the myappname.ServerSettings.xml file from your development machine you've hard-copied folder settings from that machine.
Either delete that XML file and let NetTalk recreate it or else edit the path in the settings on your web server window while it's running.
27
Web Server - Ask For Help / Re: NT 14 Floating Labels
« on: August 24, 2023, 09:17:24 AM »
To be more specific, line 3166 in netweba.tpw whence that line is written into gzipall.bat
28
Web Server - Ask For Help / Re: NT 14 Floating Labels
« on: August 24, 2023, 08:50:04 AM »
There's a typo in gzipall.bat
It reads (in multiple places - once for each theme):
should be:
It reads (in multiple places - once for each theme):
Code: [Select]
IF EXIST web\styles\nt-labels.css type web\styles\netweb.css >> web\themes\base\theme.fat.cssshould be:
Code: [Select]
IF EXIST web\styles\nt-labels.css type web\styles\nt-labels.css >> web\themes\base\theme.fat.css29
Web Server - Ask For Help / Re: WebServer Single Sign On (SSO)
« on: August 23, 2023, 01:35:51 PM »
Single sign-on with Azure AD is what we aim for .
Even then, what does that mean?
1. The user logs in to your app using username/password that's stored in Azure AD and app authenticates those credentials against AD?
2. The app somehow magically knows the user's credentials and logs him in without any additional login steps (like a saved OAUTH token) ?
3. The app sends an NTLM challenge to the browser to authenticate the user (the way Sharepoint and SSRS can do internally)?
4. Integrated Windows authentication (which is probably the same as #3)?
Another Azure-specific link for #4: https://learn.microsoft.com/en-us/aspnet/visual-studio/overview/2012/windows-azure-authentication
30
Web Server - Ask For Help / Re: NT 14.01 compile error
« on: August 17, 2023, 05:56:17 PM »
Reflection 1.24 - from the history:
"Add: Field type: rf:interface"
"Add: Field type: rf:interface"