Stditem.db error "HeLp"
Cant Load It can u tell me how to fix this pleas
Attach Pic pleas take A Look
Printable View
Stditem.db error "HeLp"
Cant Load It can u tell me how to fix this pleas
Attach Pic pleas take A Look
Stditems database is Out of Sync, does not start at 0 or has numbers missing.
Best way is to Sort by Key, to do this you:
Design Database (one of the right click options)
Select IDX
Assign Primary Key
It then says do you want to save when you finish the screen (close it in other words)
If it wont let you save due to a duplicate, thats something you gootta sort out.
Tnx Sir For Replying anothere error pop up again in the sql whil puting the key
'Stditems' table
- Unable to create index 'PK_Stditems'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID 1. Most significant primary key is '0'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
How To Sort Out I dont Know How
Create another Column in that Stditems, call it INDEX or something (anything dont really matter), do a few drop downs and basicaly let it autonumber - sorry I cannot remember off hand, no SQL In fornt of me. Now what you can do is go through and find the duplicates, re-number then (on the original Index) and when all is finsihed, get rid of this new Column you made and you should be able to sort on it now... hope that all makes sense..
Tnx Sir I already solvr it by deleting the database "mir3db" Re making A new one
No Again Same Have Problem also the maps tnx for the help
i realy thank you for that "Rox"