openmolecules.org

 
Home » DataWarrior » Functionality » Database connection (Loading fresh data from database on file open)
Re: Database connection [message #1389 is a reply to message #1386] Wed, 01 September 2021 13:17 Go to previous messageGo to previous message
thomas is currently offline  thomas
Messages: 655
Registered: June 2014
Senior Member
I am not sure, whether I understand the question. If you query a database, e.g. Chembl, then the result is a subset in an open DataWarrior window. If you save the window, the subset is stored in a file. If the original Chembl database is updated, it does not change the saved file.

You may, of course, create a macro that queries the Chembl database, creates views, merges other data, or does some other fancy stuff with the query result. If you run the macro at a later time after Chembl update, then it does the same thing with the the query result of a different, up-to-date query result.

This applies to all databases that DataWarrior is able to query including your in-house databases if you use plain SQL or have build a plugin for.

Does this answer the question?
 
Read Message
Read Message
Read Message
Previous Topic: Freeze panes
Next Topic: Box Plot - Statistics
Goto Forum:
  


Current Time: Fri May 03 12:31:41 CEST 2024

Total time taken to generate the page: 0.04762 seconds