ESdat Forums
»
Forums
»
ESdat
»
Change Site ID in SQL Version
 Rank: Member
Groups: Registered
Posts: 24  Location: Edmonton
|
Hello Alex I understand that the Project ID and Site ID are primary keys within the SQL database. However, if someone has entered the wrong Site ID, is there a way to edit the ID either a) within ESdat or b) through a SQL key conversion script? If b), is there a pre-made file for this? (we are using the latest SQL version 4.4.12) Any assistance would be great. Thanks Eric
|
|
|
|
|
|
 Rank: Administration
Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hello Eric, You can rename a Site or Project in the SQL Server version under File - Site/Project Association. Right click any Site/Project to rename. Regards, Warwick
|
|
|
|
|
|
Rank: Member
Groups: Registered
Posts: 24 Location: Edmonton
|
|
|
|
|
|
|
 Rank: Newbie
Groups: Registered
Posts: 1 Location: Sydney
|
Hi Warwick, A couple of us have been unable to rename the Site_ID in our SQL database. we have attempted to use the method as outlined below and it returns the following error message. "37200 The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_Locations_Sites_Projects_SIDPID". The conflict occurred in database "ESdat_HG", table "dbo.Sites_Projects". Any idea what the problem may be? Regards Chuck Terhune
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
The user is going to wait for ESdat 5 to be released in a few weeks, which will resolve this.
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Change Site ID in SQL Version
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.