User 73ad691ca3
08-03-2013 11:41:04
Dear Chemaxon Team,
We want to delete the rows from a structure table based on the cd_ids using Jchem .Net API.
Jchem .Net API class details:
chemaxon.jchem.db.UpdateHandler.deleteRows(conh, "table1", "WHERE cd_id IN (23, 247, 786) ");
Is there any limitation in the where clause - in condition (like the oracle support limited number of values in the static where in clause)?
Will It support lakhs of numbers in the where clause.
Please reply us ASAP.
Thanks & Regards,
D. Senthil kumar vijai.
ChemAxon a9ded07333
08-03-2013 14:21:37
Dear Senthil,
When you use it in a parameter, the IN clause should satisfy your database specific limitations - e.g. maximum 1000 IDs in case of Oracle.
Best regards,
Tamás
User 73ad691ca3
08-03-2013 15:18:59
Dear Tamás,
Thanks for your reply.
I was expecting this in the Jchem.
Is there any functionality/option in the Jchem to delete the rows from the structure table with more than 1,000 cd_ids.
I think jchem depends on the oracle, in this case.
I think JchemSearcher/Exporter classes can handle n-number of cd_ids in case of filtering the records from a table.
So, I am looking this kind of feature in the delete functionality.
Thanks & Regards,
D. Senthil kumar vijai.
ChemAxon a9ded07333
11-03-2013 13:24:08
Dear Senthil,
Unfortunately at the moment we don't have a method that would support unlimited cd_id lists in case of deleting rows.
You have to iterate over your cd_id list programmatically to split it up into smaller packages in order to use them in the IN clause of SQL sentences.
Best regards,
Tamás