ExecuteCommandTextErrorHandling

[Richard Steele (Basemap)]

Hi
I have added an extra column to my MS Access (2000) table, currently have 10
fields. it is a simple text field. I come to fill a data adapter from a
simple query select column name from table and I get the following

Message = No value given for one or more required parameters.
Source = Microsoft JET Database Engine
Stack = at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior)
at
System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
........

when I take out the column and run a select query it returns all the
necessary data
does any one know what the problem is?

Thanks

[W.G. Ryan eMVP]

What does the command that you're firing look like?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Richard Steele (Basemap)" <Ri******************@discussions.microsoft.com>
wrote in message news:81**********************************@microsof t.com...

Hi
I have added an extra column to my MS Access (2000) table, currently have 10 fields. it is a simple text field. I come to fill a data adapter from a
simple query select column name from table and I get the following

Message = No value given for one or more required parameters.
Source = Microsoft JET Database Engine
Stack = at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior behavior) at
System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandB
ehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
........

when I take out the column and run a select query it returns all the
necessary data
does any one know what the problem is?

Thanks

[Richard Steele (Basemap)]

Thanks for you assistance I worked out the problem, no real fix, just me
having a dumb moment

"W.G. Ryan eMVP" wrote:

What does the command that you're firing look like?

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Richard Steele (Basemap)" <Ri******************@discussions.microsoft.com>
wrote in message news:81**********************************@microsof t.com...

Hi
I have added an extra column to my MS Access (2000) table, currently have

10

fields. it is a simple text field. I come to fill a data adapter from a
simple query select column name from table and I get the following

Message = No value given for one or more required parameters.
Source = Microsoft JET Database Engine
Stack = at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at

System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS

dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&

executeResult)

at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior

behavior)

at

System.Data.OleDb.OleDbCommand.System.Data.IDbComm and.ExecuteReader(CommandB
ehavior behavior)

at System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
........

when I take out the column and run a select query it returns all the
necessary data
does any one know what the problem is?

Thanks