Error in updating data in excel using Silk
I am trying to update the data in excel using Silk test with following command. after executing the update command it fails and returning error
hstmnt = DB_ExecuteSql (hdbc, "UPDATE [USNews$] SET [USNews$].Status = 'test' WHERE [USNews$].UserID = 'sUserID'")
In the above UserID is column name with text type and sUserID is String variable.
*** Error: (07002) [Microsoft][ODBC Excel Driver] Too few parameters. Expected 1.
Occurred in DB_FetchNext
Any help will be appreciated
Re: Error in updating data in excel using Silk
Silktest assumes Excel as a Database and it expects the data should be given to all columns and all column data type should be string/text.
If your excel is not symmetric (data availability for each column), silk will throw error..