Skip to main content
Solved

Error in SQL Snippet

  • January 13, 2023
  • 1 reply
  • 77 views

rvgfox
Problem Solver
Forum|alt.badge.img+4

Hi, with this snippet:

 

 

I get an error in deploy:

 

The sippet it’s correct as you can see in:

 

Best answer by Stefan

Hi,

If you remove the [] around Telefono it will work.

 

To visualize the code that will be used you can right-click on the table and  select Customize Code,  click Add on Transformation View and you will see that in your code you will have double [[ and ]] around Telefono. So TimeXtender actually adds them for you.

 

Thanks and good luck

Stefan

1 reply

Stefan
Employee
Forum|alt.badge.img
  • Employee
  • Answer
  • January 13, 2023

Hi,

If you remove the [] around Telefono it will work.

 

To visualize the code that will be used you can right-click on the table and  select Customize Code,  click Add on Transformation View and you will see that in your code you will have double [[ and ]] around Telefono. So TimeXtender actually adds them for you.

 

Thanks and good luck

Stefan