Error: (42000) [Microsoft][ODBC SQL Server Driver][SQL Server]The name "errortype" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted

• bumash

  SSC Enthusiast

  Points: 105

  More actions

  September 4, 2010 at 12:02 pm

  #95072

  Hi,

  I'm using Micro Focus SilkTest testing tool and have to insert rows using variables (program defined).

  below is the syntax I'm using:

  DB_ExecuteSql (hdbc, "INSERT INTO SCC_Errors_Statistics (Error_Type , Error_Detailes, Robot_Name , Monitor_Name , Monitor_Start_Time , Error_Time , Error_On_Page ) VALUES (errortype, error_messages_list, robot_name, monitor_name, StartMonitorTime_SQLformat, ErrorTime_SQLformat, StepName)")

  All VALUES are variables.

  And I got the following error message:

  Error: (42000) [Microsoft][ODBC SQL Server Driver][SQL Server]The name "errortype" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted

  Can you please advice what is correct syntax of insert statement (into Sql-Server) using program variables?

  Thanks in a advanced.

  Regards,

  Moshe.