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 / Re: Auto print from Web server app
« on: August 22, 2017, 07:25:14 AM »
Hi Richard
What we do is generate the file as a pdf and store it on the server.
We then either email a copy of the document to the customer or send an sms to him with a link to the document so that he can download it.
What we do is generate the file as a pdf and store it on the server.
We then either email a copy of the document to the customer or send an sms to him with a link to the document so that he can download it.
17
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?
18
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?
19
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?
20
Web Server - Ask For Help / Re: Windows pass-through authentication?
« on: May 27, 2017, 09:35:22 PM »
Hi Bruce.
Is there any chance that consuming wsdls generated by other companies will be part of NTWS10? You have indicated a couple of times that it is very close. I know from a previous thread that a number of users are waiting for it.
Is there any chance that consuming wsdls generated by other companies will be part of NTWS10? You have indicated a couple of times that it is very close. I know from a previous thread that a number of users are waiting for it.
21
Web Server - Ask For Help / Re: File Upload NT 9.27
« on: May 21, 2017, 09:40:09 PM »
Hi Jeff
I had a similar (but not exactly the same) issue with printing pdfs and then when data has changed printing them again but still having the previous pdf displayed.
What I did was uncheck the enable file cache box in the webserver nettalk extension\Settings\Performance tab and the problem went away. According to Bruce there should not be much performance penalty.
There is a thread I started on this website about the issue.
I had a similar (but not exactly the same) issue with printing pdfs and then when data has changed printing them again but still having the previous pdf displayed.
What I did was uncheck the enable file cache box in the webserver nettalk extension\Settings\Performance tab and the problem went away. According to Bruce there should not be much performance penalty.
There is a thread I started on this website about the issue.
22
Web Server - Ask For Help / Re: Routine Not Defined
« on: May 10, 2017, 11:37:09 PM »
Hi Rupert.
This will happen if you had a results field which used to be reset by another field. If you then remove the results field from the form and do not remove the reset from the other field.
This will happen if you had a results field which used to be reset by another field. If you then remove the results field from the form and do not remove the reset from the other field.
23
Web Server - Ask For Help / Re: Lookup Button - 'Display Description instead of Value' Problem
« on: April 21, 2017, 03:21:27 AM »
Hi Johan
Does your description field have a unique key? It will need one for the lookup to work correctly.
Does your description field have a unique key? It will need one for the lookup to work correctly.
24
Web Server - Ask For Help / Re: Busyhandling MARS p_web.sqlsync , where
« on: April 11, 2017, 03:31:13 AM »
Hi Alberto
We use this string in that field with no problems
/MULTIPLERESULTSETS=TRUE /BUSYHANDLING=2
We use this string in that field with no problems
/MULTIPLERESULTSETS=TRUE /BUSYHANDLING=2
25
Web Server - Ask For Help / Re: How to avoid Deadly embrace
« on: February 06, 2017, 12:58:36 AM »
Thanks Kevin.
I'll give it a try.
I'll give it a try.
26
Web Server - Ask For Help / Re: How to avoid Deadly embrace
« on: February 05, 2017, 11:57:57 PM »
Hi Kevin
MSSQL.
The table I am using has only one function to give me the next sequential number.
MSSQL.
The table I am using has only one function to give me the next sequential number.
27
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)
28
Web Server - Ask For Help / Re: Browse less edit form does not show the data
« on: January 25, 2017, 09:41:11 PM »
Thanks Bruce
29
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.
30
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.