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: Partial Save?
« on: Today at 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
2
Web Server - Ask For Help / Re: Partial Save?
« on: May 25, 2024, 02:16:17 AM »
Johan,
What are you working with - a Form or MemForm?
There are several methods available for Before writing to file and after writing to file. Make sure your code is in the Before writing to file.
Ron
What are you working with - a Form or MemForm?
There are several methods available for Before writing to file and after writing to file. Make sure your code is in the Before writing to file.
Ron
3
Web Server - Ask For Help / Re: GUID Question
« on: May 24, 2024, 04:18:38 AM »
Hi,
16 characters - each can have up to 36 choices ( Upper case alphabet) gives you 2.2300745198530623141535718272648e+43 unique values. Do you need more than that?
If you do, then you can go to 32 characters and you will get 1.5324955408658888583583470271503e+54 values. You can choose. Bruce recommends 16 characters but you can zone in on your own comfort zone!
Ron
16 characters - each can have up to 36 choices ( Upper case alphabet) gives you 2.2300745198530623141535718272648e+43 unique values. Do you need more than that?
If you do, then you can go to 32 characters and you will get 1.5324955408658888583583470271503e+54 values. You can choose. Bruce recommends 16 characters but you can zone in on your own comfort zone!
Ron
4
Web Server - Ask For Help / Trying to get a handle on css? Consider Stylizer 7
« on: May 15, 2024, 01:22:53 AM »
HI,
NT 14.21 C11.0
As a 35 year clarion programmer I have NO CLUE on css. I got a young kid to help me get started. Arnor told me about Stylizer 7 (skybound.ca ) for helping with css. I downloaded the demo ( free for 2 weeks ). However, it would not load my web site. I wrote to support and they told me that they were able to open my NT web app with the chrome add on. I had to purchase the program for US$79.95 to get the CHrome and Firefox plug ins. However, well worth it. I am overwhelmed by all the stuff in the Chrome Developer and Firefox Developer. This program lays out the CSS very nicely and with a little learning, it is pretty clear. I am finding it very helpful in getting my css going and up to snuff. If you point it to your custom.css, it will save any changes right to your custom.css. Pretty neat.
FWIW,
Ron
NT 14.21 C11.0
As a 35 year clarion programmer I have NO CLUE on css. I got a young kid to help me get started. Arnor told me about Stylizer 7 (skybound.ca ) for helping with css. I downloaded the demo ( free for 2 weeks ). However, it would not load my web site. I wrote to support and they told me that they were able to open my NT web app with the chrome add on. I had to purchase the program for US$79.95 to get the CHrome and Firefox plug ins. However, well worth it. I am overwhelmed by all the stuff in the Chrome Developer and Firefox Developer. This program lays out the CSS very nicely and with a little learning, it is pretty clear. I am finding it very helpful in getting my css going and up to snuff. If you point it to your custom.css, it will save any changes right to your custom.css. Pretty neat.
FWIW,
Ron
5
Web Server - Ask For Help / Re: Serving a HELP file for my Web APP
« on: May 10, 2024, 03:33:59 PM »
Hi,
Found that having the base page named "Index.htm' did not work well. Re-named it to "index2.htm' and I got it to work under the web folder. However, I am going to try to get it to serve out of its own folder under web\eppilihelp
At least I am getting somewhere.
Ron
Found that having the base page named "Index.htm' did not work well. Re-named it to "index2.htm' and I got it to work under the web folder. However, I am going to try to get it to serve out of its own folder under web\eppilihelp
At least I am getting somewhere.
Ron
6
Web Server - Ask For Help / Re: Serving a HELP file for my Web APP
« on: May 10, 2024, 03:22:10 PM »
Hi Jane,
Yes, I can open the Help file with browser. It is there and in the correct place. Seems like I don't have the NetTalk reference correct with paths, etc.
Ron
Yes, I can open the Help file with browser. It is there and in the correct place. Seems like I don't have the NetTalk reference correct with paths, etc.
Ron
7
Web Server - Ask For Help / Re: Serving a HELP file for my Web APP
« on: May 10, 2024, 01:40:30 PM »
Hi,
Typos in Post. URL is correct in my APP and the post should have said :
I put a Menu Item called "HELP" which On CLick opens the URL: '/EPPILIHelp/Index.htm'
Fat fingers....
Ron
Typos in Post. URL is correct in my APP and the post should have said :
I put a Menu Item called "HELP" which On CLick opens the URL: '/EPPILIHelp/Index.htm'
Fat fingers....
Ron
8
Web Server - Ask For Help / Serving a HELP file for my Web APP
« on: May 10, 2024, 01:12:51 PM »
Hi,
NT 14.21 C 11.0.136
I wrote a Help manual in HTML in Dr Explain. Now, I want to have my users be able to open it. However, I can't get it to work.
My HELP file is in the folder EPPILIHELP which is under the web folder for my APP. WIthin the EPPILIHELP folder is an Index.htm page which is the root for all of the HTML HELP files.
I put a Menu Item called "HELP" which On CLick opens the URL: '/EPPIPIHelp/Index.htm'
However, the APP says that the file cannot be found. I tried lots of permuatations of folder and name combos - no working. Target fra,e is '_blank'.
What is the proper way to call my help file?
Thanks,
Ron
NT 14.21 C 11.0.136
I wrote a Help manual in HTML in Dr Explain. Now, I want to have my users be able to open it. However, I can't get it to work.
My HELP file is in the folder EPPILIHELP which is under the web folder for my APP. WIthin the EPPILIHELP folder is an Index.htm page which is the root for all of the HTML HELP files.
I put a Menu Item called "HELP" which On CLick opens the URL: '/EPPIPIHelp/Index.htm'
However, the APP says that the file cannot be found. I tried lots of permuatations of folder and name combos - no working. Target fra,e is '_blank'.
What is the proper way to call my help file?
Thanks,
Ron
9
Web Server - Ask For Help / Deleting Session Values on Logout
« on: April 29, 2024, 05:45:09 AM »
Hi All,
NT 14.18 C11.0.136
1. Where is the check box to DELETE ALL SESSION VALUES on LOGOUT?
2. What does the Checkbox on Server Settings - Performance Tab - 'Save Server State between runs" do?
Thanks,
Ron
NT 14.18 C11.0.136
1. Where is the check box to DELETE ALL SESSION VALUES on LOGOUT?
2. What does the Checkbox on Server Settings - Performance Tab - 'Save Server State between runs" do?
Thanks,
Ron
10
Web Server - Ask For Help / How to check if they did a signature in NT
« on: April 28, 2024, 01:17:39 AM »
Hi,
NT14.18 C11.0.136
In my app a SIGNATURE is required. I have a Signature field. How do I make sure that they sign before submitting the record?
IE - what do I check - maybe the prop:size of the image field? Or something else?
Thanks,
Ron
NT14.18 C11.0.136
In my app a SIGNATURE is required. I have a Signature field. How do I make sure that they sign before submitting the record?
IE - what do I check - maybe the prop:size of the image field? Or something else?
Thanks,
Ron
11
Web Server - Ask For Help / Mem Form Field
« on: April 21, 2024, 11:37:23 AM »
Hi Using NT14.18 and C11.0.136
I have some Entry fields on a MemForm. ( Strings).
Can I make Entry Fields ( strings ) - READ ONLY?
Is there a way to set an attribute - I am looking up data on 1 tab.
On Tab 2 - if there is no data in the table that I looked up then I want them to Enter Last Name and First name, etc.
If the data exists, then I just want to SHOW the Last Name and First name, etc and not allow modification.
Or do I have to hide/unhide Last name String (Entry) and Last Name (Display) based on the condition?
Thanks,
Ron
I have some Entry fields on a MemForm. ( Strings).
Can I make Entry Fields ( strings ) - READ ONLY?
Is there a way to set an attribute - I am looking up data on 1 tab.
On Tab 2 - if there is no data in the table that I looked up then I want them to Enter Last Name and First name, etc.
If the data exists, then I just want to SHOW the Last Name and First name, etc and not allow modification.
Or do I have to hide/unhide Last name String (Entry) and Last Name (Display) based on the condition?
Thanks,
Ron
12
Web Server - Ask For Help / Re: Using MEmform
« on: April 21, 2024, 10:53:44 AM »
Alberto,
I had a field equate.
The Field RESET was the key. Got it working.
Thanks,
Ron
I had a field equate.
The Field RESET was the key. Got it working.
Thanks,
Ron
13
Web Server - Ask For Help / Re: Browse Conditional CSS Background-color
« on: April 21, 2024, 10:32:20 AM »
Hi Ken,
I have no CSS experience. I hired a young kid to help me with CSS and help me understand it. He knows NOTHING of Clarion. These young kids code this CSS in their sleep. He was able to help me do some styling - even to dig down and take what appeared to be the correct style and find what was overriding it and correct it - all in css.....My advice, buy some CSS time and you can get it sorted out very quickly. I am trying to wrap up my web app. I have the kid on call so that we can do all the css and make it look pretty. CSS was a big headache for me - now, I just call my consultant and he sorts it out very quickly! No more CSS headaches for me. Also, I am learning CSS and how to put stuff in clarion so that I can control the elements I want! Let me know if you want contact info for my guy. (He charges less than $40.00 per hour because he is in Nigeria.)
Ron
I have no CSS experience. I hired a young kid to help me with CSS and help me understand it. He knows NOTHING of Clarion. These young kids code this CSS in their sleep. He was able to help me do some styling - even to dig down and take what appeared to be the correct style and find what was overriding it and correct it - all in css.....My advice, buy some CSS time and you can get it sorted out very quickly. I am trying to wrap up my web app. I have the kid on call so that we can do all the css and make it look pretty. CSS was a big headache for me - now, I just call my consultant and he sorts it out very quickly! No more CSS headaches for me. Also, I am learning CSS and how to put stuff in clarion so that I can control the elements I want! Let me know if you want contact info for my guy. (He charges less than $40.00 per hour because he is in Nigeria.)
Ron
14
Web Server - Ask For Help / Re: Using MemForm again
« on: April 21, 2024, 07:32:51 AM »
Solved!
I had to move my code to the "POST UPDATE". That allowed all the field validations and then when they were all validated, the code ran the UPDATE and then my code in the "POST UPDATE" embed. I had called the Memform in "Change" mode.
Ron
I had to move my code to the "POST UPDATE". That allowed all the field validations and then when they were all validated, the code ran the UPDATE and then my code in the "POST UPDATE" embed. I had called the Memform in "Change" mode.
Ron
15
Web Server - Ask For Help / Using MemForm again
« on: April 21, 2024, 03:50:40 AM »
Hi, Using NT14.18 and C11.0.136
I am using a Memform called in Change mode. I am collecting data and using it to write to 3 different tables.
I am putting my code in the ValidateUpdate Routine ( which calls the do CompleteForm and do ValidateRecord routines) and it calls these first.
However, if I open the memform and click the "Save" button for the form, it starts writing to my 3 tables and then pops up a message that required fields are not filled in... However, I want it to get the required fields FIRST. Is there a statement like IF ALL FIELDS ARE VALIDATED then go ahead and write to the tables. If NOT ALL VALIDATED then remind them to fill in the required fields?
Thanks,
Ron
I am using a Memform called in Change mode. I am collecting data and using it to write to 3 different tables.
I am putting my code in the ValidateUpdate Routine ( which calls the do CompleteForm and do ValidateRecord routines) and it calls these first.
However, if I open the memform and click the "Save" button for the form, it starts writing to my 3 tables and then pops up a message that required fields are not filled in... However, I want it to get the required fields FIRST. Is there a statement like IF ALL FIELDS ARE VALIDATED then go ahead and write to the tables. If NOT ALL VALIDATED then remind them to fill in the required fields?
Thanks,
Ron