Embarcadero Delphi Xe Architect Mini 15.0.3890.34076-core Access

DataSetProvider := TDataSetProvider.Create(nil); ClientData := TClientDataSet.Create(nil); try DataSetProvider.DataSet := Query; ClientData.SetProvider(DataSetProvider); ClientData.Open;

Query := TSQLQuery.Create(nil); try Query.SQLConnection := SQLConn; Query.SQL.Text := 'SELECT * FROM Customers WHERE Country = :Country'; Query.Params.ParamByName('Country').AsString := 'USA'; Query.Open;

// Demonstrates dbExpress connection (Architect edition feature) uses DBXDataSnap, DBXCommon, SqlExpr, DB, DBClient, Datasnap.DBClient, SimpleDS;