Fixed values in Delete SQL

, ,
1

Hi,

When trying to create an adapter for DeleteSQL, if we want to gove fixed values, for Strings do we need to specify single quotes?

For example

Name is a String and when giving a value for it in the input filed do I need to specify as ‘string’ or is not needed?

Regards,
Rekha

2

In general we need to provide string in single quotes for db

ex: SaleTag = ‘ABCD1234’

3

It depends on exactly where you are providing the fixed value. If in the adapter service on the Where tab then you’ll need the quotes. If the constant is being passed via parameter, then when calling the delete adapter service the input parameter does not need the quotes.

4

Thank you all.