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 / Error on upgrading from 10.15 to 10.16
« on: February 17, 2018, 11:42:47 PM »
Hi
I got the attached error when compiling after upgrading to the latest version.
Clicking on the error does not display the clw.
If I revert to 10.15 the error disappears
I got the attached error when compiling after upgrading to the latest version.
Clicking on the error does not display the clw.
If I revert to 10.15 the error disappears
2
Web Server - Ask For Help / For Jason - Exam question
« on: January 15, 2018, 11:30:05 PM »
Hi Jason. Sorry I cant reply to your message it produces error 500
Just off the top of my head.
Do a count of records in the table RECORDS(table)
Generate random number x# = RANDOM(1,RECORDS(table))
GET(table,x#) GET using File,filepointer)
Just off the top of my head.
Do a count of records in the table RECORDS(table)
Generate random number x# = RANDOM(1,RECORDS(table))
GET(table,x#) GET using File,filepointer)
3
Web Server - Ask For Help / Display date using picture in a webservice
« on: October 27, 2017, 03:05:21 AM »
We have built a webservice in which the customer enters a code. We return a description and a date from the table.
The table is an MSSQL table and the field is a Date field. The date displays as a Clarion Date (78000). I would like it to display a formatted date (@D10-)
Help would be appreciated
The table is an MSSQL table and the field is a Date field. The date displays as a Clarion Date (78000). I would like it to display a formatted date (@D10-)
Help would be appreciated
4
Web Server - Ask For Help / Right Justify on browse fields stopped working in NT10
« on: September 24, 2017, 10:23:32 PM »
Subject says it all.
Image 1 application compiled with 9.31
Image 2 application compiled with 10.03
Image 3 application compiled with 10.06
Image 4 application compiled with 10.06 Image 5 setting for Image4 in field CSS setting
Image 1 application compiled with 9.31
Image 2 application compiled with 10.03
Image 3 application compiled with 10.06
Image 4 application compiled with 10.06 Image 5 setting for Image4 in field CSS setting
5
Web Server - Ask For Help / Change Create Hyperlink value in progress control programatically
« on: July 05, 2017, 09:59:35 PM »
In my StartProcess Form on the Progress Control I set the text value to be p_web.GSV('ProgressMessage') and check the "Create Hyperlink when process completes" box
In my MakeFile I do a count of the number of records to process ( I normally use MSSQL).
If there are records to process I do p_web.SSV('Progress Message', FileRecords & ' records. Click here to download')
If there are no records p_web.SSV('ProgressMessage','SORRY NO RECORDS') or a request specific value
In the first instance no problem, the file is created and the user can click to download
In the second I would like to change the "Create Hyperlink when process completes" setting from TRUE to FALSE so that the user cannot download the blank file.
Is this possible at runtime?
In my MakeFile I do a count of the number of records to process ( I normally use MSSQL).
If there are records to process I do p_web.SSV('Progress Message', FileRecords & ' records. Click here to download')
If there are no records p_web.SSV('ProgressMessage','SORRY NO RECORDS') or a request specific value
In the first instance no problem, the file is created and the user can click to download
In the second I would like to change the "Create Hyperlink when process completes" setting from TRUE to FALSE so that the user cannot download the blank file.
Is this possible at runtime?
6
Web Server - Ask For Help / Signature field type in MSSQL
« on: June 20, 2017, 11:19:59 PM »
We are using signatures in a Web application. If we use tps and set the field as a memo there is no problem.
What I would like to do is store the field in an MSSQL table. I have tried various data types Cstring, String and Blob but have had no luck in storing the data in these fields.
Is it possible, and if so, is there an example.
Should I bring it up during the Webinar tomorrow?
What I would like to do is store the field in an MSSQL table. I have tried various data types Cstring, String and Blob but have had no luck in storing the data in these fields.
Is it possible, and if so, is there an example.
Should I bring it up during the Webinar tomorrow?
7
Web Server - Ask For Help / On the performance tab what is the unit of the session data
« on: May 30, 2017, 01:01:18 AM »
If I have a value of 345 is this bytes, Kb or some other number. If I clear the performance tab and do one transaction does this represent the amount of data transferred to the client?
8
Web Server - Ask For Help / How to avoid Deadly embrace
« on: February 05, 2017, 11:29:14 PM »
The problem I am having is nothing to do with Nettalk but hopefully someone can point me to the best way to eliminate the issue.
In my Capture form I enter various fields and then save the form.
Because I want sequential job numbers with no numbers missing I then call this routine from the PostInsert Embed:-
GetNextJobNumber ROUTINE
Access:NextNumber.Open()
Access:NextNumber.UseFile()
NEXT:NumberType = 'JOBNO'
Access:NextNumber.Fetch(NEXT:PK_NumberType)
JobNo = CLIP(NEXT:Prefix) & FORMAT(NEXT:NextNumber,@N06)
NEXT:NextNumber += 1
Access:NextNumber.Update()
Access:NextNumber.Close()
EXIT
I have made it as small as I can to avoid clashes when multiple users are adding records but on Friday I had a deadly embrace. The table was locked presumably by 2 people adding a record and calling this procedure at the same millisecond.
What is the best way to allow one or another of the records to give way gracefully and then retry until successful.
[UPDATE]
Just looked up deadly Embrace in the Help. It deals with a view and a loop. How would I modify this to use in my situation?
ViewOrder VIEW(Customer) !Declare VIEW structure
PROJECT(Cus:AcctNumber,Cus:Name)
JOIN(Hea:AcctKey,Cus:AcctNumber) !Join Header file
PROJECT(Hea:OrderNumber)
JOIN(Dtl:OrderKey,Hea:OrderNumber) !Join Detail file
PROJECT(Det:Item,Det:Quantity)
JOIN(Pro:ItemKey,Dtl:Item) !Join Product file
PROJECT(Pro:Description,Pro:Price)
END
END
END
END
CODE
OPEN(Customer,22h)
OPEN(Header,22h)
OPEN(Detail,22h)
OPEN(Product,22h)
SET(Cus:AcctKey)
OPEN(ViewOrder)
LOOP !Process records Loop
LOOP !Loop to avoid "deadly embrace"
HOLD(ViewOrder,1) !Arm Hold on view, primary record only,try for 1 second
NEXT(ViewOrder) !Get and hold the record
IF ERRORCODE() = 43 !If someone else has it
CYCLE ! try again
ELSE
BREAK !Break if not held
END
END
IF ERRORCODE() THEN BREAK END !Check for end of file
!Process the records
RELEASE(ViewOrder) !release Primary held record
END
CLOSE(ViewOrder)
In my Capture form I enter various fields and then save the form.
Because I want sequential job numbers with no numbers missing I then call this routine from the PostInsert Embed:-
GetNextJobNumber ROUTINE
Access:NextNumber.Open()
Access:NextNumber.UseFile()
NEXT:NumberType = 'JOBNO'
Access:NextNumber.Fetch(NEXT:PK_NumberType)
JobNo = CLIP(NEXT:Prefix) & FORMAT(NEXT:NextNumber,@N06)
NEXT:NextNumber += 1
Access:NextNumber.Update()
Access:NextNumber.Close()
EXIT
I have made it as small as I can to avoid clashes when multiple users are adding records but on Friday I had a deadly embrace. The table was locked presumably by 2 people adding a record and calling this procedure at the same millisecond.
What is the best way to allow one or another of the records to give way gracefully and then retry until successful.
[UPDATE]
Just looked up deadly Embrace in the Help. It deals with a view and a loop. How would I modify this to use in my situation?
ViewOrder VIEW(Customer) !Declare VIEW structure
PROJECT(Cus:AcctNumber,Cus:Name)
JOIN(Hea:AcctKey,Cus:AcctNumber) !Join Header file
PROJECT(Hea:OrderNumber)
JOIN(Dtl:OrderKey,Hea:OrderNumber) !Join Detail file
PROJECT(Det:Item,Det:Quantity)
JOIN(Pro:ItemKey,Dtl:Item) !Join Product file
PROJECT(Pro:Description,Pro:Price)
END
END
END
END
CODE
OPEN(Customer,22h)
OPEN(Header,22h)
OPEN(Detail,22h)
OPEN(Product,22h)
SET(Cus:AcctKey)
OPEN(ViewOrder)
LOOP !Process records Loop
LOOP !Loop to avoid "deadly embrace"
HOLD(ViewOrder,1) !Arm Hold on view, primary record only,try for 1 second
NEXT(ViewOrder) !Get and hold the record
IF ERRORCODE() = 43 !If someone else has it
CYCLE ! try again
ELSE
BREAK !Break if not held
END
END
IF ERRORCODE() THEN BREAK END !Check for end of file
!Process the records
RELEASE(ViewOrder) !release Primary held record
END
CLOSE(ViewOrder)
9
Web Server - Ask For Help / Browse less edit form does not show the data
« on: January 21, 2017, 10:37:01 PM »
In Nettalk Webinar 131 at minute 37 Ashley asked why a browse less edit form does not show the data as before. I had the same problem where I SMS or Email a link to a customer
http://localhost:8088/RStatus?Job=o0tf9gkov3oxsyoz and they then have a netwebform screen displaying the data linked to the job.
This has worked going back to a version using Nettalk5 which is still in operation up to 913 which I am using at the moment. Subsequent versions display the form but no data.
I have tested this by upgrading to and 916 and 917, getting a blank from back, reinstalling 913 and getting the data displayed.
I notice that the date of the 917 apps upload on the website is 3rd January while the webinar took place on the 5th January. The 917 Server version was uploaded on 13th January so possibly only the Server version was fixed.
Unfortunately I cannot upload any images or examples as this website has for the last week or 2 been advising that the uploads folder is full.
Could you please add this to the 918 upgrade.
http://localhost:8088/RStatus?Job=o0tf9gkov3oxsyoz and they then have a netwebform screen displaying the data linked to the job.
This has worked going back to a version using Nettalk5 which is still in operation up to 913 which I am using at the moment. Subsequent versions display the form but no data.
I have tested this by upgrading to and 916 and 917, getting a blank from back, reinstalling 913 and getting the data displayed.
I notice that the date of the 917 apps upload on the website is 3rd January while the webinar took place on the 5th January. The 917 Server version was uploaded on 13th January so possibly only the Server version was fixed.
Unfortunately I cannot upload any images or examples as this website has for the last week or 2 been advising that the uploads folder is full.
Could you please add this to the 918 upgrade.
10
Web Server - Ask For Help / Button on browse like the Export button
« on: January 16, 2017, 03:44:32 AM »
I am working on a browse where there is a tag checkbox against each record.
I don't want the operation to take place immediately a record is tagged as is done in the Capesoft example, I want to tag say, 10 records, and then click a button on the browse which will loop through the tagged records and apply the logic.
Is there a way to add a button to the browse (next to the export button would be nice) which I could then add the logic to?
On further thought I think the way to do this would be to encapsulate the browse in a form and have a button on the form underneath the browse to do the work. Unless someone has another suggestion I am going with that.
I don't want the operation to take place immediately a record is tagged as is done in the Capesoft example, I want to tag say, 10 records, and then click a button on the browse which will loop through the tagged records and apply the logic.
Is there a way to add a button to the browse (next to the export button would be nice) which I could then add the logic to?
On further thought I think the way to do this would be to encapsulate the browse in a form and have a button on the form underneath the browse to do the work. Unless someone has another suggestion I am going with that.
11
Web Server - Ask For Help / Progress Bar disappearing during process
« on: December 29, 2016, 10:22:01 PM »
Hi Bruce
Following on from yesterday's Webinar regarding the progress bar issue experienced by myself and Ashley.
I have modified the web72 example.
Before these changes I ran the example and it completed the file make.
In the ProcessMakeFile procedure.
DataSection
I added a variable recordsize as a long
ProcessedCode
Before the loop I set recordsize to 5000
I then looped from record 1 to 5000
I changed the percentagecomplete calculation to x * 100/recordsize
I added a StringTheory Local Object (st) and added a st.trace to monitor the process
On running this it exhibits exactly the symptoms we described.
The progress bar displays for a short while and then disappears.
However the process still continues.
Checking Web72.exe in TaskManager shows cpu activity (mine hovers around 12)
Using debugview I can see each traceline
Observations.
If I rem out the artificial delay the progress bar does not disappear ( in this example)
As I mentioned anectodally if I change the StartProcess File Tab PageProcess Progress Timer to (say 20000) the progress bar stays visible.
As a layman's observation it seems as though if the ProgressTimer interval is not large enough for 1% to be calculated in the loop that is when the progress bar disappears.
What I mean is if the progressInterval is 2000 (2 seconds) and it takes more than 2 seconds for 50 records to be processed in this example then the progress bar disappears
Following on from yesterday's Webinar regarding the progress bar issue experienced by myself and Ashley.
I have modified the web72 example.
Before these changes I ran the example and it completed the file make.
In the ProcessMakeFile procedure.
DataSection
I added a variable recordsize as a long
ProcessedCode
Before the loop I set recordsize to 5000
I then looped from record 1 to 5000
I changed the percentagecomplete calculation to x * 100/recordsize
I added a StringTheory Local Object (st) and added a st.trace to monitor the process
On running this it exhibits exactly the symptoms we described.
The progress bar displays for a short while and then disappears.
However the process still continues.
Checking Web72.exe in TaskManager shows cpu activity (mine hovers around 12)
Using debugview I can see each traceline
Observations.
If I rem out the artificial delay the progress bar does not disappear ( in this example)
As I mentioned anectodally if I change the StartProcess File Tab PageProcess Progress Timer to (say 20000) the progress bar stays visible.
As a layman's observation it seems as though if the ProgressTimer interval is not large enough for 1% to be calculated in the loop that is when the progress bar disappears.
What I mean is if the progressInterval is 2000 (2 seconds) and it takes more than 2 seconds for 50 records to be processed in this example then the progress bar disappears
12
Web Server - Ask For Help / Drop list behaviour in a form.
« on: December 02, 2016, 08:08:12 PM »
If I have a droplist in a form there are 3 methods I can use to select a record from it:-
Use a mouse to click on the down arrow to the right of the field display. This then shows the drop list which I can navigate using the keyboard or a mouse
I can use a mouse to click on the display field and once more the drop list appears and I can navigate using keyboard or mouse
However if I only want to use the keyboard and I tab onto the field and use the keyboard down arrow only the first record after the displayed record appears, thereafter the displayed record does not change.If I click on this record I can once more see the droplist and can navigate as before.
This is definitely a problem since my users, and myself, prefer to use the keyboard as much as possible since tabbing from field to field is much more efficient than swapping from hands on keyboard to mouse operation and then back to keyboard.
Another situation where this causes an issue is where I have a droplist which when a record is selected it populates other fields in the form depending on which record is selected. Because only the the next record is selected and you can go no further with a keyboard operation you then need to click on the downarrow and select the correct record.
When tabbing onto a droplist is there a method to display the available records below the droplist as if I had clicked on the down arrow to the right of the droplist?
Tested on Firefox Chrome Opera and Internet Explorer 11
Use a mouse to click on the down arrow to the right of the field display. This then shows the drop list which I can navigate using the keyboard or a mouse
I can use a mouse to click on the display field and once more the drop list appears and I can navigate using keyboard or mouse
However if I only want to use the keyboard and I tab onto the field and use the keyboard down arrow only the first record after the displayed record appears, thereafter the displayed record does not change.If I click on this record I can once more see the droplist and can navigate as before.
This is definitely a problem since my users, and myself, prefer to use the keyboard as much as possible since tabbing from field to field is much more efficient than swapping from hands on keyboard to mouse operation and then back to keyboard.
Another situation where this causes an issue is where I have a droplist which when a record is selected it populates other fields in the form depending on which record is selected. Because only the the next record is selected and you can go no further with a keyboard operation you then need to click on the downarrow and select the correct record.
When tabbing onto a droplist is there a method to display the available records below the droplist as if I had clicked on the down arrow to the right of the droplist?
Tested on Firefox Chrome Opera and Internet Explorer 11
13
Web Server - Ask For Help / Cache interfering with report print pdf display.
« on: December 02, 2016, 07:43:14 PM »
I have a browse with an inline other button which prints a pdf report (using pdf tools).Its job is to print all the detail in a file.
I nominate a file name and the pdf file is created in a folder under web.In this instance
The report prints fine and displays in the web pdf viewer correctly. If, however, I change some information in the file and reprint, the pdf file displayed in the viewer is the previous pdf file, not the version that has been recreated in the web folder. It is obviously a situation where the cache has not been cleared.
If I shut down and restart and reprint I get the correct pdf in the viewer.
In the performance tab of the Nettalk webserver extension there are 3 fields that should solve my problem Enable File cache, cache files less than and Max cache size.
Under most situations I prefer cache on since I understand that it improves speed. In this instance, but not always the created pdf file is +-26Kb in size so since currently Cache files less than is set to 1000000 this is the reason why the file is cached.
So my questions.
will setting the Cache files less than to 1000 affect performance significantly?
Is there a method that will let me clear the cache only for the pdf file I am regenerating?
Should I uncheck the Enable file Cache, and will that have a performance impact?
I nominate a file name and the pdf file is created in a folder under web.In this instance
The report prints fine and displays in the web pdf viewer correctly. If, however, I change some information in the file and reprint, the pdf file displayed in the viewer is the previous pdf file, not the version that has been recreated in the web folder. It is obviously a situation where the cache has not been cleared.
If I shut down and restart and reprint I get the correct pdf in the viewer.
In the performance tab of the Nettalk webserver extension there are 3 fields that should solve my problem Enable File cache, cache files less than and Max cache size.
Under most situations I prefer cache on since I understand that it improves speed. In this instance, but not always the created pdf file is +-26Kb in size so since currently Cache files less than is set to 1000000 this is the reason why the file is cached.
So my questions.
will setting the Cache files less than to 1000 affect performance significantly?
Is there a method that will let me clear the cache only for the pdf file I am regenerating?
Should I uncheck the Enable file Cache, and will that have a performance impact?
14
Web Server - Ask For Help / Progress Bar disappearing
« on: November 01, 2016, 09:08:40 PM »
I have an issue with the progress bar disappearing intermittently in certain procedures.
This happens in more than one StartProcess/MakeFile pairing
Situation
The database is MSSQL
I start the memory form that calls the MakeFile procedure.
I enter parameters and click the Start button.
The progress bar displays with a percentage of 1
At this point 2 things can happen
1. The progress bar continues displaying incrementing percentages and at the end of the MakeFile procedure the download message link displays
2. The progress bar disappears but the MakeFile procedure continues in the background and the file is created as a $$$$ file but no link appears.
In situation 2. under certain circumstances starting the memory form from the menu again without pressing the start button on the form results in the progress bar reappearing and operating normally.
This happens in more than one StartProcess/MakeFile pairing
Situation
The database is MSSQL
I start the memory form that calls the MakeFile procedure.
I enter parameters and click the Start button.
The progress bar displays with a percentage of 1
At this point 2 things can happen
1. The progress bar continues displaying incrementing percentages and at the end of the MakeFile procedure the download message link displays
2. The progress bar disappears but the MakeFile procedure continues in the background and the file is created as a $$$$ file but no link appears.
In situation 2. under certain circumstances starting the memory form from the menu again without pressing the start button on the form results in the progress bar reappearing and operating normally.
15
Web Server - Ask For Help / Consuming WSDL files
« on: August 29, 2016, 10:11:02 PM »
Hi Bruce
It was mentioned as a possibility in Nettalk8 and a probability in Nettalk9 but I haven't seen anything further about this.
Is there any chance that we will be able to consume WSDL files using Nettalk9?
I am dealing mostly with the larger corporations and parastatals in South Africa and they require that I use their SMS or Client verification webservices.
Even when I have data to be made available to them they don't want to connect to a webservice that I supply I need to use a webservice that they provide to transfer the data to them.
I remember you saying on webinar88 in December that it was almost ready.
Please take this as a vote for this as a priority.
It was mentioned as a possibility in Nettalk8 and a probability in Nettalk9 but I haven't seen anything further about this.
Is there any chance that we will be able to consume WSDL files using Nettalk9?
I am dealing mostly with the larger corporations and parastatals in South Africa and they require that I use their SMS or Client verification webservices.
Even when I have data to be made available to them they don't want to connect to a webservice that I supply I need to use a webservice that they provide to transfer the data to them.
I remember you saying on webinar88 in December that it was almost ready.
Please take this as a vote for this as a priority.