Fórum Pegar Sql gerada pelo Provider antes de atualizar no banco #48757

object ClientDataSet1: TClientDataSet
  ProviderName = ´DataSetProvider1´
  Left = 4
  Top = 4
  object ClientDataSet1CHAVE: TIntegerField
    FieldName = ´CHAVE´
    ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
  end
  object ClientDataSet1NAOCHAVE: TStringField
    FieldName = ´NAOCHAVE´
    ProviderFlags = [pfInUpdate]
    Size = 10
  end
end
object DataSetProvider1: TDataSetProvider
  DataSet = ADODataSet1
  UpdateMode = upWhereKeyOnly
  Left = 36
  Top = 4
end
object ADODataSet1: TADODataSet
  Left = 68
  Top = 4
  object ADODataSet1CHAVE: TIntegerField
    FieldName = ´CHAVE´
    ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
  end
  object ADODataSet1NAOCHAVE: TStringField
    FieldName = ´NAOCHAVE´
    ProviderFlags = [pfInUpdate]
    Size = 10
  end
end