Re: Parameters in MS Access

Please, could You send me a example or tutorial application using Ms Access
with ADO, with Insert, update, delete etc


TIA
"George Kuascha" <gkhokie@xxxxxxxxxxx> escreveu na mensagem
news:43f3dcb2@xxxxxxxxxxxxxxxxxxxxxxxxx
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: Create a pivot table via VBA code
    ... refresh the pivottable to use that data: ... have static data in a table (after using the CopyFromrecordset method), ... > from that I would like to place in the pivot table I have. ... So far, using ADO ...
    (microsoft.public.excel.programming)
  • RE: Create a pivot table via VBA code
    ... I was looking for a way to avoid pasting the ... records to a spreadsheet by manipulating the recordset directly. ... create a pivot table, I wasn't able to figure out how ... So far, using ADO ...
    (microsoft.public.excel.programming)
  • Re: TRANSFORM statements in ADO (Excel)
    ... Unfortunatly I wanted the sum of the values to divide each other which Pivot ... I think ADO MD might ... > Excel Pivot table, so I'd just stick with Excel. ... > If you add this calculated field to your Pivot Table as a Data Field, ...
    (microsoft.public.dotnet.framework.adonet)
  • Create Pivot from array?
    ... I want to extract data from a databsae to recordset via ADO, and then do calculations, before feeding it to a pivot table - can itbe done or am I just hoping? ...
    (microsoft.public.excel.programming)