ESdat Forums
»
Forums
»
ESdat
»
Adding a new column (field) to table(s)
 Rank: Member
Groups: Registered
Posts: 29  Location: Calgary, Alberta, Canada
|
Hello, I have a need to add a column to at least one table in the database in order to flag if a location is "On Site" or "Off Site". Being able to filter data according to this flag would help greatly with some of our analysis. I wonder how easy/difficult it would be to do this. I know that I have seen information to this regard before, somewhere in the ESdat website, but cannot seem to find it again. I have a basic knowledge of relational databases and should be able to get the job done with some gentle guidance. I am not sure off hand which tables would need to be able to reference this information, but at the very least need it on the HGSite1_Locations table. Thoughts? Advice? Thanks in advance! Brad Camroux
|
|
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Posts: 498 Location: Byron Bay Was thanked: 19 time(s) in 19 post(s)
|
Hi Brad, It appears you have the SQL Server version of ESdat, so to make that change you will need a copy of SQL Server Management Studio, appropriate permissions to change the tables, and knowledge of how to add an additional column to a field. See http://www.ESdat.net/ESdathelp/customisingdata.htm. If you have all that it is straightforward, otherwise you may need to engage your support (Dataforensics?) to complete it for you. Warwick
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Adding a new column (field) to table(s)
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.