Right, umm...

[Shard]

I added roughly 300+ items to the server, in Access, then imported them into SQL, and SQL, being the joking type of program Microsoft would make to piss people off, decided to mess up all the Idx in my Stditems table. They aren't in any type of order at all.

Soooooooooooo...

I made some SQL Syntax code thingy or whatever it is, to organise the Stditems table so that all the Idx were in order. This worked fine, until I exited Enterprise Manager. I ran eiserver.exe and I got the Stditems load error (The Idx weren't in order -.-). So I went back into Enterprise Manager and looked at Stditems, and they were all messed up again. I ran the code again, and tried again, still doesn't work. So I was wondering if there is some kind of Save function on Enterprise Manager, or if not, could anyone shed some light on what I can do to solve this problem?

Tyvm in advance.

/Shard

 

[Demonic]

Easy dude, right click Design on your database (StdItems) right click IDX and set as Primary Key - close the box and it asks you if you want to save - say yes. Now StdItems will always have them in the right order.

You can do the same with Mobs but it wont allow save if there is two mobs the same, good way to check though.

 

[Shard]

:O It worked! You absolute god! Now my DB has 882 items, and they're all superstats. Might make the first super stats Mir3 server...who knows? :P

 

[Vyse]

go matt go matt gogo go matt :dance: