Is there any difference between using:

SetField[Field, ""]

and

Clear[Field]

except that the field need to be on the current layout to use Clear?

I never use the "Clear" command; it has proven horribly unreliable. SetField[Fieldname, ""] does the trick very nicely.

quote:

---

Originally posted by danjacoby:

I never use the "Clear" command; it has proven horribly unreliable. SetField[Fieldname, ""] does the trick very nicely.

---

I agree with you. The only time I use Clear is for clearing date or time fields. The only reason I asked is because I seen some posts in the Forum that suggested otherwise. I wanted to be sure that I didn't miss something.

[ February 13, 2002, 02:21 PM: Message edited by: MattSBCNE ]

The way to 'clear"date and time fields is

Set Field [ Datefield, TextToDate("") ]

Set Field [ Timefield, TextToTime("") ]

I know it seems funnym but "" is text!

The main reason for using the Set Field command is that it will work no matter whether the field is on the current layout or not. Commands like Paste, Insert and Clear will only work if the field is on the current layout and you also have to have the "allow entry into field" option selected in the field format dialog. So, it's just a lot simpler and safer to use the Set Field command.

quote:

---

Originally posted by Vaughan:

The way to 'clear"date and time fields is

Set Field [ Datefield, TextToDate("") ]

Set Field [ Timefield, TextToTime("") ]

I know it seems funnym but "" is text!

---

Hey! That's a neat trick!

I wish I could claim credit for that, but I cannot. It's from the "Tips from Tech Support" menu in the New Database dialog box (the one that appears with the list of Templates). A couple of other neat bits of info in it too.

I'm tellin' ya. I have been developing solutions with FileMaker for nearly 10 years and consider myself to an advanced user. But, I never stop finding/learning new things about it.

I LOVE THIS PROGRAM!!