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 / how to get browse to display string longer that @S255
« on: October 05, 2013, 05:38:19 AM »
I have a browse that has a column taken from a memo field. The browse column appears to be limited to a string length of 255 characters. Is there a way to display more than 255 characters in a browse column or do I need to do something else here?
Chuck
Chuck
17
Web Server - Ask For Help / Re: variable will not accept time picture
« on: October 04, 2013, 09:04:46 AM »
mistake in previous post:
this line
This added line: And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
prevents the deformat if the variable is still formated to '@T3B'
should be
This added line: And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
prevents the deformat if the variable is no longer formated to '@T3B'
Chuck
Chuck
this line
This added line: And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
prevents the deformat if the variable is still formated to '@T3B'
should be
This added line: And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
prevents the deformat if the variable is no longer formated to '@T3B'
Chuck
Chuck
18
Web Server - Ask For Help / Re: variable will not accept time picture
« on: October 04, 2013, 09:01:54 AM »
The extra deformating of the variable in RestoreMem is definitely causing the problem so I created a dirty little work around by modifying the RestoreMem Routine to this:
if p_web.IfExistsValue('Local:EditFormStartTime') And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
Local:EditFormStartTime = p_web.dformat(clip(p_web.GetValue('Local:EditFormStartTime')),'@T3B')
p_web.SetSessionValue('Local:EditFormStartTime',Local:EditFormStartTime)
Elsif p_web.IfExistsSessionValue('Local:EditFormStartTime')
Local:EditFormStartTime = p_web.GetSessionValue('Local:EditFormStartTime')
End
Exit
This added line: And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
prevents the deformat if the variable is still formated to '@T3B'
Chuck
if p_web.IfExistsValue('Local:EditFormStartTime') And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
Local:EditFormStartTime = p_web.dformat(clip(p_web.GetValue('Local:EditFormStartTime')),'@T3B')
p_web.SetSessionValue('Local:EditFormStartTime',Local:EditFormStartTime)
Elsif p_web.IfExistsSessionValue('Local:EditFormStartTime')
Local:EditFormStartTime = p_web.GetSessionValue('Local:EditFormStartTime')
End
Exit
This added line: And Not Numeric(p_web.GetValue('Local:EditFormStartTime'))
prevents the deformat if the variable is still formated to '@T3B'
Chuck
19
Web Server - Ask For Help / Re: variable will not accept time picture
« on: October 04, 2013, 05:35:06 AM »
Bruce,
Here is what I have found so far:
When the save button is clicked I have tracked this to RestoreMem Routine
p_stage = of Net:ChangeRecord + NET:WEB:StageValidate
RestoreMem is called here and p_web.IfExistsValue('Local:EditFormStartTime') returns True
so Local:EditFormStartTime = p_web.dformat(clip(p_web.GetValue('Local:EditFormStartTime')),'@T3B')
is used to set the value of Local:EditFormStartTime
BUT p_web.GetValue('Local:EditFormStartTime') is already deformated at this point so the deformatting of an already deformated value is returning the wrong value.
When p_stage = of Net:ChangeRecord + NET:WEB:StageValidate should GetValue exist at this point?
Chuck
Here is what I have found so far:
When the save button is clicked I have tracked this to RestoreMem Routine
p_stage = of Net:ChangeRecord + NET:WEB:StageValidate
RestoreMem is called here and p_web.IfExistsValue('Local:EditFormStartTime') returns True
so Local:EditFormStartTime = p_web.dformat(clip(p_web.GetValue('Local:EditFormStartTime')),'@T3B')
is used to set the value of Local:EditFormStartTime
BUT p_web.GetValue('Local:EditFormStartTime') is already deformated at this point so the deformatting of an already deformated value is returning the wrong value.
When p_stage = of Net:ChangeRecord + NET:WEB:StageValidate should GetValue exist at this point?
Chuck
20
Web Server - Ask For Help / Re: variable will not accept time picture
« on: October 03, 2013, 07:01:17 AM »
Bruce,
This seemed so simple at the start - here is the detail of what I am trying to do:
On a "master" memory form I have a button that "calls" the memory form I am having the problem with. The "call" to the memory form is on the button "onclick" tab by selecting the procedure from the drop list. Popup is checked, Include Action is checked, Action = Change
Then on the called form I am priming the two local LONG variables that are added to the form as strings with the picture '@T3B'. The priming is done on the Priming tab with this code:
Local:StartTime = p_web.GSV('CurrentJobStartTime') and Prime For Change is checked.
Local:EndTime = p_web.GSV('CurrentJobEndTime') and Prime For Change is checked.
When the form displays, Local:StartTime is displayed correctly with the value that is set in the "Master" form. But Local:EndTime always shows 12:00AM when Local:EndTime = 0. If Local:EndTime is set to something other than zero then the time displays correctly for the primed field.
For the Save button I have the embeded code in the ValidateUpdate embed. In the ValidateUpdate embed I fetch the table record that I want to update and retrieve Local:StartTime and Local:EndTime by getting their session values. At this point, in the ValidateUpdate embed, Local:StartTime and Local:EndTime _always_ display (by using Message(format(Local:StartTime,@T3B)) as 12:00AM regarding of the value showed in the form fields.
I am stumped.
Chuck
This seemed so simple at the start - here is the detail of what I am trying to do:
On a "master" memory form I have a button that "calls" the memory form I am having the problem with. The "call" to the memory form is on the button "onclick" tab by selecting the procedure from the drop list. Popup is checked, Include Action is checked, Action = Change
Then on the called form I am priming the two local LONG variables that are added to the form as strings with the picture '@T3B'. The priming is done on the Priming tab with this code:
Local:StartTime = p_web.GSV('CurrentJobStartTime') and Prime For Change is checked.
Local:EndTime = p_web.GSV('CurrentJobEndTime') and Prime For Change is checked.
When the form displays, Local:StartTime is displayed correctly with the value that is set in the "Master" form. But Local:EndTime always shows 12:00AM when Local:EndTime = 0. If Local:EndTime is set to something other than zero then the time displays correctly for the primed field.
For the Save button I have the embeded code in the ValidateUpdate embed. In the ValidateUpdate embed I fetch the table record that I want to update and retrieve Local:StartTime and Local:EndTime by getting their session values. At this point, in the ValidateUpdate embed, Local:StartTime and Local:EndTime _always_ display (by using Message(format(Local:StartTime,@T3B)) as 12:00AM regarding of the value showed in the form fields.
I am stumped.
Chuck
21
Web Server - Ask For Help / Re: variable will not accept time picture
« on: October 03, 2013, 06:08:31 AM »
Bruce,
I cannot comment-out the ValidateAll embed - this is where I fetch a record from a table and update a field with the value of the local field on the memory form.
Chuck
I cannot comment-out the ValidateAll embed - this is where I fetch a record from a table and update a field with the value of the local field on the memory form.
Chuck
22
Web Server - Ask For Help / Re: variable will not accept time picture
« on: October 03, 2013, 04:36:29 AM »
Bruce,
I will add StringTheory to the example and try that but, yes, there is embed code in my form. I am presetting the values of the local variable in the GenerateForm embed. And I have embeded code in the ValidateAll embed (have also tried the validate update embed).
I have also done this - I put a stop in the field add-server-side code to check the value - the value is correct there but when save is clicked the value had changed in the validate all (or validate update) embed.
Chuck
I will add StringTheory to the example and try that but, yes, there is embed code in my form. I am presetting the values of the local variable in the GenerateForm embed. And I have embeded code in the ValidateAll embed (have also tried the validate update embed).
I have also done this - I put a stop in the field add-server-side code to check the value - the value is correct there but when save is clicked the value had changed in the validate all (or validate update) embed.
Chuck
23
Web Server - Ask For Help / Re: variable will not accept time picture
« on: October 02, 2013, 10:44:24 AM »
In addition to this problem I tried to run the TimeFields(35) example app looking for clues but it crashes with an exception as soon as a browser requests a page.
Chuck
Chuck
24
Web Server - Ask For Help / variable will not accept time picture
« on: October 02, 2013, 09:33:00 AM »
C8 9661 NT 7.20
I have a memory form with a local long variable to be used for time entry. I have tried several different time pictures and when the field is tabbed out of the time is displayed correctly. But the value never reaches the validate embed when I click the save button. The value almost always changes to 1 - that's the number 1 - this is regardless of what time I enter. If I remove the time picture and have no field picture at all I can enter any value and it reaches the validate embed correctly - something does not like the time picture formatting.
This is a popup form but it does the same thing with a standard form.
Is this a bug or am I doing something wrong?
Chuck
I have a memory form with a local long variable to be used for time entry. I have tried several different time pictures and when the field is tabbed out of the time is displayed correctly. But the value never reaches the validate embed when I click the save button. The value almost always changes to 1 - that's the number 1 - this is regardless of what time I enter. If I remove the time picture and have no field picture at all I can enter any value and it reaches the validate embed correctly - something does not like the time picture formatting.
This is a popup form but it does the same thing with a standard form.
Is this a bug or am I doing something wrong?
Chuck
25
Web Server - Ask For Help / Re: form - on save will not insert another
« on: September 19, 2013, 10:10:22 AM »
Bruce,
You are correct - it does not work in popup mode but does work in regular mode.
Chuck
You are correct - it does not work in popup mode but does work in regular mode.
Chuck
26
Web Server - Ask For Help / form - on save will not insert another
« on: September 19, 2013, 07:49:17 AM »
NT 7.20
I have a basic browse/form where in the form properties I have "On Save. When inserting:" set to "insert another". It does not work - always returns to the browse on Save. Does this feature work, and if so, what might I be missing?
Chuck
I have a basic browse/form where in the form properties I have "On Save. When inserting:" set to "insert another". It does not work - always returns to the browse on Save. Does this feature work, and if so, what might I be missing?
Chuck
27
Web Server - Ask For Help / Re: how to handle ajax post/get from non-NetTalk generated page
« on: September 04, 2013, 02:18:09 PM »
I found and solved my problem:
changed this
url: "_CheckStatus.htm?maptechnumber=" + passedValue[0] + "&mapjobnumber=" + passedValue[1],
to this:
url: "_CheckStatus?maptechnumber=" + passedValue[0] + "&mapjobnumber=" + passedValue[1],
I removed the ",htm" from the ajax URL
Chuck
changed this
url: "_CheckStatus.htm?maptechnumber=" + passedValue[0] + "&mapjobnumber=" + passedValue[1],
to this:
url: "_CheckStatus?maptechnumber=" + passedValue[0] + "&mapjobnumber=" + passedValue[1],
I removed the ",htm" from the ajax URL
Chuck
28
Web Server - Ask For Help / Re: how to handle ajax post/get from non-NetTalk generated page
« on: September 04, 2013, 12:27:00 PM »
In addition:
I have the web page ajax working now on the browser side - this is the javascript function that is sending a GET to the server:
function techChange(value) {
var passedValue = value.split(":");
$.ajax( {
url: "_CheckStatus.htm?maptechnumber=" + passedValue[0] + "&mapjobnumber=" + passedValue[1],
success: function(data) {
alert(data);
//iw.setContent(data);
//iw.open(map, marker);
}
});
} // end of function techChange
I can see the GET being received on the Web Server logging window along with the passed parameters but the procedure _CheckStatus is not getting called even though it shows the page being called on the logging window.
This is the entire logging window text:
GET /_CheckStatus.htm?maptechnumber=6&mapjobnumber=4556 HTTP/1.1
Host: 127.0.0.1:881
Connection: keep-alive
Accept: */*
X-Requested-With: XMLHttpRequest
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.62 Safari/537.36
DNT: 1
Referer: http://127.0.0.1:881/job_map_today_store
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Cookie: SESSIONID=ASgIoo8ydI8x0cfZbUBWz66LvnSD13
What do I need to do from here?
Chuck
I have the web page ajax working now on the browser side - this is the javascript function that is sending a GET to the server:
function techChange(value) {
var passedValue = value.split(":");
$.ajax( {
url: "_CheckStatus.htm?maptechnumber=" + passedValue[0] + "&mapjobnumber=" + passedValue[1],
success: function(data) {
alert(data);
//iw.setContent(data);
//iw.open(map, marker);
}
});
} // end of function techChange
I can see the GET being received on the Web Server logging window along with the passed parameters but the procedure _CheckStatus is not getting called even though it shows the page being called on the logging window.
This is the entire logging window text:
GET /_CheckStatus.htm?maptechnumber=6&mapjobnumber=4556 HTTP/1.1
Host: 127.0.0.1:881
Connection: keep-alive
Accept: */*
X-Requested-With: XMLHttpRequest
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.62 Safari/537.36
DNT: 1
Referer: http://127.0.0.1:881/job_map_today_store
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Cookie: SESSIONID=ASgIoo8ydI8x0cfZbUBWz66LvnSD13
What do I need to do from here?
Chuck
29
Web Server - Ask For Help / how to handle ajax post/get from non-NetTalk generated page
« on: September 04, 2013, 08:53:38 AM »
I have a non-NetTalk generated web page that my NetTalk web app displays for the user - being called from a NetwebPage procedure. I need to do some ajax back to the NetTalk web server from this page. I have full control of the ajax on the displayed page so I can make it anything that will work on the server side. How do I handle this on the NetTalk server side?
Chuck
Chuck
30
Web Server - Ask For Help / more Google maps questions
« on: September 03, 2013, 10:23:07 AM »
With Don Ridley pointing me in the right direction I have integrated the Google Maps api into my web app - it shows scheduled service jobs with markers and information for each repair job.
What I want to know is where to start making it interactive, if possible. I want the user to be able to do something on the map, such as click a link or a control and have that action feed back to my NetTalk web server app. Probably easiest would be to put a link in the info window for the map marker. I want the user to be able to select a service technician to assign to the job that is indicated by the map marker.
What do I need in the Google Maps page to post/get to my server app? Session ID, etc.? To create the Google Maps page I use a NetwebPage and mostly javascript from the Google API - so I can add anything to the map page that I want.
Chuck
What I want to know is where to start making it interactive, if possible. I want the user to be able to do something on the map, such as click a link or a control and have that action feed back to my NetTalk web server app. Probably easiest would be to put a link in the info window for the map marker. I want the user to be able to select a service technician to assign to the job that is indicated by the map marker.
What do I need in the Google Maps page to post/get to my server app? Session ID, etc.? To create the Google Maps page I use a NetwebPage and mostly javascript from the Google API - so I can add anything to the map page that I want.
Chuck