How to custom view form of "Customer Table" for "View" action

Thawatchai Kongsuk asked on April 25, 2022 14:06

First, We create custom table "TB_Test001" and have fields as below

  • FLD_A
  • FLD_D
  • FLD_F
  • FLD_B

Second, We re-arrange field sequence as below

  • FLD_A
  • FLD_B
  • FLD_D
  • FLD_F

The Insert or Update action display fields as our order, but the "View" action show fields as actual in database as below

  • FLD_A
  • FLD_D
  • FLD_F
  • FLD_B

How to set the view form to display fields as our ordered. (Same as Insert or Update form)

Recent Answers


Brian McKeiver answered on April 25, 2022 16:36

After a change to the custom table (such as reordering the fields), you normally can do a full restart of the admin tool in Visual Studio (when running locally) or touch the web.config on a deployed server instance, and the system should pick it up without issue (this action resets the cache). If that still isn't working, in rare situations you might need to just regenerate the View in SQL using sp_refreshview 'viewname', but this is very rare.

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.