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.
391
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: March 03, 2012, 04:40:42 AM »
Bruce2,
Thanks! That seems to have fixed the login problem.
Jeff
Thanks! That seems to have fixed the login problem.
Jeff
392
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: March 02, 2012, 09:21:41 PM »
Bruce,
I have attached an updated version of the app, with the same dictionary as before. I changed the id number fields to display as recommended but just for development. I have removed all the previous embed code I tried to get the specimen path complete to refresh after the path form was completed.
You mentioned getting the fields on the specimen form to refesh after the path form changes was trickier. Can you provide some direction here?
Also, this particular copy of the app has developed a problem. I find login no longer works as expected. The index page does not update properly nor can I call the main browse. The login form keeps appearing. I have noticed this many times before after numerous recompiles and I resolve this by using a backup copy. However, I feel there is a problem here that needs fixing. My embed code in the login form has not changed at all. This is the code that does a lookup into the user file. Can you take a look at this as well? As I said I have other versions of this app where the login works as expected.
Thanks,
Jeff
[attachment deleted by admin]
I have attached an updated version of the app, with the same dictionary as before. I changed the id number fields to display as recommended but just for development. I have removed all the previous embed code I tried to get the specimen path complete to refresh after the path form was completed.
You mentioned getting the fields on the specimen form to refesh after the path form changes was trickier. Can you provide some direction here?
Also, this particular copy of the app has developed a problem. I find login no longer works as expected. The index page does not update properly nor can I call the main browse. The login form keeps appearing. I have noticed this many times before after numerous recompiles and I resolve this by using a backup copy. However, I feel there is a problem here that needs fixing. My embed code in the login form has not changed at all. This is the code that does a lookup into the user file. Can you take a look at this as well? As I said I have other versions of this app where the login works as expected.
Thanks,
Jeff
[attachment deleted by admin]
393
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: March 02, 2012, 08:39:16 AM »
Bruce,
Thanks for taking the time with this. I really appreciate your input. Here are my comments:
a. This is a test app and I have the primary key component fields displayed just for my reference during development. These will be removed/hidden in the final app.
b. Yup, just a left over setting I was testing. I tried a number of different things trying to get the effect I was looking for. This will be cleaned up.
I have two (redundant) Path complete fields mainly for convenience at this point. Two people will be involved in data entry. An assistant will create the record in specimens. Then a Pathologist will complete the pathology record, possibly coming back a number of times before deciding the record is complete. This field should only be set by the pathologist, not the assistant.
I like your idea of placing the specimen path complete field on the path form. I had not thought of this and thus I can remove the path complete field from the pathology file. The Pathologist can set this field when ready, and I can display it in the specimen browse as well so the assistant does not need to look elsewhere for the complete status.
I would like to lock the pathology record when complete, preventing any changes, except perhaps by the Pathologist. I think I can accomplish this by adding SecWin. Finally, the other specimen variables can be set as you suggested, upon update validation or upon entering Yes in the specimen path complete variable (I actually have this working in my current version.
Thanks for all your input.
Jeff
Thanks for taking the time with this. I really appreciate your input. Here are my comments:
a. This is a test app and I have the primary key component fields displayed just for my reference during development. These will be removed/hidden in the final app.
b. Yup, just a left over setting I was testing. I tried a number of different things trying to get the effect I was looking for. This will be cleaned up.
I have two (redundant) Path complete fields mainly for convenience at this point. Two people will be involved in data entry. An assistant will create the record in specimens. Then a Pathologist will complete the pathology record, possibly coming back a number of times before deciding the record is complete. This field should only be set by the pathologist, not the assistant.
I like your idea of placing the specimen path complete field on the path form. I had not thought of this and thus I can remove the path complete field from the pathology file. The Pathologist can set this field when ready, and I can display it in the specimen browse as well so the assistant does not need to look elsewhere for the complete status.
I would like to lock the pathology record when complete, preventing any changes, except perhaps by the Pathologist. I think I can accomplish this by adding SecWin. Finally, the other specimen variables can be set as you suggested, upon update validation or upon entering Yes in the specimen path complete variable (I actually have this working in my current version.
Thanks for all your input.
Jeff
394
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: March 01, 2012, 10:18:24 AM »
Bruce,
Please see reply #14 of this thread, it explains how to log in and the effect I'm looking for.
Thanks,
Jeff
Please see reply #14 of this thread, it explains how to log in and the effect I'm looking for.
Thanks,
Jeff
395
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: March 01, 2012, 07:19:49 AM »
Bruce,
No, not sorted out yet. I meant I forgot to add it to the sample code above. I still have this problem.
Thanks,
Jeff
No, not sorted out yet. I meant I forgot to add it to the sample code above. I still have this problem.
Thanks,
Jeff
396
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: March 01, 2012, 04:53:17 AM »
Bruce,
I forgot to add to the code, access:specimen.update().
Thanks,
Jeff
I forgot to add to the code, access:specimen.update().
Thanks,
Jeff
397
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: March 01, 2012, 04:50:37 AM »
Bruce,
Thanks for looking at this. First, there is a button called Users on the web server main screen. Use this to add a user, username goes in the email field and password in the password field. I used admin/ admin.
Log in and then click on Specimen in the first menu. Enter any data you wish here. Note the Pathology Complete check box defaults to No. This is of course the parent file. Next, go to the Pathology tab. Insert a new record, entering any data you wish. The idea here is for a Pathologist to enter data in multiple sittings. When complete they are to mark Pathology Complete in the pathology data section. When this is done, I would like three fields in the parent (specimen) file to be updated automatically. First, the date should be set to the date pathology was completed. Then the case number should be set to source + specimen ID. Finally, pathology complete should be set to yes as it is in the pathology file.
In an earlier NT version, I had placed the following code in validate update:
If pth:pathology_complete = 'Yes'
Spe:specimen_id = pth:specimen_id
Access:specimen.fetch(specimenid_key)
Spe:date = today()
Spe:case_number = spe:source&'-'&spe:specimen_id
Spe:pathology_complete='Yes'
End
This does not seem to work in NT 6.22. I hope I gave you enough here to get you started.
Thanks,
Jeff
Thanks for looking at this. First, there is a button called Users on the web server main screen. Use this to add a user, username goes in the email field and password in the password field. I used admin/ admin.
Log in and then click on Specimen in the first menu. Enter any data you wish here. Note the Pathology Complete check box defaults to No. This is of course the parent file. Next, go to the Pathology tab. Insert a new record, entering any data you wish. The idea here is for a Pathologist to enter data in multiple sittings. When complete they are to mark Pathology Complete in the pathology data section. When this is done, I would like three fields in the parent (specimen) file to be updated automatically. First, the date should be set to the date pathology was completed. Then the case number should be set to source + specimen ID. Finally, pathology complete should be set to yes as it is in the pathology file.
In an earlier NT version, I had placed the following code in validate update:
If pth:pathology_complete = 'Yes'
Spe:specimen_id = pth:specimen_id
Access:specimen.fetch(specimenid_key)
Spe:date = today()
Spe:case_number = spe:source&'-'&spe:specimen_id
Spe:pathology_complete='Yes'
End
This does not seem to work in NT 6.22. I hope I gave you enough here to get you started.
Thanks,
Jeff
398
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: February 29, 2012, 06:36:47 AM »
Kevin,
Sorry! Here is the attached file, I hope.
Jeff
[attachment deleted by admin]
Sorry! Here is the attached file, I hope.
Jeff
[attachment deleted by admin]
399
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: February 28, 2012, 05:41:24 PM »
Kevin,
Thanks...I have it now. I ran debugview and saw the first message "'test specimen update". Then saw two error messages: UpdatePathology_xxx_validate and UpdateSpecimen_xxx_validate.
I have updated to the most recent NT (6.22) but still have this issue. I have uploaded a file called RiskComp2.zip containing the log output and my app, should anyone wish to take a look.
Thanks,
Jeff
Thanks...I have it now. I ran debugview and saw the first message "'test specimen update". Then saw two error messages: UpdatePathology_xxx_validate and UpdateSpecimen_xxx_validate.
I have updated to the most recent NT (6.22) but still have this issue. I have uploaded a file called RiskComp2.zip containing the log output and my app, should anyone wish to take a look.
Thanks,
Jeff
400
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: February 28, 2012, 12:35:17 PM »
Kevin,
When I do this, where do I see the messages/results? Is this where I run Dr. watson and look for messages in the event viewer?
Thanks,
Jeff
When I do this, where do I see the messages/results? Is this where I run Dr. watson and look for messages in the event viewer?
Thanks,
Jeff
401
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: February 27, 2012, 08:51:26 PM »
I confirmed that Pth:Specimen_ID has the correct value and that the Fetch returns 0 (level:benign). I added the UseFile as well. I have been trying other embeds but still no luck.
Jeff
Jeff
402
Web Server - Ask For Help / Correction: Re: Update parent field when value entered in child
« on: February 27, 2012, 05:10:04 PM »
I was wrong here. Using this method only updates the queue of the browse. When I actually open the record the data has not been updated. In my parent browse I place the following code in the SetQueueRecord embed:
If Pth:Pathology_Complete = 'Yes'
Spe:Case_Number = Spe:Specimen_Source&'-'&Spe:Specimen_ID
End
The parent file is Specimen.tps and the related child file is Pathology.tps. In an earlier version of NT (I forget the actual version) I place the following code in the ValidateUpdate (Start) embed:
Spe:Specimen_ID = Pth:Specimen_ID
If Access:Specimen.Fetch(Spe:SpecimenID_key) = Level:Benign
Spe:Case_Number = Spe:Specimen_Source&'-'&Spe:Specimen_ID
Access:Specimen.Update()
End
This worked in the earlier NT version but not in NT 6.21. The Spe:Case_Number field was filled in when I returned to the parent browse. Any thoughts?
Thanks,
Jeff King
If Pth:Pathology_Complete = 'Yes'
Spe:Case_Number = Spe:Specimen_Source&'-'&Spe:Specimen_ID
End
The parent file is Specimen.tps and the related child file is Pathology.tps. In an earlier version of NT (I forget the actual version) I place the following code in the ValidateUpdate (Start) embed:
Spe:Specimen_ID = Pth:Specimen_ID
If Access:Specimen.Fetch(Spe:SpecimenID_key) = Level:Benign
Spe:Case_Number = Spe:Specimen_Source&'-'&Spe:Specimen_ID
Access:Specimen.Update()
End
This worked in the earlier NT version but not in NT 6.21. The Spe:Case_Number field was filled in when I returned to the parent browse. Any thoughts?
Thanks,
Jeff King
403
Web Server - Ask For Help / Re: Update parent field when value entered in child
« on: February 26, 2012, 07:46:22 PM »
I found a solution. The files are related so I placed the field from the child in the parent browse. Now there is no need to try and update a coresponding field in the parent.
In addition, I can use this child field to conditionally complete other parent fields by coding in the 3 Inside Browse Loop embed.
Thanks,
Jeff
In addition, I can use this child field to conditionally complete other parent fields by coding in the 3 Inside Browse Loop embed.
Thanks,
Jeff
404
Web Server - Ask For Help / Update parent field when value entered in child
« on: February 25, 2012, 02:31:07 PM »
Bruce,
When I enter a value in a field in a child record, upon saving the child record I want to update a similar field in the parent record. I used to use validate Insert/validate Update embed in an earlier NT version but in 6.21 this does not seem to work. What is the recommended method to do this and the recommended embed?
Thanks,
Jeff King
When I enter a value in a field in a child record, upon saving the child record I want to update a similar field in the parent record. I used to use validate Insert/validate Update embed in an earlier NT version but in 6.21 this does not seem to work. What is the recommended method to do this and the recommended embed?
Thanks,
Jeff King
405
Web Server - Ask For Help / Re: SSL: Always redirect to secure site not workin?
« on: February 15, 2012, 07:04:03 AM »
Bruce,
I confirmed that when I turn off "suppress errors" I get the error message you mentioned. However, it seems this is due to the certificates folder, with your settings.crt, not being present in the example app. So I added my own self-signed SSL certificate and redirection does seem to work as expected.
Sorry, my mistake, I should have checked for the certificates folder first. I'll wait for the 6.19 update and test again with my own app.
Thanks,
Jeff
I confirmed that when I turn off "suppress errors" I get the error message you mentioned. However, it seems this is due to the certificates folder, with your settings.crt, not being present in the example app. So I added my own self-signed SSL certificate and redirection does seem to work as expected.
Sorry, my mistake, I should have checked for the certificates folder first. I'll wait for the 6.19 update and test again with my own app.
Thanks,
Jeff