Recent Posts
1
Web Server - Ask For Help / Re: Desktop File path
« Last post by rjolda on Today at 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
2
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
3
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
4
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
5
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
6
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.
7
Web Server - Ask For Help / Re: Old wizard
« Last post by Bruce on May 27, 2024, 08:52:48 PM »thanks
8
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.
9
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
10
Web Server - Ask For Help / Re: Partial Save?
« Last post by rjolda on May 26, 2024, 12:38:09 PM »Johan,
I constantly get stuck with this - Bruce keeps correcting me. So here is it. There is NO FORM! It does NOT EXIST!. So, when user is on "Same FORM" - that really does NOT MEAN ANYTHING!.
Bruce said "Think of the Form as a series of EVENTS" - User sends a Request EVENT to server and Server Responds. Then the connection is CLOSED. If you open a form, THe record is read into SESSION variables and the Record itself is GONE!. So, Everything you do is an EVENT. Because the SESSION ID is passed back and forth between the User ( Browser ) and Server, the SERVER VALUES are always accessible by SessionID - the record itself is NOT available. At the End of the form - when you press SAVE or DONE - the Server is instructed to fetch the record and update it with the ServerValues for that session ID. Does that make sense?
I am doing some things like your user. I am pulling out a record and putting some settings in it. Then the user ( still on the same MemForm) is pressing buttons to do different actions. For each of these actions, I have to take their new values, Stuff them into the Session Values, fetch the record and write them to the record itself.
In other words, the Session Values are the thing that the user is interacting with ( as a representation of the record itself..). Therefore if you are going to do a partial save, Update the Session variables. At this point I am going to fetch the record and write the values directly to the record and update it without using the p_web.recordtovalue and p_web.Values to Record functions. (Not sure that these are the correct names but they are in the p_web settings. i will keep the Session values updated as they are the "representative state" of the "record". At the end, I could to a values to record save but I might just roll my own and update the fields that i want.
Since the Updates to the record are under YOUR CONTROL in the EMBEDS - you can check to make sure that your data got written to the record with the
If not Access:File.Update() = Level:Benign
then ALERT USER.
You can also use the Access:File.tryUpdate() function.
Hope that this explanation helps you.
Ron
I constantly get stuck with this - Bruce keeps correcting me. So here is it. There is NO FORM! It does NOT EXIST!. So, when user is on "Same FORM" - that really does NOT MEAN ANYTHING!.
Bruce said "Think of the Form as a series of EVENTS" - User sends a Request EVENT to server and Server Responds. Then the connection is CLOSED. If you open a form, THe record is read into SESSION variables and the Record itself is GONE!. So, Everything you do is an EVENT. Because the SESSION ID is passed back and forth between the User ( Browser ) and Server, the SERVER VALUES are always accessible by SessionID - the record itself is NOT available. At the End of the form - when you press SAVE or DONE - the Server is instructed to fetch the record and update it with the ServerValues for that session ID. Does that make sense?
I am doing some things like your user. I am pulling out a record and putting some settings in it. Then the user ( still on the same MemForm) is pressing buttons to do different actions. For each of these actions, I have to take their new values, Stuff them into the Session Values, fetch the record and write them to the record itself.
In other words, the Session Values are the thing that the user is interacting with ( as a representation of the record itself..). Therefore if you are going to do a partial save, Update the Session variables. At this point I am going to fetch the record and write the values directly to the record and update it without using the p_web.recordtovalue and p_web.Values to Record functions. (Not sure that these are the correct names but they are in the p_web settings. i will keep the Session values updated as they are the "representative state" of the "record". At the end, I could to a values to record save but I might just roll my own and update the fields that i want.
Since the Updates to the record are under YOUR CONTROL in the EMBEDS - you can check to make sure that your data got written to the record with the
If not Access:File.Update() = Level:Benign
then ALERT USER.
You can also use the Access:File.tryUpdate() function.
Hope that this explanation helps you.
Ron