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] 2
1
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!
2
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?
3
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?
4
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]
5
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
6
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.
7
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]
8
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]
9
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?
10
Web Server - Ask For Help / Error in PageFooterTag p_web.Script
« on: September 23, 2013, 11:23:48 AM »
While Bruce is at CIDC - anyone know why and how to get rid of the error after I updated from NT 7.19 to 7.25 "Cannot call procedure as Function" on the p_web.Script(......) line in the following Capesoft embed code in PageFooterTag:
if (p_web.GetSessionLoggedIn() and p_web.PageName <> p_web.site.LoginPage)
! parameter 1 is the session time
! parameter 2 is the name of the login page.
! parameter 3 is the id of the <div> in the html.
packet = clip(packet) & p_web.Script('startCountDown('& int(p_web.site.SessionExpiryAfterHS/100) &',"'& clip(p_web.site.LoginPage) &'","countdown");')
do SendPacket
end
if (p_web.GetSessionLoggedIn() and p_web.PageName <> p_web.site.LoginPage)
! parameter 1 is the session time
! parameter 2 is the name of the login page.
! parameter 3 is the id of the <div> in the html.
packet = clip(packet) & p_web.Script('startCountDown('& int(p_web.site.SessionExpiryAfterHS/100) &',"'& clip(p_web.site.LoginPage) &'","countdown");')
do SendPacket
end
11
Web Server - Ask For Help / Determine tab user is on
« on: May 09, 2013, 08:19:16 PM »
I have a NetWebForm with 4 tabs (actually it is the SecwinWebLoginForm with the tabs: Login, Forgot Password, Create a Login and Set Password). I want to determine on which tab the user was on when they clicked a button on that tab. Where/how do I determine the tab?
12
Web Server - Ask For Help / Text overlaps border when using p_web.Message
« on: May 06, 2013, 08:45:21 AM »
I'm using all Capesoft procedures taken directly from the SecwinRequiresC6_51 example for login purposes in a NTWS app. The procedure SecwinWebLoginForm calls SecwinWebCreateUser. In SecwinWebCreateUser the you set the pFeedback string to 'Your login details have been emailed to your email address.<13,10>Click on the link in the email to activate your account and set your password.' .
When retruning to SecwinWebLoginform you use the returned string in p_web.Message('alert',loc:feedback1,,Net:Send).
I've attached a screen image showing that the string overlaps the border of the p_web.Message block. I tried removing the <13,10> but this did not change anything.
Is there a limitation to the string length? Is there some setting that can be made to increase the depth of the message block so the use of <13,10> will not cause an overlap?
[attachment deleted by admin]
When retruning to SecwinWebLoginform you use the returned string in p_web.Message('alert',loc:feedback1,,Net:Send).
I've attached a screen image showing that the string overlaps the border of the p_web.Message block. I tried removing the <13,10> but this did not change anything.
Is there a limitation to the string length? Is there some setting that can be made to increase the depth of the message block so the use of <13,10> will not cause an overlap?
[attachment deleted by admin]
13
Web Server - Ask For Help / Comment on NetWebForm field duplicated
« on: April 30, 2013, 09:48:36 AM »
I'm using the SecwinWebLoginForm (NetWebForm) for login. I added a "comment" to the field loc:email (equate email) on the Forgotten your Password tab and a comment on the field loc:email (equate email2) on the Create a Login tab.
When either of these tabs is displayed the "comment" is duplicated, apprearing once next to the loc:email field (as it should) and once right below it.
Am I missing something that must be done to prevent the duplicate display?
When either of these tabs is displayed the "comment" is duplicated, apprearing once next to the loc:email field (as it should) and once right below it.
Am I missing something that must be done to prevent the duplicate display?
14
Web Server - Ask For Help / Suppresss browse not working
« on: April 11, 2013, 07:48:41 PM »
I have a NetWebPage that has <!-- Net:Browse_Registrations --> in the XHTML. When the NetWebPage displays I get the Browse_Registrations browse displayed as expected.
I now want to suppress the browse when it is empty OR when a condition is not met. I've checked off "Suppress browse if empty" on the general tab of the the NetWebBrowse procedure and have added (for testing) a 1=1 in the IF condition located under the Suppress browse if empty checkbox. I also added a PageName.
However the browse displays all the time. Is there something else I must do to suppress the browse on the NetWebPage?
I now want to suppress the browse when it is empty OR when a condition is not met. I've checked off "Suppress browse if empty" on the general tab of the the NetWebBrowse procedure and have added (for testing) a 1=1 in the IF condition located under the Suppress browse if empty checkbox. I also added a PageName.
However the browse displays all the time. Is there something else I must do to suppress the browse on the NetWebPage?
15
Web Server - Ask For Help / Compile error when adding Secwin to NTWS application
« on: March 25, 2013, 01:05:58 PM »
I added Secwin 6.20 to a NTWS application following the steps in the "JumpStart: Adding Runtime Access control to a NetTalk Webserver application" found in the secwin_bruce.htm document. When I compile I get two errors in the SecwinWebUserGroupForm procedure:
1: Expected: <operand> ( + - < > CHOOSE
2. No matching prototype available
The attached text file notes the errors in the Value::Secwin_UGLevel Routine in the procedure SecwinWebUserGroupForm. The error lines are noted with <<<<<<<<< ERROR.
Did I miss a step in the JumpStart or is there something else wrong? I've tried to find where the missing information is set but have not been successful.
[attachment deleted by admin]
1: Expected: <operand> ( + - < > CHOOSE
2. No matching prototype available
The attached text file notes the errors in the Value::Secwin_UGLevel Routine in the procedure SecwinWebUserGroupForm. The error lines are noted with <<<<<<<<< ERROR.
Did I miss a step in the JumpStart or is there something else wrong? I've tried to find where the missing information is set but have not been successful.
[attachment deleted by admin]
Pages: [1] 2