Delete Index lives on

[hmei...@telstra.com]

Hi Rise User Community,

I just started looking at Rise Visual Modeling and after pasting part of one model into another I came across the following error in the code generator: CSQLIndex: indexed column 'Site' not found in table 'ArticleHint'!

Investigating that error I deleted, recreated and finally deleted the index again. Now I'm puzzled why the index continues to show up inside the entity -- in fact it shows it twice.

Can anyone help me with instructions on how to properly remove an index?

Also please help me understand why I continue to get the error message when I generate the code even though the index is removed? I guess it is because the index lives on somewhere hidden -- Is this true?

Thanks, Henk.

[Henk Meijerink]

Oh, and the code generator I'm using is
RISE.CodeGenerator.SQLServer.exe

[Joar Swenning]

Hi Henk,
What you will need to do to fix this is to refactor the model file (in
the file menu).

We have managed to reproduce this behavior and as it turns out you
have found an error in how the copy-paste functionality works with
indices. What has happened here is that RISE has created the index
before the underlying relationship is created. We will of course work
on a solution to this.

I hope this helped and I apologize for the inconvinience.

Best regards,

Joar Swenning
RISE to Bloome Software

[Henk Meijerink]

Thank you very much Joar. I love your editor and appreciate your quick
response. Cheers, Henk.