General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
It seems that your line:
update timeusernew set user_name="blahblah" where assoc_id > 3000
should be changed to:
update timeusernew set user_name="blahblah" where assoc_id > 3000 and assoc_id <=5000
>>>>>>>>>>>>>> your message below
I have a column for a security level on a table-buffered table. I created the update trigger below, but when I fire the command below, rows that have a value above 5000 still get updated. Help?
function updcheck
cOldName = oldval("user_name","timeusernew")
if assoc_id > 5000
user_name=cOldName
endif
return .t.
update timeusernew set user_name="blahblah" where assoc_id > 3000
I even tried to put "skip" inside the if...endif code but VFP choked on that too.
VFP6/SP4.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only