Parameters in MS Access

I'm getting an error message 'Jet database does not recognize [yID] as an
invalid field name or expression' for the following code. The parameter
value [yID] is invalid for some reason. I'm using MSAccess2000 with D6. What
is the problem?

ADODataSet.Parameters.ParamByName('[yID]').Value:= X_.FieldValues['ID'];
ADODataset.Active:= false;
ADODataset.CommandText:= 'TRANSFORM First(X.TIME) AS FirstOfTIME '+
'SELECT X.ID, X.NO, '+
'WHERE (X.ID) = [yID]'+
'GROUP BY X.ID, X.NO '+
'PIVOT X.NO ';
ADODataset.Open;


.

Relevant Pages

  • Re: Parameters in MS Access
    ... invalid field name or expression' for the following code. ... value [yID] is invalid for some reason. ... Brian Bushay (TeamB) ...
    (borland.public.delphi.database.ado)
  • Strange Error Message when using Domain Functions]
    ... error message is returned when an invalid field is included in a domain ... statement was invlaid or that the field wasn't found. ... When I first opened Access, I did select the security open to restrict ...
    (microsoft.public.access.modulesdaovba)
  • Strange Error Message when using Domain Functions
    ... error message is returned when an invalid field is included in a domain ... statement was invlaid or that the field wasn't found. ... When I first opened Access, I did select the security open to restrict ...
    (microsoft.public.outlook.program_vba)
  • Re: Crystal parameters
    ... But based on the error message ... Invalid field name, I think there might be something wrong with the ... "This posting is provided "AS IS" with no warranties, and confers no ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Dynamic numerical structure filed name
    ... Stéphane Bourgeois wrote: ... > I tried various things but I always get an error message (like ??? ... > Invalid field name: '1'). ... You may consider using array or cell array instead ...
    (comp.soft-sys.matlab)