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 / Re: Coding a date field to be a particular day date
« on: March 19, 2025, 01:27:18 AM »
You should be aware that FORMAT returns a string and not a date.
A date in Clarion is represented as number of days elapsed since December 28, 1800.
What you are trying will not work.
You should remove FORMAT from your import and only use it when data is to be displayed on the screen or in a report (or exported in a csv file)
A date in Clarion is represented as number of days elapsed since December 28, 1800.
What you are trying will not work.
You should remove FORMAT from your import and only use it when data is to be displayed on the screen or in a report (or exported in a csv file)
2
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« on: March 18, 2025, 11:19:20 PM »
format(DATE(MONTH(OriginalDate),1,YEAR(OriginalDate)),@D06)
3
Web Server - Ask For Help / Re: Button on header
« on: March 18, 2025, 10:53:22 PM »
Thanks Bruce,
it works fine when I add the code in the console
$('.help-button').click(function(){
alert($(this).attr('data-button'));
});
But I'm very unsure where to insert my script.
I've tried all sorts of places. In the index page, in the header, but nothing really comes through or it lands in the wrong place.
Can you guide me in the right direction?
it works fine when I add the code in the console
$('.help-button').click(function(){
alert($(this).attr('data-button'));
});
But I'm very unsure where to insert my script.
I've tried all sorts of places. In the index page, in the header, but nothing really comes through or it lands in the wrong place.
Can you guide me in the right direction?
4
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« on: March 18, 2025, 10:27:52 PM »
Maybe something like this
NewDate = DATE(MONTH(OriginalDate),1,YEAR(OriginalDate))
NewDate = DATE(MONTH(OriginalDate),1,YEAR(OriginalDate))
5
Web Server - Ask For Help / xHTML routines on a NetWebPage
« on: March 14, 2025, 04:49:11 AM »
Hi Bruce
On my index page I have two routines (after body) on the xHTML tab.
One with a condition and one without.
The problem is that the one with a condition of has direct impact on the second one.
Only applies if the one with conditions comes first.
I think that is wrong.
Regards Niels
On my index page I have two routines (after body) on the xHTML tab.
One with a condition and one without.
The problem is that the one with a condition of has direct impact on the second one.
Only applies if the one with conditions comes first.
I think that is wrong.
Regards Niels
6
Web Server - Ask For Help / Button on header
« on: March 14, 2025, 01:15:42 AM »
Hi
I'm trying to place a button on the header on a form.
Allow xHTML is on
Allow UNSAFE xHTML is on
I can place a button without any problems but when I add the attribute onclick="onclick="$(''.help-click'').click()"" it fails. Does it have anything to do with the fact that "onclick" is SUPER UNSAFE?
Example attached.
Regards Niels
I'm trying to place a button on the header on a form.
Allow xHTML is on
Allow UNSAFE xHTML is on
I can place a button without any problems but when I add the attribute onclick="onclick="$(''.help-click'').click()"" it fails. Does it have anything to do with the fact that "onclick" is SUPER UNSAFE?
Example attached.
Regards Niels
7
Web Server - Ask For Help / Re: Broken browse
« on: March 06, 2025, 02:23:36 AM »
Done and works well.
Thanks!
Thanks!
8
Web Server - Ask For Help / Broken browse
« on: March 03, 2025, 11:41:21 PM »
Hi
I have a browse with a form. On the form there is a browse with a child browse. After editing the child the browse breaks (buttons disabled).
Example attached.
I am aware that in my example there are no filters on any of the browsers.
Any ideas?
Regards Niels
I have a browse with a form. On the form there is a browse with a child browse. After editing the child the browse breaks (buttons disabled).
Example attached.
I am aware that in my example there are no filters on any of the browsers.
Any ideas?
Regards Niels
9
Web Server - Ask For Help / Re: NTWS behaving strangely
« on: January 30, 2025, 10:07:47 PM »
Hi Bruce
I didn't get to use your suggestion but it helped me in the right direction. A self-made template on my popup forms didn't clean up after itself.
Thanks.
I didn't get to use your suggestion but it helped me in the right direction. A self-made template on my popup forms didn't clean up after itself.
Thanks.
10
Web Server - Ask For Help / NTWS behaving strangely
« on: January 29, 2025, 01:40:28 AM »
I?m currently experiencing something very mysterious with a larger NTWS app I?ve developed.
Several of my forms are behaving strangely. When I press ?Insert? in the browser, the form opens as it should. Then I press ?Cancel?.
When I repeat this exercise, the process starts to take longer and longer. When I get to the fourth time, it takes several seconds to open the form - the fifth time over 10 seconds.
Chrome and Edge go crazy in processor usage - up to 100%.
This happens in several forms. Other smaller forms work fine.
My first thought was Antivirus but I?ve moved the app to another PC and it gives the same result.
The thread number never goes above 5 so I don?t think it?s due to a hanging thread.
The only thing I can think of that I?ve changed is updating NTWS from 14.28 to 14.29.
UPDATE: Now I've tried downgrading to 14.28 but it makes no difference. So it must be something I?ve done?
I?m a bit lost. Any ideas?
Regards Niels
Several of my forms are behaving strangely. When I press ?Insert? in the browser, the form opens as it should. Then I press ?Cancel?.
When I repeat this exercise, the process starts to take longer and longer. When I get to the fourth time, it takes several seconds to open the form - the fifth time over 10 seconds.
Chrome and Edge go crazy in processor usage - up to 100%.
This happens in several forms. Other smaller forms work fine.
My first thought was Antivirus but I?ve moved the app to another PC and it gives the same result.
The thread number never goes above 5 so I don?t think it?s due to a hanging thread.
The only thing I can think of that I?ve changed is updating NTWS from 14.28 to 14.29.
UPDATE: Now I've tried downgrading to 14.28 but it makes no difference. So it must be something I?ve done?
I?m a bit lost. Any ideas?
Regards Niels
11
Web Server - Ask For Help / Re: Error in template - I guess
« on: January 06, 2025, 03:51:42 AM »
UP
13
Web Server - Ask For Help / Error in template - I guess
« on: December 08, 2024, 01:52:27 AM »
Hi Bruce
The situation is that I have two string fields on a form with the same field, but of course with different equates. (Use it for different lookup options)
The problem is that in Validate::Field "lookupfield" is set to the equate but in the Afterlookup routine the name of the field is used in the Case. So if the equate and field name are not the same the code in Afterlookup is never called.
I've made a fix myself that works, but if that's enough...
Regards Niels
The situation is that I have two string fields on a form with the same field, but of course with different equates. (Use it for different lookup options)
The problem is that in Validate::Field "lookupfield" is set to the equate but in the Afterlookup routine the name of the field is used in the Case. So if the equate and field name are not the same the code in Afterlookup is never called.
I've made a fix myself that works, but if that's enough...
Regards Niels
14
Web Server - Ask For Help / Default Security
« on: November 06, 2024, 03:25:52 AM »
The following setup does not work - for me...
I have set the "User must be locked in" on the webserver template. On the form "User must be locked in" is set to default.
If i try to open the form nothing happens. If I change "User must be locked in" on the form to yes it all works.
Maybe a template error or?
Attached an example. After login try to click the test menu.
/Niels
I have set the "User must be locked in" on the webserver template. On the form "User must be locked in" is set to default.
If i try to open the form nothing happens. If I change "User must be locked in" on the form to yes it all works.
Maybe a template error or?
Attached an example. After login try to click the test menu.
/Niels
15
Web Server - Ask For Help / Re: Refresh the entire browse or just a row after an event in a Browse menu
« on: October 24, 2024, 10:03:15 PM »
Thanks!
This also works perfectly.
This also works perfectly.