06-11-19 10:48 PM
06-11-19 11:21 PM
07-11-19 10:11 AM
Hi,
Two suggestions:
1. Error in the SQL you Posted
Part of the insert has an extra inverted comma, on line 25 in the attached image. when you are inserting the value: [Data de Nascimento].
Look at the image attached, using a IDE or some application to illustrate these kinds of problems can be very useful. I am using MS SQL Server.
But NotePad++ is an excellent option to help with this as you can select from many languages and simple errors like this will appear immediately.
If this does not work, please post the actual error you are getting.
2. Confirm all the data types are correct
Make sure the data being entered in each column of the SQL table matches the datatype in the Blue Prism. I have no way of seeing either your Blue Prism datatypes or the MS SQL table.
Also good luck with the job thing. Look at a few free courses on Udemy or Codecademy.
Kind regards,
Ben
Also used Google translate to help because you might be stressing out and English is not your first language but generally I believe this forum is for English only.
Em português (google translate), há uma vírgula invertida extra onde você está inserindo o valor "[Data de Nascimento]". Exclua a vírgula invertida extra e a consulta SQL estará correta. Ainda pode haver outros problemas, como tipos de dados que não estão corretos.
07-11-19 01:49 PM
07-11-19 06:23 PM