• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
affect vs effect

#9
(03-27-2017, 09:42 AM)dave friend Wrote:
Quote:"affected rows" makes it an adjective, right?

Essentially, yes. Verbs can become adjectives by turning into participles. (Sorry you asked yet?)
Participles are verb forms ending in ‑ing (present participles) or -ed or -en (past participles) that modify nouns.

While effect is usually a noun, it can be a verb when used in the sense of to bring about e.g. "The update method is used to effect change on the rows." However, once the method has run we would want to know which (or how many) rows were affected not effected.

So, for me, the correct DB function name is affected_rows.

In the interests of full disclosure, there are cases where a noun can act as an adjective e.g. "ticket office".  Rolleyes


This sounds like the best answer to me. I might have learned about participles if I had paid attention in school, but that was over twenty years ago. I really hated English class.
Reply


Messages In This Thread
affect vs effect - by skunkbad - 03-23-2017, 02:53 PM
RE: affect vs effect - by InsiteFX - 03-23-2017, 04:14 PM
RE: affect vs effect - by skunkbad - 03-23-2017, 04:26 PM
RE: affect vs effect - by markusnippet - 04-04-2017, 04:32 AM
RE: affect vs effect - by JayAdra - 03-23-2017, 05:09 PM
RE: affect vs effect - by skunkbad - 03-23-2017, 07:50 PM
RE: affect vs effect - by JayPatel - 03-27-2017, 11:17 PM
RE: affect vs effect - by llebkered - 03-24-2017, 01:47 AM
RE: affect vs effect - by PaulD - 03-25-2017, 08:55 AM
RE: affect vs effect - by dave friend - 03-27-2017, 09:42 AM
RE: affect vs effect - by skunkbad - 03-27-2017, 03:06 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2019 MyBB Group.