Changing SPROC breaks TypedView on same

Posts   
 
    
morten71
User
Posts: 80
Joined: 13-Jan-2009
# Posted on: 02-Mar-2018 14:40:05   

Using 5.3.3, LLBLGEN pro runtime framework, selfserving.

If I change a stored procedure (i.e. add/remove column) the sync relational model data process ends up with as many errors as there are columns for the TypedView based on the same stored procedure.

I then remove the TypedView and add it again. And then things work.

Am I missing a project setting?

Best regards Morten

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39613
Joined: 17-Aug-2003
# Posted on: 03-Mar-2018 10:58:49   

Did you check the proc for resultset retrieval and is the resultset the same as before or similar? Is the typedview still mapped onto the stored proc resultset ? (but columns are not matching) ? What are the errors exactly? (that might help wink )

Frans Bouma | Lead developer LLBLGen Pro