openmolecules.org Forum: Cheminformatics

Home » DataWarrior » Cheminformatics » Link to oracle per row

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

Link to oracle per row [message #1850]

Fri, 17 February 2023 17:28

de_maas
Messages: 2
Registered: February 2023

Junior Member

Hi All,

I want to retrieve data from my oracle database using an id stored in my Datawarrior file. Is it possible to pass a identifier to the SQL somehow? I tried this but it isn't working:

SELECT AVAILABILITY
FROM availability_info
WHERE description=$idnumber

I can't find the right synthax to do this. Same goes for the URL.

Thanks,

Peter

Report message to a moderator

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

Sun, 19 February 2023 20:28

thomas
Messages: 715
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

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

Mon, 20 February 2023 10:28

de_maas
Messages: 2
Registered: February 2023

Junior Member

Thanks Thomas,

This already is a nice feature for me and merging works fine.

Cheers,

Peter

Report message to a moderator

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: Thu Nov 21 18:41:44 CET 2024

Total time taken to generate the page: 0.03304 seconds