Project

Profile

Help

Forums » Help »

Problem with SQL extension

Added by Svend Ole Nielsen over 5 years ago

Hi all

I'm having a problem where I'm trying to delete data using the sql extension. The problem seems to be related to the WHERE-clause. Whenever it is trying to run the delete, it complains that it can't find the column. The problem seems to be that the extension is wrapping the entire WHERE-clause in quotation-marks. If using the same WHERE-clause in an update or select, there are no problems.

So - do anyone have any idea as to why it does not work in delete? The WHERE-clause is always build using the concat function. And the version running is an old 9.5 due to dependency problem with other parts of the system.

Regards, Svend O.


Replies (1)

RE: Problem with SQL extension - Added by Michael Kay over 5 years ago

We don't have a vast set of tests for the SQL extension, but there is a test that we run regularly using a DELETE-WHERE that runs without trouble, so it's not a case that the feature simply doesn't work. Are you quite sure that the problem isn't in your code?

I would suggest trying to put together a minimal repro that demonstrates the problem. I know that's tricky when a database is involved, but I think that's the best way forward.

    (1-1/1)

    Please register to reply