1. Community
  2. Studio
  3. Output
  4. Вопросы
0

SQL Error: Error converting data type nvarchar to int

Edgar Gárate 6 лет назад в Studio / Output • обновлен Grommit 6 лет назад • 4

Running the same example of the SQL video Connector in debugging mark data type conversion error, the stored procedure has an integer type parameter, in the query analyzer the stored procedure works well

Image 562

Image 563

Image 561

database designer variables debug
На рассмотрении
Carol Vanden Bussche 6 лет назад
anonymous 6 лет назад

Hi Edgar,


Thanks for your post. Based on your screen shot it looks like no value is being passed in for the parameter. Not sure if you are running by pressing the 'Debug' button, F5 or F6. If you either press the 'Debug' button or F5 you will be presented with a dialog that should ask for a value for the [[CantProd]] variable if you input something like 4 you should get a result. Please let us know if you do not.

Edgar Gárate 6 лет назад

Thanks Genie

Yes, I am running by pressing the Debug Button F6, on this screen with value 5.



Grommit 6 лет назад

Hi Edgar

It would be really  helpful to us if you left a review on G2 Crowd of your experience with Warewolf.
Please can you take a minute to review here:
https://www.g2crowd.com/products/warewolf/reviews

Thanks so much!


Сервис поддержки клиентов работает на платформе UserEcho