dirty column

[richard2007]

i have a field which has its value set in the DialogValidate event

if e.DataSubmitted.client1 = "None" .and. e.DataSubmitted.client2 = "None" then
		e.control.completed = "Completed"
	else
		e.control.completed = "Not Completed"
	end if

i have made the field dirty in the afterdialogvalidate

e.dirtyColumns = e.dirtyColumns + crlf()+ "COMPLETED"

the correct value shows in the field once the submit button has been pressed but the value isnt being sent to the table.

can anyone let me know what i need to do or where i can find out. i have looked at a video making fields dirty but doesnt seemed to have helped.

[Davidk]

Re: dirty column

In your afterDialogValidate event, do you have

ExecuteServerSideAction("Save Data::Save")

to save the data?

I wonder what the difference is between using e.datasubmitted.controlname = "value" and e.control.controlname = "value". Both work in setting the value of the named control.

[richard2007]

Re: dirty column

yeah, i have the dialog saving the data.

all i need to do is set the value of a field in a related table based upon a users choice, i thought this was the right way to do it. any ideas?

[Davidk]

Re: dirty column

Using a MySQL table, I've found the same thing... the code you post does not change the table data.

Adding the following statements saves the data as well. Works here... hope it works for you.

if e.DataSubmitted.client1 = "None" .and. e.DataSubmitted.client2 = "None" then
                e.datasubmitted.completed= "Completed"
		e.control.completed = "Completed"
	else
                e.datasubmitted.completed= "Not Completed
		e.control.completed = "Not Completed"
	end if

[richard2007]

Re: dirty column

david, thanks for helping, but this still isnt updating my table (.dbf). the control is set correctly but the data isnt being saved.

lots of people must be setting and saving values, anyone want to share how your doing it?

[Davidk]

Re: dirty column

Can you zip your table and your dialog and post it here? Then I can see exactly what's happening... it would really help.

[richard2007]

Re: dirty column

i have zipped the table that i am having trouble saving data to. there is a related table 1:1 but i cant zip this tonight as it has all client data in it. there is only a couple of fields in the dialog from the main client table.

[Davidk]

Re: dirty column

Hey Richard,

I think you sent through an older dialog... it's not a dialog2 dialog... it's a dialog dialog - yikes... this is like the iPad 3...errr, the new iPad...

Is this the right one?

[richard2007]

Re: dirty column

sorry, that was the old one from v10 (which worked fine). correct one now attached.

[Davidk]

Re: dirty column

No idea why... but this fixes the problem... on my system anyway... I hope it does on yours... this is the sort of things you spend so much time on... and for what.

Add a crlf() to the end of your e.dirtyColumns statement... sheesh.

e.dirtyColumns = e.dirtyColumns + crlf() + "COMPLETED" + crlf()

Other stuff that got in your way is that your e.dirtyColumns statement appears AFTER your Action script for saving the record. Move this statement so that it executes BEFORE the save... otherwise the save cannot act on the changed control.

I hope that does it for you.

[richard2007]

Re: dirty column

David,

Thanks for your help, this worked for me. i then tried without the additional '+ crlf()' on the dirtycolumns and it still works. it must have been the positioning of the dirtycolumns code which i had put after the savedata function.

My app requires lots of validation like this, so this helps me a great deal.

thanks again.

[Davidk]

Re: dirty column

I just re-tried on my system and it also works without the extra crlf()... so that's good. Sheesh... looked at the data so many times.