openmolecules.org Forum: Cheminformatics

Home » DataWarrior » Cheminformatics » Link to oracle per row

Show: Today's Messages :: Polls :: Message Navigator

Re: Link to oracle per row [message #1851 is a reply to message #1850]

Sun, 19 February 2023 20:28

thomas
Messages: 731
Registered: June 2014

Senior Member

I just deployed an update that allows exactly that: Using "IN($IDNUMBER)" in the WHERE clause of an SQL statement does an on-the-fly replacement with all entries from the IDNUMBER columns to "IN('entry1','entry2','entry3',...)". If the idea is to merge the retrieved information with the currently open file, this still has to be done in a separate step.

Thomas

Report message to a moderator

[Message index]

		Link to oracle per row By: de_maas on Fri, 17 February 2023 17:28
		Re: Link to oracle per row By: thomas on Sun, 19 February 2023 20:28
		Re: Link to oracle per row By: de_maas on Mon, 20 February 2023 10:28

Previous Topic:	Generate 2D atom coordinates gives overlapping atoms
Next Topic:	Searching multiple structures in Google patents via "selected compounds"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Jun 04 11:42:39 CEST 2025

Total time taken to generate the page: 0.21058 seconds