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 / Coding a date field to be a particular day date
« 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
2
Web Server - Ask For Help / web26 example File Upload
« on: March 13, 2025, 07:08:14 PM »
When running the example" File Upload" ,The message box is telling me on "Start" that the nominated file is Uploaded and displays its size,
and for a larger file I can see the progress bar.
The file is not being uploaded to the webserver\uploads
In the webserver settings Scripts tab I have "File Upload" Ticked, ran Gzipall from here OK compiled and run
What am I missing please?
Thanks
Richard NT 14.28
and for a larger file I can see the progress bar.
The file is not being uploaded to the webserver\uploads
In the webserver settings Scripts tab I have "File Upload" Ticked, ran Gzipall from here OK compiled and run
What am I missing please?
Thanks
Richard NT 14.28
3
Web Server - Ask For Help / LetsEncrypt Certificate not auto renewing
« on: February 18, 2025, 03:23:05 PM »
Hi all,
While I can successfully, manually renew the Certificate from the template, the last auto renewal failed.
At the time the exe was running as a Service, so I stopped that and updated from the web serever.
The app is running from an Amazon Server.
I have checked the settings and the paths appear to be correct.
I attach a snip
Is there are reason?
Thanks
Richard
NT 14.28
While I can successfully, manually renew the Certificate from the template, the last auto renewal failed.
At the time the exe was running as a Service, so I stopped that and updated from the web serever.
The app is running from an Amazon Server.
I have checked the settings and the paths appear to be correct.
I attach a snip
Is there are reason?
Thanks
Richard
NT 14.28
4
Web Server - Ask For Help / Filtering two fields in a Net Web Browse
« on: January 14, 2025, 09:40:44 PM »
Hi
I want to filter on two fields in a NW browse as in this expression, which is not working -
ThisView{prop:Filter} = 'Men:Date = ''' & p_web.GSV('Din:date') & |
'and Men:Hall = ''' & p_web.GSV('Din:Hall') &''' '
I can on either one but not both
The code is in 11 Set Filter
Thanks
Richard
NT 14.28
I want to filter on two fields in a NW browse as in this expression, which is not working -
ThisView{prop:Filter} = 'Men:Date = ''' & p_web.GSV('Din:date') & |
'and Men:Hall = ''' & p_web.GSV('Din:Hall') &''' '
I can on either one but not both
The code is in 11 Set Filter
Thanks
Richard
NT 14.28
5
Web Server - Ask For Help / Landscape Reports when running as a Service
« on: December 30, 2024, 06:31:26 PM »
Hello,
When my app is run as a Service, the Reports display and print in Landscape, which reverses to Portrait when the Service is stopped.
The Report Properties do not have the Landscape option selected.
How do I resolve this please?
Thanks
Richard
NT 14.28
SelfService 3.62
When my app is run as a Service, the Reports display and print in Landscape, which reverses to Portrait when the Service is stopped.
The Report Properties do not have the Landscape option selected.
How do I resolve this please?
Thanks
Richard
NT 14.28
SelfService 3.62
6
Web Server - Ask For Help / Cannot load as a Service -wrong path to executable
« on: December 29, 2024, 02:12:37 PM »
I have the wrong "Path to executable" displaying in Services App Name Properties local computer on an Amazon Server when trying to run the app as a service
When starting the Service manually "Windows could not start the <app name> service on local computer"
error Code 2 displays "the system cannot find the path specified"
The path is wrong - How do I correct the path please?
I have deleted the INI file and recompiled on the Server but path does not reset.
The app folder as C:\ on the Server is correct but showing in the path as D:
Thanks
Richard
NT 14.28
Self Service 3.62
When starting the Service manually "Windows could not start the <app name> service on local computer"
error Code 2 displays "the system cannot find the path specified"
The path is wrong - How do I correct the path please?
I have deleted the INI file and recompiled on the Server but path does not reset.
The app folder as C:\ on the Server is correct but showing in the path as D:
Thanks
Richard
NT 14.28
Self Service 3.62
7
Web Server - Ask For Help / How to encrypt an existing TPS file
« on: November 22, 2024, 08:56:46 PM »
I have a working TPS file in a Nettalk Server app
The file currently does not have the Encrypt selected nor does it have OWNER populated in the DCT
If I attempt to populate these using a backup file as a test, and adding to the version in Options then compiling I get errorcode 36 on running
How to sort this please.
Thanks
Richard
C11.1 13855
NT 14.28
The file currently does not have the Encrypt selected nor does it have OWNER populated in the DCT
If I attempt to populate these using a backup file as a test, and adding to the version in Options then compiling I get errorcode 36 on running
How to sort this please.
Thanks
Richard
C11.1 13855
NT 14.28
8
Web Server - Ask For Help / Emulating the Accounts example 31 Records not displaying correctly
« on: September 13, 2024, 05:55:09 PM »
I have a page loading Netweb Browse and associated form
Adding records to the browse via the form complete OK except that form selected checkboxes are not displaying populated unless there is more than one record and when toggling between the records.
It appears that only the record in focus does not display the populated checkboxes although other line fields are correct.
By hovering the cursor on the line displays, until moved off.
This anomaly only occurs when run online despite copying in the updated exe and web folder .
On my local machine the Browse behaves as expected.
Can I have help with this please.
Thanks
Richard NT 14.27
Adding records to the browse via the form complete OK except that form selected checkboxes are not displaying populated unless there is more than one record and when toggling between the records.
It appears that only the record in focus does not display the populated checkboxes although other line fields are correct.
By hovering the cursor on the line displays, until moved off.
This anomaly only occurs when run online despite copying in the updated exe and web folder .
On my local machine the Browse behaves as expected.
Can I have help with this please.
Thanks
Richard NT 14.27
9
Web Server - Ask For Help / FORMAT(SRIA:DOB,@D6)
« on: July 28, 2024, 01:32:12 AM »
When exporting records to a CSV file, using the code, ExpCSV:Label11 = FORMAT(SRIA:DOB,@D6)
places the date as dd/mm/yyyy when the date is >= 10/mm/yyyy, to the right of the cell
Those dates < 10/mm/yyyy are to the left of the cell
Is there are date picture that places a leading zero in the dd/mm/yyyy such as 09/mm/yyyy when the day date is <10
I have tried RIGHT(Format..... which extenuates and its less than elegant
Thanks
Richard
places the date as dd/mm/yyyy when the date is >= 10/mm/yyyy, to the right of the cell
Those dates < 10/mm/yyyy are to the left of the cell
Is there are date picture that places a leading zero in the dd/mm/yyyy such as 09/mm/yyyy when the day date is <10
I have tried RIGHT(Format..... which extenuates and its less than elegant
Thanks
Richard
10
Web Server - Ask For Help / Rebooting in Code
« on: July 07, 2024, 08:29:56 PM »
Hi
Re a reboot in Code...
I found this..
MY QUESTIONS: Can this be rewritten if necessary to run from a NT app and if so where do I source the Windows API Windows.inc
I copy and paste -
"In Clarion, you can reboot a computer using the EXECUTE statement to run the appropriate system command. Here?s how you can do it:
clarion
Copy code
PROGRAM
MAP
END
CODE
INCLUDE('windows.inc') ! Include Windows API declarations
MAP
MODULE('kernel32.dll')
ExitWindowsEx(*CSTRING),BOOL,PROC
END
END
CODE
IF ExitWindowsEx('0', TRUE)
MESSAGE('Reboot initiated successfully.')
ELSE
MESSAGE('Failed to initiate reboot.')
END
END
Explanation:
Windows API Declaration (windows.inc):
The INCLUDE('windows.inc') statement includes the necessary Windows API declarations needed for ExitWindowsEx.
ExitWindowsEx Function:
ExitWindowsEx is a Windows API function that can be used to shut down or reboot a computer. In this case, '0' is used to indicate a reboot.
Execution:
The ExitWindowsEx('0', TRUE) line attempts to initiate a reboot ('0' means reboot, TRUE means force reboot if necessary).
Message Handling:
Depending on the result of ExitWindowsEx, appropriate messages are displayed to indicate whether the reboot was successful or not."
Thanks
Richard
Re a reboot in Code...
I found this..
MY QUESTIONS: Can this be rewritten if necessary to run from a NT app and if so where do I source the Windows API Windows.inc
I copy and paste -
"In Clarion, you can reboot a computer using the EXECUTE statement to run the appropriate system command. Here?s how you can do it:
clarion
Copy code
PROGRAM
MAP
END
CODE
INCLUDE('windows.inc') ! Include Windows API declarations
MAP
MODULE('kernel32.dll')
ExitWindowsEx(*CSTRING),BOOL,PROC
END
END
CODE
IF ExitWindowsEx('0', TRUE)
MESSAGE('Reboot initiated successfully.')
ELSE
MESSAGE('Failed to initiate reboot.')
END
END
Explanation:
Windows API Declaration (windows.inc):
The INCLUDE('windows.inc') statement includes the necessary Windows API declarations needed for ExitWindowsEx.
ExitWindowsEx Function:
ExitWindowsEx is a Windows API function that can be used to shut down or reboot a computer. In this case, '0' is used to indicate a reboot.
Execution:
The ExitWindowsEx('0', TRUE) line attempts to initiate a reboot ('0' means reboot, TRUE means force reboot if necessary).
Message Handling:
Depending on the result of ExitWindowsEx, appropriate messages are displayed to indicate whether the reboot was successful or not."
Thanks
Richard
11
Web Server - Ask For Help / Reboot from Running NT Application
« on: July 05, 2024, 08:15:44 PM »
Hello,
I have the need to reboot a running NT app on a virtual Server, ideally from a button's server side code.
The application is running as a service so will/ should restart.
I have searched the WinEvent5 documentation for clues without success
I want to do this to refresh memory lost through leakage.
Thanks in anticipation...
Richard
NT 14.23
I have the need to reboot a running NT app on a virtual Server, ideally from a button's server side code.
The application is running as a service so will/ should restart.
I have searched the WinEvent5 documentation for clues without success
I want to do this to refresh memory lost through leakage.
Thanks in anticipation...
Richard
NT 14.23
12
Web Server - Ask For Help / Desktop File path
« on: May 28, 2024, 09:17:52 PM »
Hello
I have a backup routine with a string field called loc:desktopfilepath
I want the user to be able to lookup their own local desktop path so the created folder is copied there....
Is there a way?
Thanks Richard
NT 14.22
IF p_web.GSV('loc:Desktopfilepath') = ''
locsite = 'VisaBackup'&'-'&FORMAT(today(),@D11) ! loc:Alert ='Desktop filepath is empty - populate location'
ELSE
locsite = p_web.GSV('loc:Desktopfilepath')&'\VisaBackup'&'-'&FORMAT(today(),@D11)
END
CreateDirectory(locsite)
copy('User.tps',locsite)
etc
I have a backup routine with a string field called loc:desktopfilepath
I want the user to be able to lookup their own local desktop path so the created folder is copied there....
Is there a way?
Thanks Richard
NT 14.22
IF p_web.GSV('loc:Desktopfilepath') = ''
locsite = 'VisaBackup'&'-'&FORMAT(today(),@D11) ! loc:Alert ='Desktop filepath is empty - populate location'
ELSE
locsite = p_web.GSV('loc:Desktopfilepath')&'\VisaBackup'&'-'&FORMAT(today(),@D11)
END
CreateDirectory(locsite)
copy('User.tps',locsite)
etc
13
Web Server - Ask For Help / Need to delete CLW and OBJ and recompile for changes to take effect
« on: April 15, 2024, 03:24:05 PM »
Hello
Why do I need to delete the clw and the obj for some changes to take effect?
for example in a browse I had two columns which were Edit in Place
Although I deleted the checkbox tick for edit in place and recompiled, the fields were still EIP active,
and the changes did not take effect until the deletion of the CLW and OBJ and a recompile.
I have the same issue when changing column header names, and button renaming
Thanks
Richard
C 11.1.13855EE
NT 14.20
Why do I need to delete the clw and the obj for some changes to take effect?
for example in a browse I had two columns which were Edit in Place
Although I deleted the checkbox tick for edit in place and recompiled, the fields were still EIP active,
and the changes did not take effect until the deletion of the CLW and OBJ and a recompile.
I have the same issue when changing column header names, and button renaming
Thanks
Richard
C 11.1.13855EE
NT 14.20
14
Web Server - Ask For Help / Including on Report the total count of records displayed
« on: April 03, 2024, 07:41:07 PM »
Hi
I have a report where I am totalling the number of records being displayed using loc:Count+=1
A stop statement into the Serverside code returns a total number correctly both as loc:Count and as p_web.GSV('loc:Count')
My problem is getting the count value to display in the Header of the report.
Ive tried in WindowManager OpenReport Procedure after Parent Call SetTarget(report)
and in PrimeReportOptions when run in web mode...
loctotal = p_web.GSV('loc:Count')
where loc:Total is a long N_4
But both return 0 in the report
What do I need to do , please?
Thanks
Richard
NT 14.20
I have a report where I am totalling the number of records being displayed using loc:Count+=1
A stop statement into the Serverside code returns a total number correctly both as loc:Count and as p_web.GSV('loc:Count')
My problem is getting the count value to display in the Header of the report.
Ive tried in WindowManager OpenReport Procedure after Parent Call SetTarget(report)
and in PrimeReportOptions when run in web mode...
loctotal = p_web.GSV('loc:Count')
where loc:Total is a long N_4
But both return 0 in the report
What do I need to do , please?
Thanks
Richard
NT 14.20
15
Web Server - Ask For Help / Freezing when applying security to buttons
« on: March 28, 2024, 01:23:10 AM »
Using NT 14.20
I want to hide the <delete> and <change> buttons on Forms and Browses by User security level.
On the Security Tab of the button , Im changing "default" to YES and adding 100 as the security level,
compile and run...
On the Browse for example scrolling by using "next" the Browse freezes and greys out.
Returning to "default" restores normal function.
Can you check this please Bruce?
Cheers
Richard
I want to hide the <delete> and <change> buttons on Forms and Browses by User security level.
On the Security Tab of the button , Im changing "default" to YES and adding 100 as the security level,
compile and run...
On the Browse for example scrolling by using "next" the Browse freezes and greys out.
Returning to "default" restores normal function.
Can you check this please Bruce?
Cheers
Richard