By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 2,011 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

Data Adapter Parameter Error

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 21 '05 #2

P: n/a
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

Nov 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.