The data source control failed to execute the insert command … a simpler explanation

It’s easy to see an error message like the one in the title and go running for the hills “FAILED TO EXECUTE” Aghhgh !!! All is ashes …

Or go through and check the things you changed one at a time.

I discovered that the data binding expression I only half understood and had modified to insert new fields (below).

FieldName=”Budgeted Units” __designer:bind=”{ddwrt:DataBind(‘i’,concat(‘ff52′,$Pos),’Value’,’ValueChanged’,’ID’,ddwrt:EscapeDelims(string(@ID)),’@Budgeted_x0020_Units‘)}”/>

Was drawing its references, not surprisingly from the ‘<DataFields> … <DataFields/> tag set.

Where you see ‘@Budgeted_x0020_Units‘ I had instead ‘@Budgeted Units’ I should have suspected that it wasn’t gonna be space friendly.

So take outs

  1. Stay paranoid and avoid spaces in your field names.
  2. Try a few simple investigations before freakin’ out and running for the Internet.
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: