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 / Google Maps
« on: August 29, 2013, 08:13:06 AM »
Bruce,
Do you have anything in the pipeline regarding a Google Maps API ?
I am currently using MS MapPoint, which is a Win32 program - which is also very expensive on a per-seat basis. Would like to be able to plot a set of pushpins on a map representing customer addresses for a service technicians daily schedule.
Chuck
Do you have anything in the pipeline regarding a Google Maps API ?
I am currently using MS MapPoint, which is a Win32 program - which is also very expensive on a per-seat basis. Would like to be able to plot a set of pushpins on a map representing customer addresses for a service technicians daily schedule.
Chuck
17
Web Server - Ask For Help / signature problem v7.20
« on: August 22, 2013, 04:23:09 PM »
I am trying to add a signature control to a run-of-the mill memory form. The memory form is called from another memory form via a button control. The called form with the signature control only has 3 display controls, 2 of which show text and the other one is a horizontal line, and the save and cancel buttons.
If I call the form with the signature control as a popup none of the controls on the form are not displayed - not even the save and cancel buttons - only the bare form itself. If I call the form as not-popup all displays fine. So the signature control totally crashes the form when it is a popup, but works fine as not-popup.
So I tried to modify example 75 to show this behavior but I cannot make a form in example 75 popup - even though the MailBox form is supposed to be a popup it will not display as a popup, only a flat normal form.
So there are two problems here - my problem with the signature control and the problem with example 75 not displaying a popup form as a popup.
Chuck
If I call the form with the signature control as a popup none of the controls on the form are not displayed - not even the save and cancel buttons - only the bare form itself. If I call the form as not-popup all displays fine. So the signature control totally crashes the form when it is a popup, but works fine as not-popup.
So I tried to modify example 75 to show this behavior but I cannot make a form in example 75 popup - even though the MailBox form is supposed to be a popup it will not display as a popup, only a flat normal form.
So there are two problems here - my problem with the signature control and the problem with example 75 not displaying a popup form as a popup.
Chuck
18
Web Server - Ask For Help / cannot get field to be re-selected
« on: August 19, 2013, 05:35:33 AM »
I have a memory form with two string entry fields. When the first field has data entered and is tabbed out of I run code in the "Add Server Side Code" embed. The code validates the string and if all is okay it clears the field and is supposed to reselect the same field. This is the code:
TechSale_PartNumber = ''
p_web.SetSessionValue('TechSale_PartNumber','')
p_web.SetValue('SelectField',Clip(loc:formname) & '.TechSale_PartNumber')
The field is clearing just fine but the field is not being reselected - the 2nd field, placed after the first field, is being selected.
What am I doing wrong?
NT 7.18
Chuck
TechSale_PartNumber = ''
p_web.SetSessionValue('TechSale_PartNumber','')
p_web.SetValue('SelectField',Clip(loc:formname) & '.TechSale_PartNumber')
The field is clearing just fine but the field is not being reselected - the 2nd field, placed after the first field, is being selected.
What am I doing wrong?
NT 7.18
Chuck
19
Web Server - Ask For Help / auto-refresh browse keeps session alive?
« on: August 16, 2013, 12:39:36 PM »
I have a browse that is set to auto-refresh every 5 minutes. I am assuming that this will also, as an unintended side-affect, keep the session alive. Is this correct?
Chuck
Chuck
20
Web Server - Ask For Help / how to show row color code at top of browse
« on: August 15, 2013, 11:22:32 AM »
In my Win32 app I have a browse where each row is colored depending on a condition. At the top of the browse I have 9 small panels that show the color code and count of the rows of the browse (see attached picture).
The colors of each panel represent colored rows on the browse and show the count of each color.
What would be the best way to do the same thing with a NetTalk web browse? I already have the web browse rows correctly displaying the appropriate color but I want to add a color code indicator along the top of the browse to show what each colored row represents, and show the total count of each color - as my screen shot shows.
Chuck
[attachment deleted by admin]
The colors of each panel represent colored rows on the browse and show the count of each color.
What would be the best way to do the same thing with a NetTalk web browse? I already have the web browse rows correctly displaying the appropriate color but I want to add a color code indicator along the top of the browse to show what each colored row represents, and show the total count of each color - as my screen shot shows.
Chuck
[attachment deleted by admin]
21
Web Server - Ask For Help / automatic browse refresh
« on: August 13, 2013, 04:51:25 AM »
NT v7.18
I have the need to automatically refresh a browse every so often, say every 5 minutes. This is a browse that shows a schedule that is very fluid and changes often. The user may have this particular browse displayed all day long. I know I can do this with a javascript timer function but is there an easier way to force the browser to automatically reload the browse?
Chuck
I have the need to automatically refresh a browse every so often, say every 5 minutes. This is a browse that shows a schedule that is very fluid and changes often. The user may have this particular browse displayed all day long. I know I can do this with a javascript timer function but is there an easier way to force the browser to automatically reload the browse?
Chuck
22
Web Server - Ask For Help / problems with signature
« on: August 07, 2013, 11:17:49 AM »
NT 7.18
I have a memory form that works fine until I add a signature control - then the form locks up when displayed. It looks like the css has been partially removed, or something similar as the save and cancel buttons loose their jquery look and have no affect - the window is locked.
I can create a similar result by modifying example 75 but it is not consistent - I am not sure what I am doing to cause the problem to appear.
Form is fine without signature, locks up with signature.
Chuck
I have a memory form that works fine until I add a signature control - then the form locks up when displayed. It looks like the css has been partially removed, or something similar as the save and cancel buttons loose their jquery look and have no affect - the window is locked.
I can create a similar result by modifying example 75 but it is not consistent - I am not sure what I am doing to cause the problem to appear.
Form is fine without signature, locks up with signature.
Chuck
23
Web Server - Ask For Help / signature capture questions
« on: August 06, 2013, 04:49:38 AM »
I am planning on adding signature capture to my web app and have some questions.
1. The NetTalk sample app (example 75) stores the signature in a 64k memo field and also creates a .bmp file of the image. In the real world, why create a .bmp at all and not just store as a string - then create the image file when needed?
2. when storing the signature as a string - what is rule of thumb for string size, if any? Is a 64k memo field overkill or necessary?
3. I am concerned about storing image files as a blob in a .tps file - the file size limits of 2g could be reached quickly in some applications.
4. what about storing each image file as a separate file? I do this in other areas but am concerned with the legal integrity of a signature. Does anyone have any guidelines to make a stored signature image file secure and legal? Can the signature be stored separately or does it need to be embedded in the document that it applies to?
Thanks,
Chuck
1. The NetTalk sample app (example 75) stores the signature in a 64k memo field and also creates a .bmp file of the image. In the real world, why create a .bmp at all and not just store as a string - then create the image file when needed?
2. when storing the signature as a string - what is rule of thumb for string size, if any? Is a 64k memo field overkill or necessary?
3. I am concerned about storing image files as a blob in a .tps file - the file size limits of 2g could be reached quickly in some applications.
4. what about storing each image file as a separate file? I do this in other areas but am concerned with the legal integrity of a signature. Does anyone have any guidelines to make a stored signature image file secure and legal? Can the signature be stored separately or does it need to be embedded in the document that it applies to?
Thanks,
Chuck
24
Web Server - Ask For Help / SessionExpiry causing app crash
« on: July 31, 2013, 03:52:13 AM »
NT 7.15
I have finally tracked my web server crashing to the session expiration setting. When a session expires after no activity it causes the exception shown here:
Call Stack:
7/31/2013, 6:34:19 AM, 0:04:12,,3,Runtime error,Index out of range
Error point: 0040196C
Process PID=6556 Image: C:\CT8\Applications\Server\Web Server\cpweb_mn\cpweb_mn.exe
Thread 1 Handle=000000E0 TID=5552
I have added the code shown below to the Web Server procedure to set my own session time out:
! Start of "Override Default Server Settings"
! [Priority 5000]
IF Global:SessionTimeOut = 0
Global:SessionTimeOut = 30
End
ThisWebServer._SitesQueue.Defaults.SessionExpiryAfterHS = Global:SessionTimeOut * 6000 + 1
! End of "Override Default Server Settings"
Put(s_web._SitesQueue)
Global:SessionTimeOut is a long and can be set by the user (in minutes) but as the code shows it cannot be zero.
Is there anything wrong with my code above?
Chuck
I have finally tracked my web server crashing to the session expiration setting. When a session expires after no activity it causes the exception shown here:
Call Stack:
7/31/2013, 6:34:19 AM, 0:04:12,,3,Runtime error,Index out of range
Error point: 0040196C
Process PID=6556 Image: C:\CT8\Applications\Server\Web Server\cpweb_mn\cpweb_mn.exe
Thread 1 Handle=000000E0 TID=5552
I have added the code shown below to the Web Server procedure to set my own session time out:
! Start of "Override Default Server Settings"
! [Priority 5000]
IF Global:SessionTimeOut = 0
Global:SessionTimeOut = 30
End
ThisWebServer._SitesQueue.Defaults.SessionExpiryAfterHS = Global:SessionTimeOut * 6000 + 1
! End of "Override Default Server Settings"
Put(s_web._SitesQueue)
Global:SessionTimeOut is a long and can be set by the user (in minutes) but as the code shows it cannot be zero.
Is there anything wrong with my code above?
Chuck
25
Web Server - Ask For Help / using in-memory driver
« on: July 27, 2013, 07:24:50 AM »
Clarion 8 9661 NT 7.15
My Clarion Win32 app creates many reports that consists of a queue that is populated with data taken from many different tables. To do the same thing in my NetWebServer app for each report I create a randomly named temporary .tps file that is unique for each session. All of these temp files are created in a temp folder under the web folder. The temp folder contents are deleted each night via a timer in the web app .exe procedure. This essentially gives me the same functionality in the web app as using a queue for reports in the Win32 app.
This works fine but because each report must be created on the fly when the NetWebBrowse is displayed it may take some time for some of the reports to generate.
I am thinking of using the in-memory driver for these temporary tables rather than an actual on-disk file. There would still be the time involved in reading the disk tables to create the memory table but the read time to create the browse would be eliminated.
My concern is the use of RAM - there may be 25 different users logged in at any one time with each user having 10-15 memory tables created for their session. How do I remove the memory tables from RAM when each session ends? And how do I know when a session ends? What is/are the best ways to manage the RAM in this scenario?
Thanks,
Chuck
My Clarion Win32 app creates many reports that consists of a queue that is populated with data taken from many different tables. To do the same thing in my NetWebServer app for each report I create a randomly named temporary .tps file that is unique for each session. All of these temp files are created in a temp folder under the web folder. The temp folder contents are deleted each night via a timer in the web app .exe procedure. This essentially gives me the same functionality in the web app as using a queue for reports in the Win32 app.
This works fine but because each report must be created on the fly when the NetWebBrowse is displayed it may take some time for some of the reports to generate.
I am thinking of using the in-memory driver for these temporary tables rather than an actual on-disk file. There would still be the time involved in reading the disk tables to create the memory table but the read time to create the browse would be eliminated.
My concern is the use of RAM - there may be 25 different users logged in at any one time with each user having 10-15 memory tables created for their session. How do I remove the memory tables from RAM when each session ends? And how do I know when a session ends? What is/are the best ways to manage the RAM in this scenario?
Thanks,
Chuck
26
Web Server - Ask For Help / what is best embed for building a browse on the fly
« on: July 26, 2013, 01:13:38 PM »
NT 7.15
I have a browse that displays a table that is built each time the browse is refreshed. The browse is file loaded. Which embed should I use? I understand the browse procedure is called several times and I do not want to build the temp file any more times than necessary.
Chuck
I have a browse that displays a table that is built each time the browse is refreshed. The browse is file loaded. Which embed should I use? I understand the browse procedure is called several times and I do not want to build the temp file any more times than necessary.
Chuck
27
Web Server - Ask For Help / multi-dll app - file open problem
« on: July 24, 2013, 05:54:34 AM »
I have experienced this problem going back to NT 4 - I am using NT 7.15 now.
In a multi-dll app, in any dll but not the .exe, - p_web._OpenFile() does not open the file unless the file has been declared somewhere in the main .exe app.
The workaround I have always used is to have a never-called source procedure in the main .exe app where I add the file to the "other files" list.
So, if a file is "declared" somewhere in the main .exe app it opens fine in any dll app when p_web._OpenFile(filename) is called - but will not otherwise open.
If I explicitly open a file - via Access:Filename.Open() ;Access:Filename.UseFile() in one of the dll apps it works fine whether declared in the main .exe or not. But p.web_OpenFile() will not open the file unless the file is declared in the main .exe app.
And I cannot provide an example app unless my entire NetTalk web server app can be used.
I have had this problem with every NetTalk web server app that I have created since NT4.
Chuck
In a multi-dll app, in any dll but not the .exe, - p_web._OpenFile() does not open the file unless the file has been declared somewhere in the main .exe app.
The workaround I have always used is to have a never-called source procedure in the main .exe app where I add the file to the "other files" list.
So, if a file is "declared" somewhere in the main .exe app it opens fine in any dll app when p_web._OpenFile(filename) is called - but will not otherwise open.
If I explicitly open a file - via Access:Filename.Open() ;Access:Filename.UseFile() in one of the dll apps it works fine whether declared in the main .exe or not. But p.web_OpenFile() will not open the file unless the file is declared in the main .exe app.
And I cannot provide an example app unless my entire NetTalk web server app can be used.
I have had this problem with every NetTalk web server app that I have created since NT4.
Chuck
28
Web Server - Ask For Help / set file upload folder unique for each session
« on: July 20, 2013, 03:00:14 PM »
NT7.15
I have a situation where I may have multiple users uploading files at the same time and some of the files may have the same name. Because of this, I cannot use a common folder for uploads.
I want to create a randomly named folder for each session so any files uploaded in a specific session will be uploaded into a uniquely name folder.
How can I set a unique upload folder for a session? When the files are uploaded by a user they will be processed in the SaveFile embed of the File Upload control in a form and they will be moved out of the upload folder to another location. When the session ends the randomly named upload folder will be removed.
Also, in the properties of a File Upload control where does the file go if "Save incoming file to uploads folder" is not checked?
Thanks,
Chuck
I have a situation where I may have multiple users uploading files at the same time and some of the files may have the same name. Because of this, I cannot use a common folder for uploads.
I want to create a randomly named folder for each session so any files uploaded in a specific session will be uploaded into a uniquely name folder.
How can I set a unique upload folder for a session? When the files are uploaded by a user they will be processed in the SaveFile embed of the File Upload control in a form and they will be moved out of the upload folder to another location. When the session ends the randomly named upload folder will be removed.
Also, in the properties of a File Upload control where does the file go if "Save incoming file to uploads folder" is not checked?
Thanks,
Chuck
29
Web Server - Ask For Help / how to force browse reset after delete validate fail
« on: July 20, 2013, 05:10:23 AM »
NT7.15
I have a browse/form combo that allows for inserts and deletes. Under some circumstances when a record is deleted it is not really deleted but a flag in the record is set to filter the record out of the browse.
In order to accomplish this I use code in the delete validate embed of the form. This works fine - when the delete button is clicked I set the flag (a byte field that = true or false) in the record - this flag then filters the record from appearing on the browse. But to prevent the actual delete of the record I set loc:invalid = 'something' in the delete validate - the problem is that when loc:invalid is set in delete validate the browse is not reset.
My question is how to reset the browse even though delete validate has prevented the actual deletion of the record.
Thanks,
Chuck
I have a browse/form combo that allows for inserts and deletes. Under some circumstances when a record is deleted it is not really deleted but a flag in the record is set to filter the record out of the browse.
In order to accomplish this I use code in the delete validate embed of the form. This works fine - when the delete button is clicked I set the flag (a byte field that = true or false) in the record - this flag then filters the record from appearing on the browse. But to prevent the actual delete of the record I set loc:invalid = 'something' in the delete validate - the problem is that when loc:invalid is set in delete validate the browse is not reset.
My question is how to reset the browse even though delete validate has prevented the actual deletion of the record.
Thanks,
Chuck
30
Web Server - Ask For Help / browse form buttons will hide but not disable
« on: July 19, 2013, 09:44:30 AM »
NT 7.15
I have a browse with a form. The insert and delete buttons, as set on the form tab of the browse procedure properties, will only hide and not disable with a condition. If I set the buttons to disable if the condition is not met they hide instead of disable.
Chuck
I have a browse with a form. The insert and delete buttons, as set on the form tab of the browse procedure properties, will only hide and not disable with a condition. If I set the buttons to disable if the condition is not met they hide instead of disable.
Chuck