Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check fields for changes
Message
From
12/07/2005 12:55:49
 
 
To
12/07/2005 12:06:15
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01031731
Message ID:
01031766
Views:
13
Hi Gregory,
Unfortunatly, I do not have my programs in n-tier set up. I just have the vfp base class that does my adding, editing and deleting of records for me. I do my record checks on the form.

Thanks Anyway,
Beth
>hi Beth,
>
>Why not move the logic to the Record Validation rule
>
>- only one place
>- buffering does not matter in triggers and Record Validation rules
>
>you can use a combination of getfldstate(-1) and FieldChanged() below
>
>
>function FieldChanged(FieldName)
>
>	do case
>	case isnull(oldval(m.FieldName)) or Isnull(eval(m.FieldName))
>		return (isnull(oldval(m.FieldName)) <> Isnull(eval(m.FieldName)) )
>	otherwise
>		return (oldval(m.FieldName) <> eval(m.FieldName))
>	endcase
>endfunc
>
Previous
Reply
Map
View

Click here to load this message in the networking platform