Skip to content

Support for ExecuteNonQuery please #23

Description

@NickSandelRWH

Hello, when I try and execute an xmla command in my case to run a backup of a model I get the error:

The result set returned by the server is not a rowset.

The command worked fine but as it uses ExecuteReader as the only option for execute it expects a rowset returned. Is there support for ExecuteNonQuery (https://learn.microsoft.com/en-us/dotnet/api/microsoft.analysisservices.adomdclient.adomdcommand.executenonquery?view=analysisservices-dotnet#microsoft-analysisservices-adomdclient-adomdcommand-executenonquery) somewhere I haven't found yet or can it be added?

I did a brief hack of adding a method to see if it can work and this seems to work:

def executenonquery(self, query:str) -> Cursor:
    """
    Executes a non query against the data source, output is number of rows affected

    :params [query]: The query to be executed
    """
    self._cmd = AdomdCommand(query, self._conn)
    self._row_count = self._cmd.ExecuteNonQuery()      

    return self

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions