Method:API Q&A

Re: APIDelete

Anonymous — Mon, 30 Mar 2009 14:30:57 GMT

Matt,

This was an issue with non-accounting tables. I've update the API so you can try the delete out again.

Let me know if you have any other questions/issues.

Pete

Re: APIDelete

Matt — Fri, 27 Mar 2009 17:47:42 GMT

I'm only trying to delete 1 record per call, just make multiple calls in a row.

I am trying to delete ofut of a table I created called a1test.

I tried it again just now get :

<ERROR><MESSAGE>ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.</MESSAGE><STACKTRACE>   at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method)
   at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command)
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at shrServiceCleanUp.fnExecuteSqlTransaction(String sDatabaseName, String sSQL, SqlConnection& connection, String sWebServiceEncryptionKey, Int32 intSecurityID, SqlCommand sqlConn, SqlTransaction sqlTran, String sComingFrom)</STACKTRACE><DETAIL>sSQL=DELETE FROM [a1test] WHERE RecordID=3</DETAIL><sDatabaseName>Apex</sDatabaseName><sComingFrom></sComingFrom></ERROR>

Re: APIDelete

Anonymous — Fri, 27 Mar 2009 15:51:28 GMT

Matt,

For each APIDelete call there will only be one record deleted at a time. The problem appears to be the table was an accounting table and there were some locking issues when trying to perform some accounting clean up tasks that caused the error.

We've updated the APIDelete. Can you call the APIDelete again and see if the error message happens. If it continues to happen can you tell us what table you are trying to delete the record from?

Thanks,

Peter

APIDelete

Matt — Thu, 26 Mar 2009 18:38:36 GMT

I tried using APIDelete and the response was "ThisSqlTransaction has ; it is no longer usable" it deletes 1 record, but I wanted it to delete multiple records, is that not allowed?