Forums (Obsolete)

Portal Engine Questions on portal engine and web parts.

Version 6.x > Portal Engine > Can't recreate ItemOrder column, and can't create column leveraging numeric up down selector

View modes:

Member

joeh42 - 4/18/2012 4:21:53 PM

Can't recreate ItemOrder column, and can't create column leveraging numeric up down selector

I have a custom table. I created it without an ItemOrder field. Now, of course, I want to add it back in.

I went to add a new column named SortOrder. I input the following settings:
* Integer number
* Field caption: Sort order
* Form control type: Input
* Form control: Numeric Up/Down selector

But Kentico reports 'Invalid control settings value' because I haven't specified a data source ('Please enter some options').

How can I add the ItemOrder field back into my custom table, or create my own sort order column, leveraging the numeric up down selector?

Certified Developer 9

charbf - 4/18/2012 8:32:55 PM

RE:Can't recreate ItemOrder column, and can't create column leveraging numeric up down selector

Hi,

You can create a new custom table as you want it. Then you can use the Kentico Import Toolkit to take all the data and insert it in the new table.

alternately if you might want to use the same codename for the new table

1. Transfer the data to temp table (using SQL Manager)
SELECT * INTO Temp_Table
FROM customTable_with_No_Order;

2. Delete the customTable_with_No_Order

3. Create a new customTable_with_Order

4. Use the Kentico Import toolkit

ATTENTION : Make sure you have a backup!


Member	joeh42 - 4/27/2012 5:02:52 PM RE:Can't recreate ItemOrder column, and can't create column leveraging numeric up down selector I was hoping for a more straightforward ability to modify the existing table, but thank you for letting me know this work around would work!

Top