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: Best embed to fill IMMD table for NetWeb Browse?
« on: May 01, 2014, 01:43:15 AM »
Hi Bruce,
The table is in my dictionary, and hence I am doing a normal browse, but i'm using an SQL query to add rows to this table.
I was really asking for the correct place to call my SQL Query.
Regards,
Neil.
The table is in my dictionary, and hence I am doing a normal browse, but i'm using an SQL query to add rows to this table.
I was really asking for the correct place to call my SQL Query.
Regards,
Neil.
17
Web Server - Ask For Help / Best embed to fill IMMD table for NetWeb Browse?
« on: April 30, 2014, 03:01:53 AM »
I use an SQL backend, so I quite often use a temporary table issue an SQL query on the fly, and then display the results on screen.
With the advent in NT8 and the export button, my users are getting very excited about being able to download all sorts or data, and I can see that I'm going to be generating lots of netweb browses like this so I just wanted to make sure that I'm doing things "Correctly"
I quite often embed my browse within a form, to allow my users to set a date range, and other filters, so I tend to remove the existing contents of my temporary file, and re-populate it in the Refresh::MyBrowseDetails Routine in the form.
This seems to work OK, but I'm wondering if there is an embed point within the Browse procedure itself that I could utilise so that it doesn't matter where my browse gets called from, it will always populate the data.
There look to be quite a few candidate embeds, but I wondered if anyone could point me in the right direction?
Regards,
Neil.
With the advent in NT8 and the export button, my users are getting very excited about being able to download all sorts or data, and I can see that I'm going to be generating lots of netweb browses like this so I just wanted to make sure that I'm doing things "Correctly"
I quite often embed my browse within a form, to allow my users to set a date range, and other filters, so I tend to remove the existing contents of my temporary file, and re-populate it in the Refresh::MyBrowseDetails Routine in the form.
This seems to work OK, but I'm wondering if there is an embed point within the Browse procedure itself that I could utilise so that it doesn't matter where my browse gets called from, it will always populate the data.
There look to be quite a few candidate embeds, but I wondered if anyone could point me in the right direction?
Regards,
Neil.
18
Web Server - Ask For Help / Export Data being Truncated to 50 Chars
« on: April 30, 2014, 02:44:29 AM »
I'm using the new Export button feature, which is great, but I have quite a long address field that I need to export, and it is being truncated to 50 chars in the export xml file.
Is there a setting that I'm missing?
Not sure if it makes any difference, but this is a display field that is made up of several other fields concatenated together.
Regards,
Neil.
Is there a setting that I'm missing?
Not sure if it makes any difference, but this is a display field that is made up of several other fields concatenated together.
Regards,
Neil.
19
Web Server - Ask For Help / Re: Barcode Scanning ...
« on: April 16, 2014, 01:37:31 AM »
I did try something similar with a Motorola ES400, which also had a built in barcode data wedge.
The problem that I found was that the browser for Windows Mobile 5 / CE was so poor, I couldn't get my nettalk web server to work well on the device. (I was using NT6 at the time)
In the end, I wrote a native app for the device using Windev Mobile, and then I use my NetWebserver as a SOAP/Webservice to send and receive data from the device.
This works much better, but obviously requires more development work for you.
Regards,
Neil
The problem that I found was that the browser for Windows Mobile 5 / CE was so poor, I couldn't get my nettalk web server to work well on the device. (I was using NT6 at the time)
In the end, I wrote a native app for the device using Windev Mobile, and then I use my NetWebserver as a SOAP/Webservice to send and receive data from the device.
This works much better, but obviously requires more development work for you.
Regards,
Neil
20
Web Server - Ask For Help / Re: Help with Form / Browse Layout
« on: April 16, 2014, 01:32:03 AM »
OK Bruce,
Well at least I wasn't being dull
I just want to call a print routine so that my user has the option to either print the browse to a PDF, or Export the contents of the browse to excel, so I'll go back to the buttons example, and see if I can add a custom button to the bottom of the browse to call my print routine.
Regards,
Neil.
Well at least I wasn't being dull
I just want to call a print routine so that my user has the option to either print the browse to a PDF, or Export the contents of the browse to excel, so I'll go back to the buttons example, and see if I can add a custom button to the bottom of the browse to call my print routine.
Regards,
Neil.
21
Web Server - Ask For Help / Re: Help with Form / Browse Layout
« on: April 16, 2014, 12:53:16 AM »
Hi Bruce,
Thanks for the input on the Prompt issue. I'll experiment.
With regard to my Print Button, is there no way I can "Activate" the Print button on the Browse, rather than having to add a print button onto the form? There is a print button listed along with Insert, Change, Copy, Export, etc. but I can never get it to display at the bottom of a browse
Regards,
Neil.
Thanks for the input on the Prompt issue. I'll experiment.
With regard to my Print Button, is there no way I can "Activate" the Print button on the Browse, rather than having to add a print button onto the form? There is a print button listed along with Insert, Change, Copy, Export, etc. but I can never get it to display at the bottom of a browse
Regards,
Neil.
22
Web Server - Ask For Help / Help with Form / Browse Layout
« on: April 15, 2014, 04:19:34 AM »
I have created a netwebform with a newwebbrowse and a date range embedded within it. (See attached screen grab)
I have 2 issues with the layout that I don't like, and I wonder if someone can help me out.
1) the date range at the top. If I tick to span Prompt/value/comment my values don't align. If I don't tick to span, the fields get spread out across the screen because my browse is so wide.
2) I'd like to have my print button next to the Export button. There is an option in the Browse, Form tab that mentions a print button, but I can't get it to display. The print button that shows on the screen grab is actually populated on my form.
As an aside, I'd also like to be able to combine the delivery address lines into 1 column, but that's in a separate post.
Any advice would be very welcome,
Regards,
Neil.
[attachment deleted by admin]
I have 2 issues with the layout that I don't like, and I wonder if someone can help me out.
1) the date range at the top. If I tick to span Prompt/value/comment my values don't align. If I don't tick to span, the fields get spread out across the screen because my browse is so wide.
2) I'd like to have my print button next to the Export button. There is an option in the Browse, Form tab that mentions a print button, but I can't get it to display. The print button that shows on the screen grab is actually populated on my form.
As an aside, I'd also like to be able to combine the delivery address lines into 1 column, but that's in a separate post.
Any advice would be very welcome,
Regards,
Neil.
[attachment deleted by admin]
23
Web Server - Ask For Help / Can I combine 4 address fields into 1 browse column?
« on: April 15, 2014, 02:14:45 AM »
I have a browse where I display an order date, order no, product code etc. and 4 address lines.
My browse is starting to get a little wide, so I thought that it might be cool to try and combine my 4 address lines into a single column.
I've found example 50, which seems to allow me to span columns, but I don't think that's what I'm trying to do really.
Is there another example that I'm missing, or can someone point me in the correct direction please.
Regards,
Neil.
My browse is starting to get a little wide, so I thought that it might be cool to try and combine my 4 address lines into a single column.
I've found example 50, which seems to allow me to span columns, but I don't think that's what I'm trying to do really.
Is there another example that I'm missing, or can someone point me in the correct direction please.
Regards,
Neil.
24
Web Server - Ask For Help / Re: Example Web42 broken in NT8?
« on: March 24, 2014, 08:37:21 AM »
I admit, I did forget it initially,
but the compiler warning helped me out there.
String Theory version 2.04 was added, and I still get the error.
Regards,
Neil.
but the compiler warning helped me out there.
String Theory version 2.04 was added, and I still get the error.
Regards,
Neil.
25
Web Server - Ask For Help / Re: Example Web42 broken in NT8?
« on: March 24, 2014, 08:23:03 AM »
Hi Bruce,
I'm running NT 8.02
I'm afraid your suggestion didn't work.
I'm not sure if the attached screen shot gives you any pointers.
Regards,
Neil.
[attachment deleted by admin]
I'm running NT 8.02
I'm afraid your suggestion didn't work.
I'm not sure if the attached screen shot gives you any pointers.
Regards,
Neil.
[attachment deleted by admin]
26
Web Server - Ask For Help / Example Web42 broken in NT8?
« on: March 24, 2014, 06:23:57 AM »
I've just tried to convert one of my smaller NT6 apps to NT8 just to dip a toe into the water.
The app is a effectively a small soap server.
The app keeps crashing when it tries to serve xml files.
The code in question is this:
! finally send result
p_web.ParseHTML(Xml.XmlData,1,Xml.XmlDataLen,Net:NoHeader)
I understand that ParseHTML is now expecting to be passed a StringTheory object so i've changed the code to be:
Packet.append(xml.XmlData)
p_web.ParseHTML(packet,1,0,Net:NoHeader)
The packet.append statement now crashes
I'm seeing this in Example 42 as well, and wondered if anyone else is seeing this, or has found a work around?
Regards,
Neil.
The app is a effectively a small soap server.
The app keeps crashing when it tries to serve xml files.
The code in question is this:
! finally send result
p_web.ParseHTML(Xml.XmlData,1,Xml.XmlDataLen,Net:NoHeader)
I understand that ParseHTML is now expecting to be passed a StringTheory object so i've changed the code to be:
Packet.append(xml.XmlData)
p_web.ParseHTML(packet,1,0,Net:NoHeader)
The packet.append statement now crashes
I'm seeing this in Example 42 as well, and wondered if anyone else is seeing this, or has found a work around?
Regards,
Neil.
27
Web Server - Ask For Help / Secwin and NTWS. Your opinion?
« on: February 18, 2014, 05:43:09 AM »
Is anyone using Secwin Access control successfully in a live environment?
I have one application that I have deployed using an MSSQL backend, and the In-Memory driver for the Secwin tables that are imported into the dictionary.
I'm a huge fan of the NTWS and I desperately want the Secwin integration to work, but I'm seeing all sorts of pretty random things happening. It seems to me as though changes that are being made to users, and permissions, just aren't reliably being saved. I can tick a few boxes to set access permissions, or even to assign a user to a group, and the next time I go back into that screen, those changes are lost, or worse, a different tick box to the one I selected is checked.
A week ago my users suddenly reported that they couldn't log into the system. Neither could I, even with the original default user. I couldn't reset passwords or anything. The only way I could get back into the system was to recover all of the sec win tables from a previous days backup.
Currently, I'm running with NT 6.51 and Secwin 6.27, so I can see there are some updates out there, but it's hard to find out if they will help in this case because the NT 6 history stops at version 6.47.
I'm thinking it's about time that I supported all of Bruce's hard work, and upgraded to NT 7 or even NT8 now, but I do need some form of reliable access control, and it would make me feel a lot happier if I knew there were other people out there that have managed to get it all working reliably, particularly with the MSSQL backend.
Regards,
Neil.
I have one application that I have deployed using an MSSQL backend, and the In-Memory driver for the Secwin tables that are imported into the dictionary.
I'm a huge fan of the NTWS and I desperately want the Secwin integration to work, but I'm seeing all sorts of pretty random things happening. It seems to me as though changes that are being made to users, and permissions, just aren't reliably being saved. I can tick a few boxes to set access permissions, or even to assign a user to a group, and the next time I go back into that screen, those changes are lost, or worse, a different tick box to the one I selected is checked.
A week ago my users suddenly reported that they couldn't log into the system. Neither could I, even with the original default user. I couldn't reset passwords or anything. The only way I could get back into the system was to recover all of the sec win tables from a previous days backup.
Currently, I'm running with NT 6.51 and Secwin 6.27, so I can see there are some updates out there, but it's hard to find out if they will help in this case because the NT 6 history stops at version 6.47.
I'm thinking it's about time that I supported all of Bruce's hard work, and upgraded to NT 7 or even NT8 now, but I do need some form of reliable access control, and it would make me feel a lot happier if I knew there were other people out there that have managed to get it all working reliably, particularly with the MSSQL backend.
Regards,
Neil.
28
Web Server - Ask For Help / SSL - Any advice or gotchas?
« on: December 02, 2013, 03:31:04 AM »
I've just been asked by one of my customers to convert an existing NTWS webserver to use an SSL certificate.
They would like me to obtain the certificate for the site on their behalf.
Is there anything I should be aware of before I dive into this?
I've found an article by Bruce about "Levels of SSL" which looked quite informative, and there is a whole section in the docs about "building secure sites". I'm hoping that it will be as simple as following the steps suggested by Bruce, but whilst I'm familiar with Code signing my own applications, I've never done anything with SSL, and wondered if there was anything that was likely to bite me?
I have used Comodo for my own code signing certificates, but I don't have a strong preference for SSL, as I won't be paying for it
Regards,
Neil.
They would like me to obtain the certificate for the site on their behalf.
Is there anything I should be aware of before I dive into this?
I've found an article by Bruce about "Levels of SSL" which looked quite informative, and there is a whole section in the docs about "building secure sites". I'm hoping that it will be as simple as following the steps suggested by Bruce, but whilst I'm familiar with Code signing my own applications, I've never done anything with SSL, and wondered if there was anything that was likely to bite me?
I have used Comodo for my own code signing certificates, but I don't have a strong preference for SSL, as I won't be paying for it
Regards,
Neil.
29
Web Server - Ask For Help / Re: NT Template 6.54, but NT Object reports 6.52
« on: October 23, 2013, 11:02:24 AM »
Hi Bruce,
Sorry I've been so long coming back to you on this, I've had to have a few days away from the office.
I've checked my accessory folder and you are correct. My netall.inc (dated 24/04/2013) had the 6.52 equate in it, so I renamed the inc file just to be sure, and reran the 6.54 installer. No path or permissions issues, as I got a brand new netall.inc with the 6.52 equate still in there!!
Now I can certainly change the equate to make my web folder warning message go away, but am I working with a dodgy install that is going to bite me later??
As it's only small, I've attached the .inc file just in case you wanted to take a look.
Regards,
Neil.
[attachment deleted by admin]
Sorry I've been so long coming back to you on this, I've had to have a few days away from the office.
I've checked my accessory folder and you are correct. My netall.inc (dated 24/04/2013) had the 6.52 equate in it, so I renamed the inc file just to be sure, and reran the 6.54 installer. No path or permissions issues, as I got a brand new netall.inc with the 6.52 equate still in there!!
Now I can certainly change the equate to make my web folder warning message go away, but am I working with a dodgy install that is going to bite me later??
As it's only small, I've attached the .inc file just in case you wanted to take a look.
Regards,
Neil.
[attachment deleted by admin]
30
Web Server - Ask For Help / Re: NT Template 6.54, but NT Object reports 6.52
« on: October 15, 2013, 06:31:35 AM »
Hi Bruce,
I took a brand new web folder out of the libsrc netweb folder: just done it again to be sure, and still get the following:
<!DOCTYPE html><html class="nt-html no-js">
<head><title>Welcome</title><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="/themes/redmond/theme.css" rel="stylesheet" />
<link href="/styles/chrome.css" rel="stylesheet" />
<script src="/scripts/all.js" type="text/javascript"></script>
</head>
<body class="nt-body">
<div class="nt-body-div">
<div id="pageheadertag_div" class="nt-site-header-6 ui-widget-header ui-corner-top" data-role="header"><table class="headingtable"
<tr><td width="10%"><img border="0" src="images/logo.png" /></td>
<td width="90%"><div class="nt-center-justify"><h1>Phillips Opticians - Stock Control System</h1></div></td>
</tr>
</table>
<div id="menu_div" class="nt-menu-div ui-corner-br"><ul id="menu" class="nt-menu"><li><a href="IndexPage">Home</a><ul class="nt-menu-item"></ul></li><li><a href="#">User</a><ul class="nt-menu-item"><li><a href="SecwinWebLoginForm">Login</a></li></ul></li></ul></div>
<script defer="defer">
jQuery(function() {jQuery("#menu").dropDownMenu();});
</script>
</div>
<div id="_busy" class="nt-busy" data-nt-busy="busy"><img src="/images/_busy.gif" /></div><div id="_ver652" class="nt-alert ui-state-error ui-corner-all">Error in site JavaScript</div><script>versionCheck('6.52');getScreenSize()</script>
<div id="alert_div" class="nt-width-99 nt-alert ui-state-error ui-corner-all ui-helper-hidden"></div>
<br />
Welcome<br /><br />
<div id="pagefootertag_div" class="nt-left nt-width-100 nt-site-footer" data-role="footer">
<div>Copyright Neil Porter Associates Ltd 2013 - Version:1.1.5.1</div>
</div>
</div></body>
</html>
As you can see the version check comes back with 6.52
I've just gone back to check what version of the template I was using in C8 and that was 6.51, so it isn't something left hanging around by the conversion to C9
I took a brand new web folder out of the libsrc netweb folder: just done it again to be sure, and still get the following:
<!DOCTYPE html><html class="nt-html no-js">
<head><title>Welcome</title><meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="/themes/redmond/theme.css" rel="stylesheet" />
<link href="/styles/chrome.css" rel="stylesheet" />
<script src="/scripts/all.js" type="text/javascript"></script>
</head>
<body class="nt-body">
<div class="nt-body-div">
<div id="pageheadertag_div" class="nt-site-header-6 ui-widget-header ui-corner-top" data-role="header"><table class="headingtable"
<tr><td width="10%"><img border="0" src="images/logo.png" /></td>
<td width="90%"><div class="nt-center-justify"><h1>Phillips Opticians - Stock Control System</h1></div></td>
</tr>
</table>
<div id="menu_div" class="nt-menu-div ui-corner-br"><ul id="menu" class="nt-menu"><li><a href="IndexPage">Home</a><ul class="nt-menu-item"></ul></li><li><a href="#">User</a><ul class="nt-menu-item"><li><a href="SecwinWebLoginForm">Login</a></li></ul></li></ul></div>
<script defer="defer">
jQuery(function() {jQuery("#menu").dropDownMenu();});
</script>
</div>
<div id="_busy" class="nt-busy" data-nt-busy="busy"><img src="/images/_busy.gif" /></div><div id="_ver652" class="nt-alert ui-state-error ui-corner-all">Error in site JavaScript</div><script>versionCheck('6.52');getScreenSize()</script>
<div id="alert_div" class="nt-width-99 nt-alert ui-state-error ui-corner-all ui-helper-hidden"></div>
<br />
Welcome<br /><br />
<div id="pagefootertag_div" class="nt-left nt-width-100 nt-site-footer" data-role="footer">
<div>Copyright Neil Porter Associates Ltd 2013 - Version:1.1.5.1</div>
</div>
</div></body>
</html>
As you can see the version check comes back with 6.52
I've just gone back to check what version of the template I was using in C8 and that was 6.51, so it isn't something left hanging around by the conversion to C9