Re: Error on delete command with filter.

shniggens — Mon, 29 Aug 2011 20:00:50 GMT

You were right about all of that. Thanks.

Re: Error on delete command with filter.

Jimmy — Mon, 29 Aug 2011 18:57:16 GMT

Since I'm guessing Employee is a non-numeric value, you need quotation marks around its value:

concat("Delete /xpath=/my:myFields/my:Labor/my:MasterLaborCall/my:MasterLaborRepeating[../my:MasterLaborPerson='", Employee, "']")

That's SINGLE QUOTE DOUBLE QUOTE before the first comma, and DOUBLE QUOTE SINGLE QUOTE after the second comma.

I'm also guessing that you shouldn't have that ../ before my:MasterLaborPerson.

Error on delete command with filter.

shniggens — Mon, 29 Aug 2011 18:04:43 GMT

I'm getting a wierd error when trying to delete a row from a table based on a value from another table.

My command is - concat("Delete /xpath=/my:myFields/my:Labor/my:MasterLaborCall/my:MasterLaborRepeating[../my:MasterLaborPerson=", Employee, "]")

The error I get is -

Action: Delete. Arguments: xpath: /my:myFields/my:Labor/my:MasterLaborCall/my:MasterLaborRepeating[../my:MasterLaborPerson=******] . Details: '/my:myFields/my:Labor/my:MasterLaborCall/my:MasterLaborRepeating[../my:MasterLaborPerson=*********]' has an invalid token.. Stack: at MS.Internal.Xml.XPath.XPathParser.CheckToken(LexKind t) at MS.Internal.Xml.XPath.XPathParser.ParsePredicate(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseStep(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelativeLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseLocationPath(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParsePathExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseUnionExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseUnaryExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseMultiplicativeExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseAdditiveExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseRelationalExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseEqualityExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseAndExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseOrExpr(AstNode qyInput) at MS.Internal.Xml.XPath.XPathParser.ParseXPathExpresion(String xpathExpresion) at MS.Internal.Xml.XPath.QueryBuilder.Build(String query, Boolean allowVar, Boolean allowKey) at MS.Internal.Xml.XPath.QueryBuilder.Build(String query, Boolean& needContext) at System.Xml.XPath.XPathExpression.Compile(String xpath, IXmlNamespaceResolver nsResolver) at System.Xml.XPath.XPathNavigator.Select(String xpath, IXmlNamespaceResolver resolver) at Qdabra.Tools.RulesLibrary.Commands.DeleteNodes(XPathNavigator dom, String xpath) at Qdabra.Tools.RulesLibrary.Commands.Delete() at Qdabra.Tools.RulesLibrary.Commands.ExecuteCommand()

Qdabra qRules

Re: Error on delete command with filter.

Re: Error on delete command with filter.

Error on delete command with filter.