Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Sat, Jun 23 2018 6:55 PM	Permanent Link
Ian Branch	Hi Team, When setting a column as Generated, what is the difference between 'Always' & 'By Default Only'? Pros & Cons of each mode? Regards, Ian
Sun, Jun 24 2018 2:58 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian >Hi Team, > When setting a column as Generated, what is the difference between 'Always' & 'By Default Only'? > Pros & Cons of each mode? ALWAYS - the value is set by the engine and is not changeable BY DEFAULT - the engine will set it if it isn't already set and it can be edited I think that basically gives you the pros & cons as well. Memory says that converting tables will result in BY DEFAULT otherwise it would screw up foreign keys Roy
Sun, Jun 24 2018 5:33 AM	Permanent Link
Ian Branch	Hi Roy > > ALWAYS - the value is set by the engine and is not changeable > Hmmm. I had it set as Always and RESTART set it correctly. > > Memory says that converting tables will result in BY DEFAULT otherwise it would screw up foreign keys > Ahhh. Ian
Sun, Jun 24 2018 8:20 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian >> ALWAYS - the value is set by the engine and is not changeable >> >Hmmm. I had it set as Always and RESTART set it correctly. That's why I said edited. Using RESTART isn't editing Roy