I need to delete information that is in my database, using Sql Advanced, but writing:


delete from {table}

where {table}. [Id];

commit;


Is not working.

Solution

Hi Jonatas, Using cruds inside SQL Advanced, you always have to put in blocks!


Begin

delete from {table}

where {table}. [Id];

commit;

End;


If you run this Sql as 'Test', it will give an error, but the operation will run, but if running at runtime will not display any errors. Fits 'Updates' as well.

Solution