>MyTable has 3 fields: cName, cName2 and cNameSearch.
>cName2 is used for cName change and cNameSearch to optimize search.
>When cName2 is not empty its lower case value must be copied
>in cNameSearch otherwise the cName will be. I would like to use trigger
>update (in the table) for that. But I do not know what enter in the
>"update trigger" field in the table properties. Someone could show me
>the way to do a trigger in VFP? Thank you very much.
You would enter the name of a function, typically a stored procedure in the table's database. e.g., if your procedure name is
UpdateName
then put
UpdateName()
in the Update trigger box.
If you need any parameters, make sure those are in there as well. e.g.,
UpdateName(cName, cName2)
Insanity: Doing the same thing over and over and expecting different results.