-
Do you have a default value set on the field 'my:LineStatus'? Or a rule hanging about somewhere that might be doing that? Becuase in the code, you are creating a new group called NewRow and setting the value only on that field in that group.....
By the way, the XPath you were using at first was taking the first Budget Line group and ...
-
Hi, Jeff:
If you follow Jimmy's suggestion, the node you will want to set the values on will be the last node in your repeating group. So you could create an XPathNavigator variable to the last node, like this:
XPathNavigator group = ...
-
Browser compatible forms can only use managed code and the IP 2007 Object Model, I believe, so JScript is out. Here is an article on deploying browser forms with managed code.....
-
Weird -- I tried a little demo and 'and' worked when 'or' didn't. I suppose you also tried creating two separate conditions? What happens then?
-
Crazy as this is going to sound, I believe with negative conditions you have to use 'and'. Switch that 'or' to 'and' and give it a try....
-
Hi --
If you want to use JavaScript, you'll probably have to change the form's programming language first. Under Tools/Form Options select Programming in the left hand pane. You can change the form template code to JScript, VBScript, C#, etc.
To open the Script Editor (or VSTA if you choose to use C# or VB), look under ...
-
Tell you what -- keep using the forum, and we'll call it even... :) Glad it all works. Keep in mind, as you use different forms with different data connections, the methodology you use to split and re-form the string that contains your SQL command will change. Currently, we can split on the first brace, because you are looking at the buyers ...
-
No, it isn't sql... we are still using C#. I just didn't give you quite enough code, I think. What you need to do is replace this:
string origCommand = newQuery.Command.ToString();
//set the query to use the custom command
newQuery.Command = origCommand + customQuery;
With this:
string origCommand = ...
-
You should be able to hover over a variable with your cursor and see the values.... I think in VSTA you can also view them in the watch window....Well, the code we are using for this adds the 'where' clause to the end of the query. So the 'where' is being added to the end, after the work orders table....I think in order to get this ...
-
I'd be interested to see the text of the original command. One way to get that is to put a breakpoint on the line below string origCommand = newQuery.Command.ToString(); and then run the code in debug. Another way would be to walk through the data connection wizard again, and select the Edit SQL button to copy the original SQL.....