Auto Arrange?

[Geordiehc]

Whenever i add a new line to SQL in mobs it jumbles them all up, is there anyway to make it so it always keeps the last entry at the very bottom?

 

[idaBigA]

I have this problem sometimes I will add one to the bottom and it will chuck it in the middle somewhere.. it never jumbles them though.

No idea on a fix.. but would be interesting to find out.

/Mick

 

[T0MMY]

Hmm, never come accross this. Fingers crossed i don't. So your saying you have to re-do all the item ids?

 

[idaBigA]

This is talking about the mobs, which doesn't really matter what order they are in (apart from to find things). I had this problem once on the items, but the idx wasn't set as the primary key.

 

[Geordiehc]

I have this problem sometimes I will add one to the bottom and it will chuck it in the middle somewhere.. it never jumbles them though.

No idea on a fix.. but would be interesting to find out.

/Mick

yeah thats what i meant as well, glad to see im not the only 1 with this problem, guess il have to bare with it, you wer saying idx being primary key, cud this be done ion mobs to alphabetically sort them?

 

[idaBigA]

Yeah, I don't see why not.

 

[chimera]

Yes you can put any sort order you like in, just go into design table and then manage indexes, set the column to use as the index and ascending/descending

You can do this with any database field.

 

[Geordiehc]

cool cheers m8s

 

[T0MMY]

Well if it can be countered by this, then not much of a problem but i see how it could get annoying.

 

[idaBigA]

Mine are sorted by Area, so I don't use this option. If I add one and it moves it somewhere I don't want I just extra them re-order and then import them.

 

[Geordiehc]

Yes you can put any sort order you like in, just go into design table and then manage indexes, set the column to use as the index and ascending/descending

You can do this with any database field.

iv tried this a few times and doesnt seem to work :cray:

 

[chimera]

Works for me, are you saving the changes?

 

[Geordiehc]

Works for me, are you saving the changes?

yeah then i go back into it and its exactly the same o.o im using excel and just imported them back in anyways but weird how it all happensto me lol, ty bro