WinCC Flexible 2008 SQL Database Stored Procedure

Hi there everybody

I have a project in WinCC Flexible 2008 SP3. I am trying to add values to a SQL stored procedure. The stored procedure does work if I use hard coded values instead of parameters (I am attaching a screenshot)

I am calling the stored procedure from a VB script and it runs whenever a value is changed/updated. You will notice I omitted the other 3 parameters for the simple reason that it keeps crashing on the first parameter, so if I can solve that issue I can insert the others. I am getting an error on the second error loop (please see screenshots of the script and the error)

Does anyone have any ideas, i have tried a few approaches as far as the script is concerned and am at my wits end. Any input would be greatly appreciated

Thanks for taking the time to read this

Are there values in the @chocolevel? I would check this parameter with ISNULL to determine what to do before writing to the database.

Just a thought,
Garry
http://www.accautomation.ca