Form level X-basic

[Ohlen Cartmell]

How do you blank a date field and change a logical field at form level with a button script. For the date is it:

formname:fieldname.value="" or formname:fieldname.value={}

and for the logical

formname:fieldname.value=F or formname:fieldname.value=.F.

or is some other combination required?

I can't get the X-basic to work at form level no matter what I try.

[Stan Mathews]

RE: Form level X-basic

Table.field_blank()
Syntax:
.field_blank( Fieldname String)
Description:
Blank the contents of a field.
Example:
� set the logical field �reserved� to be unitialized
� (not explicitly TRUE or FALSE)
tbl.change_begin()
tbl.field_blank(�reserved�)
tbl.change_end(.T.)
See Also:
.blank_put(),.is_blank()

[whanigsberg]

RE: Form level X-basic

Hi Ohlen:

Believe it or not you need
parentform:Manufacture_Date.text=""
because (I think) when you write to the control you are writing text into the record buffer but that text doesn't take on a data type until the record is saved. (Take all of this with a grain of salt. I know very little about the internals.) But once the record has been saved you can access the saved information by data type which is what the control's value property holds.

I just verified this in the interactive window using a test form.

Similarly, you write "F" into a logical field's control.

Is this confusing or what?

Bill

[whanigsberg]

RE: Form level X-basic

And as Stan reminds us, blank_put() is probably the best method unless one has a need to explicitly write into the control rather than to the table.

Bill

[Ohlen Cartmell]

RE: Form level X-basic

Stan,
Thanks. I had gotten it to work in the background but hadn't thought of the methods you suggest. I wanted to try using the form objects since I can do that without putting the table into change mode until I hit the "Save" button ( I think).

Bill,
Thanks for the suggestions. I'll give them a try this evening.

[Willard]

RE: Form level X-basic

Hi Ohlen, I agree most of the time it is good to place the values within a form and use this form as a true worksheet. Then when all the values are as we wish then the save button does the rest. (As a rule I use value for all numbers and dates, and text for all memo, character fields) I believe value places the form in change mode. I have found that this works
dim f as p
f=parentform.this
f:date.value={}
f:logic.text="T"
F:date.refresh()
f:logic.refresh()
end

Jack

[whanigsberg]

RE: Form level X-basic

Hi Jack,

I am unable to get the following syntax to work:
parentform:Manufacture_Date.value={}
It throws the form into change mode but nothing else happens event if I manually refresh the form.

Have I overlooked something?

Thanks,
Bill

[Jim Rowlen]

RE: Form level X-basic

Might it use parenthesis instead of brackets?

[Willard]

RE: Form level X-basic

Well You are right Bill, I cannot get the value to work but the text works
f:Date.text="" Jack