Data Adapter Parameter Error

[Captain Gadget]

I cannot update a child table to the main using the wizard criteria column
with out errors occuring.

I'm using ACCESS database 1 main table, 1 child.
The 2 tables are related, no problem.

I go to add the query criteria (ex: @CustId) to the appropiate criteria row
for the associated columns (ex. CustID) and the appropiate statement "WHERE
(CustID = @CustID" is generated fine.

BUTTTT! when I click on Next to continue I get the error: (Generated Select
Statement) occurs.

I cannot update that portion of the database without it.

After a week of trying and viewing all the posts I'm shouting for help.
--
Larry

[Ken Tucker [MVP]]

Hi,

Havent read your earlier posts. Please post some code

Ken
----------------
"Captain Gadget" <ph*******@telus.net> wrote in message
news:D7**********************************@microsof t.com...
I cannot update a child table to the main using the wizard criteria column
with out errors occuring.

I'm using ACCESS database 1 main table, 1 child.
The 2 tables are related, no problem.

I go to add the query criteria (ex: @CustId) to the appropiate criteria row
for the associated columns (ex. CustID) and the appropiate statement "WHERE
(CustID = @CustID" is generated fine.

BUTTTT! when I click on Next to continue I get the error: (Generated Select
Statement) occurs.

I cannot update that portion of the database without it.

After a week of trying and viewing all the posts I'm shouting for help.
--
Larry

[Captain Gadget]

Hi Ken,
Some how I managed to get the wizard criteria query column to work. All of
a sudden it decided to accept the "@CustID".

But when I go to add the code below, at the **** I get this error...

Private Sub LOADorderDETAILS()
Dim intOrderID As Integer
Dim intOrderOrdinalColumn As Integer
Dim intOrderOrdinalRow As Integer
Dim cellOrder As DataGridCell
cellOrder = DGestOrdCustData.CurrentCell 'current order cell
'clear data set
DSboth1.Clear()
'clear data grid
DGestOrdCustData.Refresh()
'determine column - 0 indicates the order ID column
intOrderOrdinalColumn = 0
'determine row
intOrderOrdinalRow = cellOrder.RowNumber.ToString
****THE CODE BELOW GIVES ERROR....NO VALUE AT INDEX 0

'get value of order id column for that row
intOrderID = (DGestOrdCustData(intOrderOrdinalRow,
intOrderOrdinalColumn))
'use the order id value for the parameter
oledbDAcustdata.SelectCommand.Parameters("@CustID" ).Value = intOrderID
OleDbDAproducts.Fill(DSboth1, "estordwindata")
DataGrid1.DataSource = DSboth1.Tables("estordwindata").DefaultView
End Sub
"Ken Tucker [MVP]" wrote:

Hi,

Havent read your earlier posts. Please post some code

Ken
----------------
"Captain Gadget" <ph*******@telus.net> wrote in message
news:D7**********************************@microsof t.com...
I cannot update a child table to the main using the wizard criteria column
with out errors occuring.

I'm using ACCESS database 1 main table, 1 child.
The 2 tables are related, no problem.

I go to add the query criteria (ex: @CustId) to the appropiate criteria row
for the associated columns (ex. CustID) and the appropiate statement "WHERE
(CustID = @CustID" is generated fine.

BUTTTT! when I click on Next to continue I get the error: (Generated Select
Statement) occurs.

I cannot update that portion of the database without it.

After a week of trying and viewing all the posts I'm shouting for help.
--
Larry