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.
31
Web Server - Ask For Help / Re: Report PDF Error
« on: October 15, 2013, 04:27:03 AM »
I had something similar a few weeks ago.
For some reason one of my print routines was getting called and the temp file wasn't getting removed.
When I checked my temp folder on the server there were over 65000 temporary files in there. I cleared that folder down, and my reports started working again.
It might be worth checking.
Regards,
Neil.
For some reason one of my print routines was getting called and the temp file wasn't getting removed.
When I checked my temp folder on the server there were over 65000 temporary files in there. I cleared that folder down, and my reports started working again.
It might be worth checking.
Regards,
Neil.
32
Web Server - Ask For Help / NT Template 6.54, but NT Object reports 6.52
« on: October 15, 2013, 04:21:57 AM »
I'm trying to move one of my NT webservers from C8 to C9
As part of this I've had to update some of my templates, secwin and nettalk included.
No matter what I do, when I run my webserver, I get a message saying that my NT server version is 6.52 and my web folder is 6.54
I've searched all of my code, and everything reports 6.54
I've checked my clanet.dll and that reports a date of 8 October 2013, version 6.54
I've deleted my clw files, my obj folder, etc. still no joy.
I run using debug view and the /netall switch, and it reports that Nettalk template is 6.54 but the nettalk object is 6.52!!
where on earth do I track this down?
Has anyone got any ideas? This is driving me nuts :-)
Regards,
Neil.
As part of this I've had to update some of my templates, secwin and nettalk included.
No matter what I do, when I run my webserver, I get a message saying that my NT server version is 6.52 and my web folder is 6.54
I've searched all of my code, and everything reports 6.54
I've checked my clanet.dll and that reports a date of 8 October 2013, version 6.54
I've deleted my clw files, my obj folder, etc. still no joy.
I run using debug view and the /netall switch, and it reports that Nettalk template is 6.54 but the nettalk object is 6.52!!
where on earth do I track this down?
Has anyone got any ideas? This is driving me nuts :-)
Regards,
Neil.
33
Web Server - Ask For Help / Popup Progress Window - Is this possible?
« on: October 08, 2013, 07:48:40 AM »
I have a NetWebForm that has quite a lot of length validation steps.
At present I have poached some code from the Timer Example so that when the user presses the Save button on the form I have a tag that allows me to display a status message that gets updated every second. This tag contains the current validation step, and so my user gets to see some progress, and the 1 second timer means my form doesn't timeout whilst waiting for all of the validation to complete.
I would love to be able to open a small popup window showing the progress of the validation, where this might be as simple as changing a display value from Step 1 to Step 2 etc. Once all of the steps are complete, this window would close and the normal processing would continue.
Has anyone managed to do this?
Regards,
Neil.
At present I have poached some code from the Timer Example so that when the user presses the Save button on the form I have a tag that allows me to display a status message that gets updated every second. This tag contains the current validation step, and so my user gets to see some progress, and the 1 second timer means my form doesn't timeout whilst waiting for all of the validation to complete.
I would love to be able to open a small popup window showing the progress of the validation, where this might be as simple as changing a display value from Step 1 to Step 2 etc. Once all of the steps are complete, this window would close and the normal processing would continue.
Has anyone managed to do this?
Regards,
Neil.
34
Web Server - Ask For Help / Re: Calling Multiple Print Routines from one form
« on: June 12, 2013, 09:58:20 AM »
Kevin, what a cool idea.
It works like a charm!
Thank you very much for your help.
Regards,
Neil.
It works like a charm!
Thank you very much for your help.
Regards,
Neil.
35
Web Server - Ask For Help / Re: Calling Multiple Print Routines from one form
« on: June 11, 2013, 11:31:15 PM »
Hi Kev,
After they've filled a load of data into the form. That determines what report gets called.
Regards,
Neil.
After they've filled a load of data into the form. That determines what report gets called.
Regards,
Neil.
36
Web Server - Ask For Help / Re: Calling Multiple Print Routines from one form
« on: June 11, 2013, 12:13:14 PM »
Mike, I must be doing something stupid.
If I convert my netwebsource procedure to be a normal Clarion source procedure, I can't call that procedure from a button. I get an error saying the "page cannot be found" which kinda makes sense as it isn't a web procedure any more.
If I call my clarion source from the server code of my button, surely I'm back to square one, because I can't set my print procedure to have a target _blank.
I'm lost....
Regards,
Neil.
If I convert my netwebsource procedure to be a normal Clarion source procedure, I can't call that procedure from a button. I get an error saying the "page cannot be found" which kinda makes sense as it isn't a web procedure any more.
If I call my clarion source from the server code of my button, surely I'm back to square one, because I can't set my print procedure to have a target _blank.
I'm lost....
Regards,
Neil.
37
Web Server - Ask For Help / Re: Calling Multiple Print Routines from one form
« on: June 11, 2013, 05:43:59 AM »
Mike,
That's what I'd done to start with, and it does work until I have the situation where the report returns the alert "No Records Found" When that happens the alert doesn't display properly.
I'm wondering if I'm putting my my code in the wrong embed in the Source procedure?
My code is in the "before Div Header" embed.This is the only embed that I found that doesn't seem to try to format my call as HTML.
Regards,
Neil.
That's what I'd done to start with, and it does work until I have the situation where the report returns the alert "No Records Found" When that happens the alert doesn't display properly.
I'm wondering if I'm putting my my code in the wrong embed in the Source procedure?
My code is in the "before Div Header" embed.This is the only embed that I found that doesn't seem to try to format my call as HTML.
Regards,
Neil.
38
Web Server - Ask For Help / Re: Popup Lookup Browse - Best Practice
« on: June 11, 2013, 05:35:51 AM »
Hi Alexandr,
That works perfectly for me!
Thank you very much.
Regards,
Neil.
That works perfectly for me!
Thank you very much.
Regards,
Neil.
39
Web Server - Ask For Help / Re: Calling Multiple Print Routines from one form
« on: June 11, 2013, 02:26:32 AM »
Good idea Kevin, I hadn't tried that.
The rub is that I want to server the pdf that my report creates in a new tab, so i need to set the target to be '_blank'
I've tried the following code in the Server Code embed:
CASE p_web.GSV('MyLabelType')
OF '1'
PrintLabelType1(p_web)
OF '2'
PrintLabelType2(p_Web)
END
I've also tried calling
p_web.Windowopen('PrintLabelType1','_blank')
Which looks like the code generated by a standard button, but although I can see that my label routine is called, I don't get a pdf displayed to the browser.
Any thoughts?
Regards,
Neil.
The rub is that I want to server the pdf that my report creates in a new tab, so i need to set the target to be '_blank'
I've tried the following code in the Server Code embed:
CASE p_web.GSV('MyLabelType')
OF '1'
PrintLabelType1(p_web)
OF '2'
PrintLabelType2(p_Web)
END
I've also tried calling
p_web.Windowopen('PrintLabelType1','_blank')
Which looks like the code generated by a standard button, but although I can see that my label routine is called, I don't get a pdf displayed to the browser.
Any thoughts?
Regards,
Neil.
40
Web Server - Ask For Help / Calling Multiple Print Routines from one form
« on: June 10, 2013, 11:49:04 AM »
I have a NetWebFrom that depending quite a lot of different conditions needs to call one of many print routines.
The end user needs to see just one print button.
Originally I had lots of print buttons, and hide all but the relevant one using the standard hide condition on the button. The problem is, that these conditions have become so complex, that I've actually run out of room to type in the condition (or at least it's getting truncated when generated)
I decided that it would be easier (Maybe??) to have a single print button, that calls a NetWebSource procedure that has all of my conditional logic in it, which in turn calls the relevant print routine. It just about works, by embedding my code in the "Before Div Header" and then returning.
The only problem I have, is if I get an alert message from one of my reports saying nothing to print, then that message gets displayed as a bit of source code (or similar) in the browser window.
Is there a better way of doing this?
Regards,
Neil Porter
C8.9661 NT 6.51
The end user needs to see just one print button.
Originally I had lots of print buttons, and hide all but the relevant one using the standard hide condition on the button. The problem is, that these conditions have become so complex, that I've actually run out of room to type in the condition (or at least it's getting truncated when generated)
I decided that it would be easier (Maybe??) to have a single print button, that calls a NetWebSource procedure that has all of my conditional logic in it, which in turn calls the relevant print routine. It just about works, by embedding my code in the "Before Div Header" and then returning.
The only problem I have, is if I get an alert message from one of my reports saying nothing to print, then that message gets displayed as a bit of source code (or similar) in the browser window.
Is there a better way of doing this?
Regards,
Neil Porter
C8.9661 NT 6.51
41
Web Server - Ask For Help / Re: Popup Lookup Browse - Best Practice
« on: June 10, 2013, 11:36:29 AM »
OK Bruce, _Trace rather than Stop, it is from now on.
I like the idea of my own button to call the lookup, but that in itself raises it's own question. How do I call a browse in "Select" mode from my own button? If I don't call the popup as a select, my select button(s) don't appear. Am I better having my own select button on the lookup browse which isn't really a "Select" button, but is actually an "Other" button? If that is the case how do I ensure that my lookup browse closes and returns to the parent, with the currently selected record stored in the session queue, and where would I embed code in my parent form to update the form fields from my lookup (After Lookup, seems obvious???)
My SQL in the lookup browse seems to work well embedded just above the file loop as you suggested, thank you.
Sorry to bombard you with quite a few questions out of the blue. My NT webservers haven't had much attention for a while, and they are in need of a bit of love. I'm taking the opportunity to try and understand what you are doing under the hood, rather than just blindly using the templates.
Regards,
Neil.
I like the idea of my own button to call the lookup, but that in itself raises it's own question. How do I call a browse in "Select" mode from my own button? If I don't call the popup as a select, my select button(s) don't appear. Am I better having my own select button on the lookup browse which isn't really a "Select" button, but is actually an "Other" button? If that is the case how do I ensure that my lookup browse closes and returns to the parent, with the currently selected record stored in the session queue, and where would I embed code in my parent form to update the form fields from my lookup (After Lookup, seems obvious???)
My SQL in the lookup browse seems to work well embedded just above the file loop as you suggested, thank you.
Sorry to bombard you with quite a few questions out of the blue. My NT webservers haven't had much attention for a while, and they are in need of a bit of love. I'm taking the opportunity to try and understand what you are doing under the hood, rather than just blindly using the templates.
Regards,
Neil.
42
Web Server - Ask For Help / Re: Value Queue or Session Queue
« on: June 10, 2013, 11:23:48 AM »
Thanks Bruce,
That makes sense.
Regards,
Neil.
That makes sense.
Regards,
Neil.
43
Web Server - Ask For Help / Value Queue or Session Queue
« on: June 07, 2013, 01:18:43 PM »
I've been playing around with passing variables from one area of my program to another, and I always use Session variables.
I keep looking in the generated code, to try and get a better understanding of what Bruce is doing under the hood, and I notice that sometimes he uses Get/SetValue and other times he uses Get/SetSessionValue.
What is the real difference, and when is it appropriate to use each one?
Regards,
Neil.
I keep looking in the generated code, to try and get a better understanding of what Bruce is doing under the hood, and I notice that sometimes he uses Get/SetValue and other times he uses Get/SetSessionValue.
What is the real difference, and when is it appropriate to use each one?
Regards,
Neil.
44
Web Server - Ask For Help / Popup Lookup Browse - Best Practice
« on: June 07, 2013, 01:14:14 PM »
I'm trying to do something slightly out of the ordinary with a lookup, and I'm getting some strange results. I've spent so much time trying different things now, that I've got myself all confused, so I thought I'd post here to check that I'm not going about it all wrong.
I have a number of forms where the user has to populate a postal address (Addr1, addr2 , town, postal code, etc.). I would like to allow the user to enter certain known bits of the address, and then press a lookup button. I would then like to display a browse with various address lines that match the keyed criteria, that they could select, which would populate on the original form.
I would like to fill my lookup browse manually, using an SQL query or some address lookup software and a temporary table filtered by session ID. The idea being that I can run an sql query to see if they've ever used the address before, in which case use it, or failing that, use the address lookup software to give them some options. Once the lookup has completed, I can clear down the temporary table.
I've sort of got this working, by attaching a lookup button to one of the fields on the form (postcode/zipcode), but after selecting my record from the lookup browse, I get random text appearing in the original form field. I'm also not convinced that I'm managing to pass the key entered data to my lookup correctly for my SQL query. Using Stop messages, my sqlquery seems to be firing at some funny times, without it having any data to use for the where clause.
I've also noticed that the lookup seems to behave differently if I have it as a popup. In popup mode one field in the form gets populated from the lookup. If not in popup mode, all of the other address fields get populated too (Which is what I want).
So my questions are:
1) Do I use a lookup button attached to one of the fields on my form, or should I create a separate button to call my lookup?
2) How do I make sure that all of my address variables on my form are passed to the lookup browse, and how to I get them back again (the FileToSessionQueue doesn't seem to work in this case)
3) Which Embed should I use to call my SQL in the Lookup browse? I've tried "Start of Procedure" and "Call Browse" so far.
Any suggestions would be very welcome.
Regards,
Neil.
I have a number of forms where the user has to populate a postal address (Addr1, addr2 , town, postal code, etc.). I would like to allow the user to enter certain known bits of the address, and then press a lookup button. I would then like to display a browse with various address lines that match the keyed criteria, that they could select, which would populate on the original form.
I would like to fill my lookup browse manually, using an SQL query or some address lookup software and a temporary table filtered by session ID. The idea being that I can run an sql query to see if they've ever used the address before, in which case use it, or failing that, use the address lookup software to give them some options. Once the lookup has completed, I can clear down the temporary table.
I've sort of got this working, by attaching a lookup button to one of the fields on the form (postcode/zipcode), but after selecting my record from the lookup browse, I get random text appearing in the original form field. I'm also not convinced that I'm managing to pass the key entered data to my lookup correctly for my SQL query. Using Stop messages, my sqlquery seems to be firing at some funny times, without it having any data to use for the where clause.
I've also noticed that the lookup seems to behave differently if I have it as a popup. In popup mode one field in the form gets populated from the lookup. If not in popup mode, all of the other address fields get populated too (Which is what I want).
So my questions are:
1) Do I use a lookup button attached to one of the fields on my form, or should I create a separate button to call my lookup?
2) How do I make sure that all of my address variables on my form are passed to the lookup browse, and how to I get them back again (the FileToSessionQueue doesn't seem to work in this case)
3) Which Embed should I use to call my SQL in the Lookup browse? I've tried "Start of Procedure" and "Call Browse" so far.
Any suggestions would be very welcome.
Regards,
Neil.
45
Web Server - Ask For Help / Re: Viewing Performance Monitor Stats in a NetWebForm
« on: June 04, 2013, 12:55:52 AM »
Thanks Bruce.
Just in case anyone else is reading this thread, example 59 has a NetwebForm called Perfromance, that displays the performance stats.
I never use the Multi-site Host so I've never noticed the error logging or extra info that can be displayed.
Regards,
Neil.
Just in case anyone else is reading this thread, example 59 has a NetwebForm called Perfromance, that displays the performance stats.
I never use the Multi-site Host so I've never noticed the error logging or extra info that can be displayed.
Regards,
Neil.