Hi,


In version 10, i can delete data using advance query, why in version 11 i can not do this?


Cheers

Solution

Hi Thiago,


Try this:

begin
DELETE FROM ...
WHERE ...
exec('co'+'mmit');
end


Best regards,

João Campos

Solution

Hi Thiago Mari,

If you are trying to execute your advance SQL in test mode (without publishing it and testing it ), then it will not do so as it now been restricted by outsystems.


João Campos wrote:

Hi Thiago,


Try this:

begin
DELETE FROM ...
WHERE ...
exec('co'+'mmit');
end


Best regards,

João Campos

Hi João,


Thanks, this works fine!