Developer forum

Forum » Templates » Search & replace module

Search & replace module

E-mail notifications
Giuseppina Giunta
Reply
Posted on 10/06/2013 11:46:57

Hi everyone, this is my first post :-)

I should find and replace some words in the ProductName field.

I have used the 'Search & replace" module but I have this error message:

 

0 record(s) updated.
An error occured.

System.InvalidOperationException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
   at System.Data.Common.DbDataAdapter.UpdatingRowStatusErrors(RowUpdatingEventArgs rowUpdatedEvent, DataRow dataRow)
   at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet, String srcTable)
   at System.Data.Common.DbDataAdapter.Update(DataSet dataSet)
   at Dynamicweb.DatabaseReplacer.RunReplace()

 

What can I do?

Thank you very much.

Ciao

Giuseppina


Replies

 
Nicolai Høeg Pedersen
Posted on 10/06/2013 13:01:45
Reply

Hi Giuseppina

 

That is because the product table has a composite key of 3 columns and the search and replace module only supports tables with single keys.

 

So you have to write your own SQL Statement and use the SQL Firehose instead.

 

BR Nicolai

 
Nicolai Høeg Pedersen
Posted on 10/06/2013 13:02:08
Reply

And welcome to the forums! Glad to have you here.

 

BR Nicolai

 

You must be logged in to post in the forum