Recent Posts
21
Web Server - Ask For Help / Re: NT Maps - update calling different table/record
« Last post by Poul Jensen on March 19, 2025, 10:12:41 AM »Hi Bruce,
Revised web76 demo app that shows this behaviour emailed.
Cheers
/Poul
Revised web76 demo app that shows this behaviour emailed.
Cheers
/Poul
22
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« Last post by Niels Larsen 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)
23
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« Last post by Richard I on March 19, 2025, 12:40:34 AM »Thanks but no not yet!
24
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« Last post by Niels Larsen on March 18, 2025, 11:19:20 PM »format(DATE(MONTH(OriginalDate),1,YEAR(OriginalDate)),@D06)
25
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« Last post by Richard I on March 18, 2025, 11:05:48 PM »Thanks for that Niels, I need it in the format dd/mm/yyyy
I think your expression will return mm/dd/yyyy ?
Could then format newdate as @0D6 ?
Would that work?
Cheers,
Richard
I think your expression will return mm/dd/yyyy ?
Could then format newdate as @0D6 ?
Would that work?
Cheers,
Richard
26
Web Server - Ask For Help / Re: Button on header
« Last post by Niels Larsen 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?
27
Web Server - Ask For Help / Re: Coding a date field to be a particular day date
« Last post by Niels Larsen 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))
28
Web Server - Ask For Help / Coding a date field to be a particular day date
« Last post by Richard I on March 18, 2025, 08:49:54 PM »I want to change a date in a month by code say 23/07/2024 to 01/07/2024
In the table there could be a range of dates and I want them all to become the first of the respective month and year
Thanks
Cheers
Richard
In the table there could be a range of dates and I want them all to become the first of the respective month and year
Thanks
Cheers
Richard
29
Web Server - Ask For Help / Re: Modify the lookup procedure?
« Last post by rjolda on March 18, 2025, 03:26:27 PM »HI Jeff,
What you are trying to do is very unclear! However, under the Client-Side tab for the field you when refresh Prompt, value and comment. Also, When the field is accepted, You cn send new value to server and underneath that is a list of Objects to be RESET. So, if you have calculated your value but not reset the object, then it won't display.
Ron
What you are trying to do is very unclear! However, under the Client-Side tab for the field you when refresh Prompt, value and comment. Also, When the field is accepted, You cn send new value to server and underneath that is a list of Objects to be RESET. So, if you have calculated your value but not reset the object, then it won't display.
Ron
30
Web Server - Ask For Help / Re: Wrong encoding of text on maps
« Last post by Poul Jensen on March 18, 2025, 01:24:33 PM »Hi Bruce,
I have emailed an example app.
Cheers
/Poul
I have emailed an example app.
Cheers
/Poul