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: MultipleActiveResultSets revisited
« on: September 01, 2015, 07:13:16 PM »
Thanks Kevin for the additional info. I understand locking and don't think I'm experiencing locking but I'm a little unclear how to check for this - will have to do my searching of how to determine the SQL DB is locking.
But in the meantime let me state what I think you said and what I've gleamed from my searching on SetSQLTime.
NT wraps any file IO it handles with p_web.SetSQLTimeout(tablename,net:on) and p_web.SetSQLTimeout(tablename,net:off ) for you BUT if you are doing IO in source code you would need to do this yourself. So if NT is doing this for all IO it handles, wrapping my source code IO would be the same as if NT were handling it. The reason I need to be clear is I don't want to degrade what appears to be working fine right now with the MultipleActivieResultSets and BusyHandling driver options - it's be two days since implementing these options and the log shows NO occurances of the "hstmt" error and I was getting at least a couple a day prior to this.
So I guess for now I'll hold off on this until I check into the locking situation or until I see some other problem happening with IO.
Thanks again.
But in the meantime let me state what I think you said and what I've gleamed from my searching on SetSQLTime.
NT wraps any file IO it handles with p_web.SetSQLTimeout(tablename,net:on) and p_web.SetSQLTimeout(tablename,net:off ) for you BUT if you are doing IO in source code you would need to do this yourself. So if NT is doing this for all IO it handles, wrapping my source code IO would be the same as if NT were handling it. The reason I need to be clear is I don't want to degrade what appears to be working fine right now with the MultipleActivieResultSets and BusyHandling driver options - it's be two days since implementing these options and the log shows NO occurances of the "hstmt" error and I was getting at least a couple a day prior to this.
So I guess for now I'll hold off on this until I check into the locking situation or until I see some other problem happening with IO.
Thanks again.
2
Web Server - Ask For Help / MultipleActiveResultSets revisited
« on: August 31, 2015, 07:54:27 PM »
I have a C9.1 ABC NT 8.59 web server app that is used to enter "job requests" by teachers and staff to the maintenance dept. When they go to the webserver they are immediately taken to a NetWebform with multiple tabs but only the "tab of interest" such as General Maintenance, HVAC, Plumbing, Electrical, etc. will be shown based upon a parameter I pass in the URL link. The fields on the tabs are memory fields. When they click Save I do some work on some of the memory fields and then populate the appropriate fields in the SQL table "Jobs" and do an Access:JOBS.Insert().
I use MessageBox to log silent messages and would sometimes see the error: "Connection is busy with results for another hstmt........" when inserting into the Jobs table. Although the data was saved to the Jobs table.
Searching NetTalk Central and with help from the NetTalk Thursday webinar I understood I needed to add
MultipleActiveResultSets=TRUE and BusyHandling=2 to the driver string of the first SQL file that is opened.
Since I use FM3 and its file would be the first opened, I added those driver options on the FM3 global extension. I also had the Jobs table being opened in the WebServer procedure (not sure why I had it there) but removed this opening and also removed the Jobs table from the Data/Tables schematic in the NetWebForm and manually do a p_web.Open(Jobs) before the Insert and a p_web.Close(Jobs) after the insert.
These changes went into service at the clients site over the weekend. Checking the log on Monday was encouraging because I did not see any of the "Connection is busy......" error messages. So far so good on this.
All was well until I got the report that one individual got an error when trying to save their form - but this error was not one previously reported. They reported that:
"When I hit the save button the response was a white page, 'no data received' ".
I checked the Message log and there was not corresponding "Connection is busy......." error for their entry attempt, in fact there were no error messages of any sort in the log. But once again the data did go into the SQL Jobs table correctly.
So here's my questions:
1. First, I had the BusyHandling=2 set in the dictionary as a driver option on all my SQL tables (thanks to JP's help way back when on another project). Should this be removed from the dictionary since I added it to FM3 and understand you only need to do these driver options on the first file opened?
2. Is the "no data received" being generated by the NT webserver and if so under what conditions is this error generated?
3. Is this new error possibly related to the MultipleActiveResultSets or does it indicate some other problem occurred?
4. Any ideas how to eliminate this error?
The "Connection is busy........." error and the error today are random - this was one reported error out of about 20 requests made on Monday so it cannot be reproduced. Any ideas of traps or other debugging I can add to the app to narrow down the cause would be appreciated along with any other ideas anyone has.
Thanks!
I use MessageBox to log silent messages and would sometimes see the error: "Connection is busy with results for another hstmt........" when inserting into the Jobs table. Although the data was saved to the Jobs table.
Searching NetTalk Central and with help from the NetTalk Thursday webinar I understood I needed to add
MultipleActiveResultSets=TRUE and BusyHandling=2 to the driver string of the first SQL file that is opened.
Since I use FM3 and its file would be the first opened, I added those driver options on the FM3 global extension. I also had the Jobs table being opened in the WebServer procedure (not sure why I had it there) but removed this opening and also removed the Jobs table from the Data/Tables schematic in the NetWebForm and manually do a p_web.Open(Jobs) before the Insert and a p_web.Close(Jobs) after the insert.
These changes went into service at the clients site over the weekend. Checking the log on Monday was encouraging because I did not see any of the "Connection is busy......" error messages. So far so good on this.
All was well until I got the report that one individual got an error when trying to save their form - but this error was not one previously reported. They reported that:
"When I hit the save button the response was a white page, 'no data received' ".
I checked the Message log and there was not corresponding "Connection is busy......." error for their entry attempt, in fact there were no error messages of any sort in the log. But once again the data did go into the SQL Jobs table correctly.
So here's my questions:
1. First, I had the BusyHandling=2 set in the dictionary as a driver option on all my SQL tables (thanks to JP's help way back when on another project). Should this be removed from the dictionary since I added it to FM3 and understand you only need to do these driver options on the first file opened?
2. Is the "no data received" being generated by the NT webserver and if so under what conditions is this error generated?
3. Is this new error possibly related to the MultipleActiveResultSets or does it indicate some other problem occurred?
4. Any ideas how to eliminate this error?
The "Connection is busy........." error and the error today are random - this was one reported error out of about 20 requests made on Monday so it cannot be reproduced. Any ideas of traps or other debugging I can add to the app to narrow down the cause would be appreciated along with any other ideas anyone has.
Thanks!
3
Web Server - Ask For Help / Re: Detecting cancel button press and Invalid fields berfore exiting a NetWebForm
« on: August 19, 2015, 08:20:58 AM »
Kevin/Bruce,
Thanks! That's just the embed point I needed - if the user clicks cancel nothing happens in my post processing and if a field is invalid, nothing happens until they enter valid data into the field.
Thanks! That's just the embed point I needed - if the user clicks cancel nothing happens in my post processing and if a field is invalid, nothing happens until they enter valid data into the field.
4
Web Server - Ask For Help / Detecting cancel button press and Invalid fields berfore exiting a NetWebForm
« on: August 18, 2015, 03:48:54 PM »
I have a NetWebForm and when the user clicks SAVE I want to do some "Post Processing" of the data on the form and put some of the manipulated data into another table. I added this post processing code into the CompleteForm routine and it seems to work EXCEPT I need to know the following:
1. Did the user press the Cancel button and not the save button so I don't post process
2. I have some fields that are Required Fields and it seems that the CompleteForm routine is called before any of the ValidateField routines so I can not check loc:alert or loc:Invalid to not post process if there are required fields that still need data.
I added debug code to CancelForm but it was never called even when I pressed the cancel button.
Where do I embed or what can I check to accomplish #1 and #2 above or is there another way to go about this completely?
1. Did the user press the Cancel button and not the save button so I don't post process
2. I have some fields that are Required Fields and it seems that the CompleteForm routine is called before any of the ValidateField routines so I can not check loc:alert or loc:Invalid to not post process if there are required fields that still need data.
I added debug code to CancelForm but it was never called even when I pressed the cancel button.
Where do I embed or what can I check to accomplish #1 and #2 above or is there another way to go about this completely?
5
Web Server - Ask For Help / UDP not passing to subnet- use TCP instead?
« on: May 18, 2015, 09:36:03 AM »
I implemented a feature where a NTWS will "broadcast" a text string to other PCs when the NTWS is asked to perform certain function. I used the NetAuto and the Chat examples to implement this. It works fine with PCs on the same subnet of the LAN. However PCs on subnets of the LAN are not receiving the message sent by the NTWS. I understand NetAuto will not work for WANs and the subnet is seen as a WAN apparently because of routing issues.
So I'm looking at changing over to a NetSimple method using Client and Server. Whereas, UDP is a one-to-many but won't traverse the subnets, I need to use the routeable TCP but TCP is one-to-one. Would it be correct to have the NetSimple Client (my NTWS) have a list of IPs (maybe implementing a DIP server) and loop through these IPs making one connection after another with each NetSimple Server in order to send the string to the various computers on both the LAN and the subnets of the LAN?
So I'm looking at changing over to a NetSimple method using Client and Server. Whereas, UDP is a one-to-many but won't traverse the subnets, I need to use the routeable TCP but TCP is one-to-one. Would it be correct to have the NetSimple Client (my NTWS) have a list of IPs (maybe implementing a DIP server) and loop through these IPs making one connection after another with each NetSimple Server in order to send the string to the various computers on both the LAN and the subnets of the LAN?
6
Web Server - Ask For Help / Using NetAuto Chat example to send notifications
« on: May 07, 2015, 07:37:53 PM »
I'm using the NetAuto "Chat" example to send notifications (sys tray popups on the receiving computers using WinEvent) from a NTWS NetWebForms procedure. Pretty much "cloned" the Chat example but I needed the process to be totally automatic as opposed to pressing the Send button as in the Chat example. The only way I could get it to automatically send the notification (packet) was to put a Timer on the window which is hidden by the way, and in the Time event do the following:
fosNotify.Send() fosNotify is the object name of course
POST(Event:closewindow)
This all works but am I going about this in the right way using the timer or is there a better way? Attached is the procedure that I created (with much help from the Chat example!!!)
[attachment deleted by admin]
fosNotify.Send() fosNotify is the object name of course
POST(Event:closewindow)
This all works but am I going about this in the right way using the timer or is there a better way? Attached is the procedure that I created (with much help from the Chat example!!!)
[attachment deleted by admin]
7
Web Server - Ask For Help / Simple LAN notification system
« on: May 05, 2015, 03:45:01 PM »
I have a NTWS running on the LAN handling the entry of "job requests". These are put into an SQL DB by the WS. I want to have a small tray process running on several users PCs so that when a certain type of job request is received by the NTWS a notification will popup in the tray(s) of certain users PCs. I know you can use WinEvent to create and handle tray processes and can set it to start when the PC boots but what NetTalk functional should I use to "send" the notification from the NTWS to multiple PCs? It's sort of like the NT Chat example but I know that's probably not the way to go. Are there any NT examples that I should be looking at? Thanks
8
Web Server - Share Knowledge / Using DNS connection and Redirect
« on: February 20, 2015, 12:57:35 PM »
Be careful when connecting to a Webserver using DNS as in http://myserver:88. I ran into problems with a Redirect('http://go.someplace.com/page) not working. Changing the connection to use an IP address as in http://123.45.67.123:88 allowed the Redirect to work correctly. There also was an issue with the SessionID not getting returned when connecting use IE.
9
Web Server - Ask For Help / Re: Getting different SessionIDs
« on: February 20, 2015, 12:51:03 PM »
Upon doing further testing and diagnostics I discovered that when I connected to the Webserver with a DNS entry (http://myserver::88) with IE I would not get back the SessionID. Changing to using the IP address (http://123.123.123.123:88) allowed the session value to be returned and all was well.
10
Web Server - Ask For Help / Getting different SessionIDs
« on: February 11, 2015, 11:25:00 AM »
A small simple Webserver works fine when running locally and accessing it with IE. I put the Webserver onto a Windows 2003 Std server on the internal network. When I access this Webserver initially I get a specific SessionID and set some Session values and my form is displayed. If I then enter a value on the form my debugging info shows that my SessionID is NOT the same and then of course if I do a GSV('something') I get nothing because I'm in an entirely different session. I did not of course close and reopen the browser so would expect the SessionID to remain the same and when run locally the SessionID doesn't change. Am I missing something?
NT 8.34, C9.1 ABC
Addition New information:
I tried the same test with FireFox and Chrome and everything works correctly so the "problem" seems to be limited to Internet Explorer, specifically I'm running IE 11.
[attachment deleted by admin]
NT 8.34, C9.1 ABC
Addition New information:
I tried the same test with FireFox and Chrome and everything works correctly so the "problem" seems to be limited to Internet Explorer, specifically I'm running IE 11.
[attachment deleted by admin]
11
Web Server - Ask For Help / Re: WebForm without browse not saving
« on: January 26, 2015, 10:19:18 AM »
Thanks Bruce, works like I need it to work. You learn something new everyday about how NT works and how it can be used!
12
Web Server - Ask For Help / WebForm without browse not saving
« on: January 25, 2015, 07:01:36 PM »
I created a NetWebForm using the NT wizard. I've set this NetWebform as the Default Page in the WebServer so it opens immediately when logging onto the site. On the NetWebForm on the Advanced tab I set the Default Form Action as INSERT and also set the Security tab to Allow Inserts. For this NetWebForm I set the URL on Save and the URL on Cancel to an external web page on the internet. The Form Source is a TPS file for now but will be changed to an SQL table in the future, but for now I'm using the TPS for testing.
Problem is when I press the SAVE button on the Form nothing is saved to the table. In fact, looking at the NetTalk Web Server monitor screen I do not see anything coming from the form when pressing Save, although I see the other fields coming into the server when I tab from field to field entering data into the fields. The Save button seems to be working because the URL on Save is 'triggering", that is, right after pressing the Save button I'm taken to the internet web site I designated. I also know the TPS file is being created because if I remove it, the NetWebForm will create the file the next time. The table has a GUID primary key that is being displayed on the form for testing and is being primed successfully by StringTheory.MakeGUID().
Can't figure out why this wizarded NetWebForm will not save. Attached is the app and dct I'm using for testing. I even tried adding an Access:Jobs.INSERT() statement into the CompleteForm procedure but debugging code shows that procedure is never being called.
Clarion 9.1.11497 and NetTalk 8.34 and StringTheory 2.14
[attachment deleted by admin]
Problem is when I press the SAVE button on the Form nothing is saved to the table. In fact, looking at the NetTalk Web Server monitor screen I do not see anything coming from the form when pressing Save, although I see the other fields coming into the server when I tab from field to field entering data into the fields. The Save button seems to be working because the URL on Save is 'triggering", that is, right after pressing the Save button I'm taken to the internet web site I designated. I also know the TPS file is being created because if I remove it, the NetWebForm will create the file the next time. The table has a GUID primary key that is being displayed on the form for testing and is being primed successfully by StringTheory.MakeGUID().
Can't figure out why this wizarded NetWebForm will not save. Attached is the app and dct I'm using for testing. I even tried adding an Access:Jobs.INSERT() statement into the CompleteForm procedure but debugging code shows that procedure is never being called.
Clarion 9.1.11497 and NetTalk 8.34 and StringTheory 2.14
[attachment deleted by admin]
13
E-Mail - Ask For Help / Re: Requesting a "Read Receipt" from the email recipient
« on: August 27, 2014, 07:36:48 PM »
Thanks for the input Kevin but there's no webserver involved here. Just using NetTalk NetSimple SendMail to send email from a program, really plain and simple.
14
E-Mail - Ask For Help / Requesting a "Read Receipt" from the email recipient
« on: August 27, 2014, 11:48:35 AM »
I want to request a Read Receipt on emails that are sent. Exploring the NetSimple class I see a property called deliveryReceiptTo. If I populate this with the email address I want the receipt sent to is that all I need to do?
15
Web Server - Ask For Help / Re: Error in PageFooterTag p_web.Script
« on: September 23, 2013, 07:21:33 PM »
Thanks Ura that's what I figured needed to be done given the error. Nice to get confirmation.