If you get a parameter error when you weren't expecting to feed any parameters
in, it usually means something in the query is not spelled correctly or is being interpreted differently than you intended. From the syntax, it looks like
you are looking for records where the nm_manuf field is identical to the holdsel field. Is this correct? If holdsel is not a field name, I think that is the source of your error.

Stan B


>Select Statement in adodc for dbgrid problem
>--------------------------------------------------------------------------------
>Hello,
>I'm having a terrible problem trying to create a recordset as my Select statement continues to give me this error message:
>"No Value given for one or more required parameters"
>The parameter causing the error is the second field (Holdsel). The value shows correctly in the immediate window. If I change the field to a literal, i.e., 'ABCDEF' it works fine. It just doesn't recognize the value of the variable Holdsel. Holdsel is defined as a string variable.
>Is there something in the ADODC properties that aren't being set correctly? The actual statement looks like this:
>
>selsql = "select * from tblamplifier" & " where [nm_manuf] = [holdsel] "
>selsql = selsql & ""
>dAtaamp1.RecordSource = selsql
>dAtaamp1.Refresh
>dbgrid1.Refresh
>
>Any assistance you can give me would be greatly appreciated.
>Thanks in advance!
>
>BarryP