SQL Field Datatype changed... Need to republish?

  • 3 December 2018
  • 3 replies
  • 1 view

Userlevel 3
Badge +16

Hi,

 

Connecting to a SQL instance and table on a seperate SQL Server. (Not K2, its a SQL DB elsewhere)

 

Created and Published the table using the tester tool. One of the fields was integer datatype.

 

Now the DB owner has changed field to decimal(6,0,null).

 

My question is, do i need to re-create/publish the table again? Or will K2 pick up the changes automatically?

 

Thanks


3 replies

Userlevel 5
Badge +13

You will need to refresh your SQL service instance in the K2 Management site (or the SmartObject service tester tool) to make it regenerate the interface to your table to match your changes.

Badge +9

The SmartObject will need to be recreated/republished using existing GUID, in order to see the change on the SmartObject as well.


 


K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.

Userlevel 3
Badge +16
thanks. keeping existing GUID helped

Reply