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.
10996
Web Server - Ask For Help / Re: Entry not found error
« on: July 04, 2007, 11:41:06 PM »
Hi Steve,
Cunningly that's pretty much the only "normal" stop you'll see in the program. It's important, during development, to see it, and it should never appear (if you do things right) after deployment.
Ok, so what does it mean?
Typically it means you've called a form, and the parameters for the form are incomplete. My _guess_ is that you're calling the form from a browse. If so the "unique unchanging key" used on the browse must match the "unique unchanging key" used by the form.
If you are following FAQ #4, and calling the form from somewhere else, then you need to pass, as parameters, the values of the key fields to identify the record you are gonna load.
Cheers
Bruce
Cunningly that's pretty much the only "normal" stop you'll see in the program. It's important, during development, to see it, and it should never appear (if you do things right) after deployment.
Ok, so what does it mean?
Typically it means you've called a form, and the parameters for the form are incomplete. My _guess_ is that you're calling the form from a browse. If so the "unique unchanging key" used on the browse must match the "unique unchanging key" used by the form.
If you are following FAQ #4, and calling the form from somewhere else, then you need to pass, as parameters, the values of the key fields to identify the record you are gonna load.
Cheers
Bruce
10997
Web Server - Ask For Help / Re: Right Justify a Dollar Amt Issue
« on: July 04, 2007, 01:41:06 AM »
Browse or Form?
10998
Web Server - Share Knowledge / Re: Advanced Searching with NetWeb Server
« on: July 02, 2007, 07:44:35 AM »
Hi John,
It turns out this is not, um, exactly trivial.
Forms call lookups, but lookups are normally browses, not other forms.
There's a bunch of code that will need to be tweaked to allow a form to be called as a lookup.
I'll keep you posted.
Cheers
Bruce
It turns out this is not, um, exactly trivial.
Forms call lookups, but lookups are normally browses, not other forms.
There's a bunch of code that will need to be tweaked to allow a form to be called as a lookup.
I'll keep you posted.
Cheers
Bruce
10999
Web Server - Ask For Help / Re: Manually control child browse
« on: July 01, 2007, 07:34:56 AM »
Hi Chris
nope, the browse can't do anything when the "row is clicked". Well it can, but that's a complicated way to do it.
Rather work with what you _do_ know. When the form is called, add code to the .InitForm method. At this point you know the value of the "Browse Record" so presumably you can work from there.
This probably means;
a) opening the _Browse_ table.
b) Using the Unique ID (which is in the Value Queue) to load the specific record and then
c) doing what you need to do to prime the form
Cheers
Bruce
nope, the browse can't do anything when the "row is clicked". Well it can, but that's a complicated way to do it.
Rather work with what you _do_ know. When the form is called, add code to the .InitForm method. At this point you know the value of the "Browse Record" so presumably you can work from there.
This probably means;
a) opening the _Browse_ table.
b) Using the Unique ID (which is in the Value Queue) to load the specific record and then
c) doing what you need to do to prime the form
Cheers
Bruce
11000
Web Server - Ask For Help / Re: FORM for INSERT only - how to call such from a normal webpage?
« on: July 01, 2007, 07:32:01 AM »
Hi Wolfgang,
The easiest is to form the URL correctly. See FAQ #4 for how to do this.
Alternativly you can add code to the .InitForm method. The idea here would be to use p_Web.SetValue to "set" the parameters missing from the URL. It'd work, but in this case only because the form is _always_ called in Insert mode.
Cheers
Bruce
The easiest is to form the URL correctly. See FAQ #4 for how to do this.
Alternativly you can add code to the .InitForm method. The idea here would be to use p_Web.SetValue to "set" the parameters missing from the URL. It'd work, but in this case only because the form is _always_ called in Insert mode.
Cheers
Bruce
11001
Web Server - Ask For Help / Re: Session Variable Question
« on: June 27, 2007, 11:28:26 PM »
Hi Kevin,
I'm not the SQL expert, so any others that want to comment, please feel free.
The short answer is that, for SQL, you'd set the "owner" string for each table in the same place.
As I understand it, Clarion doesn't like being connected to 2 different databases at the same time. But I'm a little fuzzy on this bit.
If that is the case then I would suggest using variable table names, and so keeping the data all in one "database" but in separate "tables".
cheers
Bruce
I'm not the SQL expert, so any others that want to comment, please feel free.
The short answer is that, for SQL, you'd set the "owner" string for each table in the same place.
As I understand it, Clarion doesn't like being connected to 2 different databases at the same time. But I'm a little fuzzy on this bit.
If that is the case then I would suggest using variable table names, and so keeping the data all in one "database" but in separate "tables".
cheers
Bruce
11002
Web Server - Share Knowledge / Temporary Files start with $$$
« on: June 26, 2007, 01:27:58 AM »
Hi all,
TIP: If you are generating a temp file, that is created, sent to the browser, and then needs to be deleted (in other words it will only be served _once_) then start the name with $$$. eg
temp\$$$N1234.png
The web server will automatically delete files that start with $$$ as soon as they are served.
This technique is used by the graphing template and the report tempate, so you'll notice that the PDF files generated and the PNG files generated by these templates both start with $$$.
Cheers
Bruce
TIP: If you are generating a temp file, that is created, sent to the browser, and then needs to be deleted (in other words it will only be served _once_) then start the name with $$$. eg
temp\$$$N1234.png
The web server will automatically delete files that start with $$$ as soon as they are served.
This technique is used by the graphing template and the report tempate, so you'll notice that the PDF files generated and the PNG files generated by these templates both start with $$$.
Cheers
Bruce
11003
Web Server - Ask For Help / Re: Session Variable Question
« on: June 26, 2007, 12:59:38 AM »
Hi Alan,
As long as the variables are THREADED you can use them. Because basically that means that at the start of each thread they are set, and exist (and are "local") for the life of that thread.
So (a) make sure they're threaded.
Then (b)
In WebHandler procedure
.ProcessLink method
Before parent call
GLO:FileName_CUS = p_web.GetSessionValue('userpath') & '\Customer'
Where "userpath" is something you set when the user originally logged in.
cheers
Bruce
As long as the variables are THREADED you can use them. Because basically that means that at the start of each thread they are set, and exist (and are "local") for the life of that thread.
So (a) make sure they're threaded.
Then (b)
In WebHandler procedure
.ProcessLink method
Before parent call
GLO:FileName_CUS = p_web.GetSessionValue('userpath') & '\Customer'
Where "userpath" is something you set when the user originally logged in.
cheers
Bruce
11004
Web Server - Ask For Help / Re: Cell phone browsers
« on: June 26, 2007, 12:55:46 AM »
Hi John,
If you watch the server side screen, and you clear the log (so it's easy to spot) - does anything happen when the cell user clicks the login button?
Cheers
Bruce
If you watch the server side screen, and you clear the log (so it's easy to spot) - does anything happen when the cell user clicks the login button?
Cheers
Bruce
11005
Web Server - Ask For Help / Re: How do I refresh NetWebPage
« on: June 26, 2007, 12:54:40 AM »
Hi Alan,
why do you need to refresh the "form" part of the page?
is that gonna change? Perhaps you just need to refresh the "browse" part?
cheers
Bruce
why do you need to refresh the "form" part of the page?
is that gonna change? Perhaps you just need to refresh the "browse" part?
cheers
Bruce
11006
Web Server - Ask For Help / Re: IE6 and png Images
« on: June 25, 2007, 12:49:49 AM »
Hi Kevin,
IE 6 does have some problems with PNG's.
In the short term there's not an awful lot you can do about it. There is some code in NetTalk that can help (in some cases) but it doesn't work if the image is "hidden" as the page opens.
One option is to not use PNG, but use GIF - but of course GIF has only "hard" transparencies, and has a limited palette.
On the up side, IE 7 is an "automatic upgrade" for IE 6, so IE 6 folks should be encouraged to use it. Apart from anything else it's more secure.
Cheers
Bruce
IE 6 does have some problems with PNG's.
In the short term there's not an awful lot you can do about it. There is some code in NetTalk that can help (in some cases) but it doesn't work if the image is "hidden" as the page opens.
One option is to not use PNG, but use GIF - but of course GIF has only "hard" transparencies, and has a limited palette.
On the up side, IE 7 is an "automatic upgrade" for IE 6, so IE 6 folks should be encouraged to use it. Apart from anything else it's more secure.
Cheers
Bruce
11007
Web Server - Share Knowledge / Re: Licensing and javascripts
« on: June 25, 2007, 12:44:16 AM »
Mozilla and BSD are great.
So is "public domain".
LGPL should be fine.
GPL is not so good. (As it would make your whole clarion app open source)
Bottom line - if in doubt write to the authors and ask. There are a couple DHTMLGoodies things in NetTalk, I wrote to them and they gave permission for us to use it.
cheers
Bruce
So is "public domain".
LGPL should be fine.
GPL is not so good. (As it would make your whole clarion app open source)
Bottom line - if in doubt write to the authors and ask. There are a couple DHTMLGoodies things in NetTalk, I wrote to them and they gave permission for us to use it.
cheers
Bruce
11008
The Rest - Ask For Help / Re: MOdifying StyleS
« on: June 25, 2007, 12:39:25 AM »
Hi Nick,
Further to what John said, if you haven't already check out FireBug (in firefox go to www.getfirebug.com and install firebug from there.)
This allows you to "inspect" your site at runtime, and make changes on the fly to the styles to see the effect. It doesn't save the style, but it's easy to move your changes back to the CSS when you're done.
I'm planning a doc on changing CSS in the not too distant future.
Cheers
Bruce
Further to what John said, if you haven't already check out FireBug (in firefox go to www.getfirebug.com and install firebug from there.)
This allows you to "inspect" your site at runtime, and make changes on the fly to the styles to see the effect. It doesn't save the style, but it's easy to move your changes back to the CSS when you're done.
I'm planning a doc on changing CSS in the not too distant future.
Cheers
Bruce
11009
News And Views / NetTalk 4.26 released
« on: June 21, 2007, 10:48:32 PM »
Hi All,
NetTalk 4.26 has been released.
Download your update from
http://www.capesoft.com/accessories/downloads.htm#nettalk
New documentation index can be found here
http://www.capesoft.com/docs/NetTalk/NetTalkWebFAQ.htm
Release notes:
# NOTE: the latest Web folder is installed to \clarion6\3rdparty\libsrc\netweb
Copy this to your application folder after installing the NetTalk update.
# Add: Support for Legacy report procedures, and (I think) CPCS report procedures. See example.
# Add: Forms now have a variable, loc:act which is set to either InsertRecord, ChangeRecord or DeleteRecord. Expressions can use this to determine current form action.
# Add: Ability to override CSS class for Prompt and Comment for individual form fields.
# Change: Made blank tab headings more visible in list of tabs.
# Change: .SetSessionPics, and .SetPics methods have been retired. Replaced with SetPics routine in form.
# Add: Translation for the "Locate" prompt can be set in WebServer procedure, Advanced tab.
# Add: Embed point into menu routine.
# Add: New Short-hand method names, GSV and SSV for GetSessionValue and SetSessionValue respectively. Use either short, or long form.
# Add: GetSessionValueLength method to return length of Session Value.
# Add: GetValueLength method to return length of parameter in Value queue.
# Add: New examples, 38 (Legacy) and 39 (LegacyReports) added.
# Update: Chrome menu script updated to version 2.01
# Reorganised docs a bit.
# Fix: Could generate code for "SmallOtherButton"
# Fix: "highlighted record" problem when Last or Previous pushed.
# Fix: Values getting dropped when a lookup is done.
# Fix: DATE and TIME data types were being treated as Alpha, not Numeric.
# Fix: For time fields that were > 12:00, but didn't include am or pm.
# Fix: Handled empty packets (with just a header) sent from a NetWebPage. Typically when sending a PDF or other static file from a NetWebPage.
** Those Who attended the World Tour, and added code to work around this issue can now remove the work around code **
Cheers
Bruce
NetTalk 4.26 has been released.
Download your update from
http://www.capesoft.com/accessories/downloads.htm#nettalk
New documentation index can be found here
http://www.capesoft.com/docs/NetTalk/NetTalkWebFAQ.htm
Release notes:
# NOTE: the latest Web folder is installed to \clarion6\3rdparty\libsrc\netweb
Copy this to your application folder after installing the NetTalk update.
# Add: Support for Legacy report procedures, and (I think) CPCS report procedures. See example.
# Add: Forms now have a variable, loc:act which is set to either InsertRecord, ChangeRecord or DeleteRecord. Expressions can use this to determine current form action.
# Add: Ability to override CSS class for Prompt and Comment for individual form fields.
# Change: Made blank tab headings more visible in list of tabs.
# Change: .SetSessionPics, and .SetPics methods have been retired. Replaced with SetPics routine in form.
# Add: Translation for the "Locate" prompt can be set in WebServer procedure, Advanced tab.
# Add: Embed point into menu routine.
# Add: New Short-hand method names, GSV and SSV for GetSessionValue and SetSessionValue respectively. Use either short, or long form.
# Add: GetSessionValueLength method to return length of Session Value.
# Add: GetValueLength method to return length of parameter in Value queue.
# Add: New examples, 38 (Legacy) and 39 (LegacyReports) added.
# Update: Chrome menu script updated to version 2.01
# Reorganised docs a bit.
# Fix: Could generate code for "SmallOtherButton"
# Fix: "highlighted record" problem when Last or Previous pushed.
# Fix: Values getting dropped when a lookup is done.
# Fix: DATE and TIME data types were being treated as Alpha, not Numeric.
# Fix: For time fields that were > 12:00, but didn't include am or pm.
# Fix: Handled empty packets (with just a header) sent from a NetWebPage. Typically when sending a PDF or other static file from a NetWebPage.
** Those Who attended the World Tour, and added code to work around this issue can now remove the work around code **
Cheers
Bruce
11010
Web Server - Ask For Help / Re: Multiple selects from 1 button
« on: June 21, 2007, 10:29:46 PM »
Hi Chris,
>> I have a droplist with three items (account type) and depending on which option is selected in the drop list I need to use a different select screen for another field (account number) as their are 3 possible source tables for the same number, depending on type.
Set the URL for the lookup to be a session variable. ie instead of
'browseAccounts' use p_web.GetSessionValue('lookupAccounts')
Then when the drop list changes change the value in LookupAccounts AND remember to "reset" the Account Number form field.
>> Also I need to make validation on entry and display the correct description. I assume I can just say send new value to server on the drop list and the correct value for account type is stored in the session queue for me to use.
yes.
Cheers
Bruce
>> I have a droplist with three items (account type) and depending on which option is selected in the drop list I need to use a different select screen for another field (account number) as their are 3 possible source tables for the same number, depending on type.
Set the URL for the lookup to be a session variable. ie instead of
'browseAccounts' use p_web.GetSessionValue('lookupAccounts')
Then when the drop list changes change the value in LookupAccounts AND remember to "reset" the Account Number form field.
>> Also I need to make validation on entry and display the correct description. I assume I can just say send new value to server on the drop list and the correct value for account type is stored in the session queue for me to use.
yes.
Cheers
Bruce