Is there a way to "undo" a column deletion

User 4013b016ec

09-07-2010 20:01:34

So I'm new to using JChem and as I was poking around the software trying to figure out how to promote/hide columns I deleted a column. 


I did this by trying to delete a field and not un-checking the "also delete related column" check box since I didn't understand what it did at the time. 


So now I've been trying to figure out if there's a process for simply adding the column back into the table. If anyone could let me know how to do this or, at least, point me to the right place in the documentation that would be great. 


Thanks,


Brice Olion


Other Info:


- My project is connected to a MySQL database (which still contains the column I want)


Instant JChem Version: 3.0 (build: 090927)


JChem Version:
5.2.5.1


JChem Table Version: 5020400
Marvin Version:
2009-09-25 (build date: 2009-09-25)
Java: 1.6.0_13; Java
HotSpot(TM) Client VM 11.3-b02
System: Windows Vista version
6.1 running on x86; Cp1252; en_US (instantjchem)
NetBeans build:
200906241340     

ChemAxon fa971619eb

12-07-2010 07:28:58

No, I'm afraid that once you check that chcekbox and tell the database to delete the column then it is gone for good. You can add back a new column, but the data will be gone.


Tim

User 4013b016ec

14-07-2010 16:16:56

Thanks for the response. Glad I found that out before I deleted something important.