Este comando esta dando erro me ajuda fazendo favor

0 respostas
mysql
Mailson_Carvalho

___________________________________________

let RG_Nr := (select ‘1_Client Orders’)[‘Invoice No.’ like format(today(), “YYMMDD”)].‘Invoice No.’;

let mytodayNr := number(max(RG_Nr));

if number(RG_Nr) < [telefone removido] then

‘Invoice No.’ := text(“B_” + number(format(today(), “YYMMDD”)) + “0001”)

else

‘Invoice No.’ := text(number(mytodayNr + 1))

end


Criado 2 de junho de 2019
Respostas 0
Participantes 1