Recent Posts
11
Web Server - Ask For Help / Re: Desktop File path
« Last post by Richard I on May 29, 2024, 06:58:05 PM »Ron,
In my post you will note I am trying to direct a folder to the users desktop
It appears that the dos filepath template available in Clarion is not applicable to Webapps
So Im creating a folder, copying tps files to it and then the intention is to copy that folder to the users desktop
(The backup routine is working and currently the user needs to navigate to the app folder,copy and paste)
Its similar intent to the file download app but a folder does not have a suffix.
I await in eager anticipation.....
Regards,
Richard
In my post you will note I am trying to direct a folder to the users desktop
It appears that the dos filepath template available in Clarion is not applicable to Webapps
So Im creating a folder, copying tps files to it and then the intention is to copy that folder to the users desktop
(The backup routine is working and currently the user needs to navigate to the app folder,copy and paste)
Its similar intent to the file download app but a folder does not have a suffix.
I await in eager anticipation.....
Regards,
Richard
12
Web Server - Ask For Help / Re: Desktop File path
« Last post by rjolda on May 29, 2024, 01:08:03 AM »Hi Richard,
Yes, There is always a way. What are you trying to get done?
Ron
Yes, There is always a way. What are you trying to get done?
Ron
13
Web Server - Ask For Help / Desktop File path
« Last post by Richard I 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
14
Web Server - Ask For Help / Re: File Upload button on MemForm
« Last post by jking on May 28, 2024, 12:05:43 PM »Hi Bruce,
In preparing the example app web26, I found a solution. I simply created a local variable (string) and used this in the Field name on the field tab of the File Upload button. It now uploads the selected file to the uploads folder.
Thanks,
Jeff
In preparing the example app web26, I found a solution. I simply created a local variable (string) and used this in the Field name on the field tab of the File Upload button. It now uploads the selected file to the uploads folder.
Thanks,
Jeff
15
Web Server - Ask For Help / Re: msvcr140.dll is missing
« Last post by Johan de Klerk on May 28, 2024, 02:48:50 AM »Hi Heinz,
You did not install the Visual Studio 2017 (x86).
https://www.capesoft.com/docs/NetTalk14/NetTalk.htm#DeployingAtlsClientOrServer
Regards
Johan de Klerk
You did not install the Visual Studio 2017 (x86).
https://www.capesoft.com/docs/NetTalk14/NetTalk.htm#DeployingAtlsClientOrServer
Regards
Johan de Klerk
16
Web Server - Ask For Help / msvcr140.dll is missing
« Last post by hkalmbach on May 28, 2024, 01:27:33 AM »Hello,
I tried to configure email sending on a windows server 2022. For this I used netdemo / Email send.
The email should be send by smtp.office365.com. On sending the test email I get the message that some dll's could not be loaded.
Everything is present but not msvcr140.dll.
Is this a microsoft dll? Can somebody help?
Cheers
Heinz
I tried to configure email sending on a windows server 2022. For this I used netdemo / Email send.
The email should be send by smtp.office365.com. On sending the test email I get the message that some dll's could not be loaded.
Everything is present but not msvcr140.dll.
Is this a microsoft dll? Can somebody help?
Cheers
Heinz
17
Web Server - Ask For Help / Re: File Upload button on MemForm
« Last post by Bruce on May 27, 2024, 08:57:09 PM »Very possible Jeff - make an example and post here.
18
Web Server - Ask For Help / Re: Old wizard
« Last post by Bruce on May 27, 2024, 08:52:48 PM »thanks
19
Web Server - Ask For Help / Re: GUID Question
« Last post by Bruce on May 27, 2024, 08:51:54 PM »>> A .Net developer told me that the GUID should ideally be 32 characters.
He's likely referring to the UID version 4 format.
https://en.wikipedia.org/wiki/Universally_unique_identifier
which is a 16 byte string (but often represented as 32 hex digits, with some colons.) (16 character alphabet, 0-9 and a-f)
These have about 121 bits of randomness (aka "entropy")
The Guids we tend to use in Clarion are also 16 chars long, but because it's easier to deal with text values, the alphabet is restricted to 36 characters (0-9 and A-Z). This results in approximately 83 bits of entropy.
So yes, a UIDv4 has more bits of entropy, and can hold more values than the Guid you are using. However it is harder to deal with as it can contain binary values, so needs to continually be encoded and decoded when moving to a text form.
The risk of a collision is n / 2^82 where n is the number of records in your table. (Not in the database, in the table.) If you feel that this value rises to unacceptably high levels then you can increase the length of the string, or the size of the alphabet. I would suggest this is a useful thing to do when you are expecting around 4 835 703 278 458 516 698 records - at which point the risk of a collision would be about 1 in a million.
He's likely referring to the UID version 4 format.
https://en.wikipedia.org/wiki/Universally_unique_identifier
which is a 16 byte string (but often represented as 32 hex digits, with some colons.) (16 character alphabet, 0-9 and a-f)
These have about 121 bits of randomness (aka "entropy")
The Guids we tend to use in Clarion are also 16 chars long, but because it's easier to deal with text values, the alphabet is restricted to 36 characters (0-9 and A-Z). This results in approximately 83 bits of entropy.
So yes, a UIDv4 has more bits of entropy, and can hold more values than the Guid you are using. However it is harder to deal with as it can contain binary values, so needs to continually be encoded and decoded when moving to a text form.
The risk of a collision is n / 2^82 where n is the number of records in your table. (Not in the database, in the table.) If you feel that this value rises to unacceptably high levels then you can increase the length of the string, or the size of the alphabet. I would suggest this is a useful thing to do when you are expecting around 4 835 703 278 458 516 698 records - at which point the risk of a collision would be about 1 in a million.
20
Web Server - Ask For Help / Re: Partial Save - Success or Fail?
« Last post by rjolda on May 26, 2024, 04:44:43 PM »HI Johan,
See my reply to your previous post on partial Save. I would guess that the Form template is doing an Insert when "Partial Save" is requested. At that point, the Server Values are written to the record and a GUID for this new record is generated. The Server would then "read the record that was just Inserted" and put the fields into Server Values. There, you should find the GUID of the inserted Record and you could manually test it. I don't know about the actual code but it might return a message that the INSERT failed?
I would look at the code and see what Bruce is doing at the time of INSERT and how it handles any errors.
Ron
See my reply to your previous post on partial Save. I would guess that the Form template is doing an Insert when "Partial Save" is requested. At that point, the Server Values are written to the record and a GUID for this new record is generated. The Server would then "read the record that was just Inserted" and put the fields into Server Values. There, you should find the GUID of the inserted Record and you could manually test it. I don't know about the actual code but it might return a message that the INSERT failed?
I would look at the code and see what Bruce is doing at the time of INSERT and how it handles any errors.
Ron