Can I create a method that performs several updates in the Firebird database? For example, I want to update the following registry, but it would have to be one at a time, how to update otherwise?
UPDATE TVENPEDIDO SET NOTAFISCALSERVICO ='185...
I would like to make a update using a Inner Join .
I've tried this:
UPDATE m SET m.rua = 'Rua Major Gote', b.desc_bairro = 'Centro',
m.id_tipo = '', m.numero = '652', m.CEP = '38700001', m.cidade = 'Patos de Minas'
FRO...