/// Сервис редактирования записи
Method EditCar(oldname As %String, newname As %String) [ WebMethod ]
{
	
	s item = ##class(MyApp.CarsDB).%New()
 	s query = ##class(%ResultSet).%New("%DynamicQuery:SQL")
 	do query.Prepare("SELECT ID, NAME FROM MyApp.CarsDB where Name='"+oldname+"'")
 	do query.Execute()
 	while (query.Next()) {
 		s id = query.Data("ID")
 		s item = ##class(MyApp.CarsDB).%OpenId(id)
 		s item.Name = newname
 		d item.%Save()
 	}
}

[SRC PLSQL]Method DelCar(name As %String) [ WebMethod ]
{
	
	s query = ##class(%ResultSet).%New("%DynamicQuery:SQL")
 	do query.Prepare("SELECT ID, Name FROM MyAppCars WHERE Name='"+name+"'")
 	do query.Execute()
 	while (query.Next()){
		s id = query.Data("ID")
 		s item = ##class(MyApp.CarsDB).%OpenId(id)
 		do ##class(MyApp.CarsDB).%Delete(item.%Oid())
 		kill item	 
	}
}

Method EditCar(oldname As %String, newname As %String) [ WebMethod ]
{
 &sql(update MyApp.CarsDB set name=:newname where Name=:oldname);
}