You searched for the word(s): 2
-
Ok Thanks Greg for your help.
So I will have to change the Date time stamp manually every time there occurs a schema change :(
-
I should have mentioned that I'm using a SharePoint form library to store my data. does this make a difference?
-
Perhaps your form schema has a character restriction on it? Did you create the schema in InfoPath or outside of it?
-
That's the date/time stamp for the namespace. That would make sense.
You will need to do it manually. There are a minimal amount of places in your form template files that will require the name change. You can use the command prompt program "findstr" to identify which files. For example, from the command ...
-
I'm not a SQL expert, but I believe you need the } after the where clause. So I would have:
...from "dbo"."LaborSummary" as "LaborSummary" where "SA1" = "whatever"} as "LaborSummary" append...
-
You just have to create one. One of my practices, if I have a form that is working with a database, is to create a data dump view. Just create a view and drag everything on to it. I find it invaluable to be able to check the data when troubleshooting. I even have hidden buttons in production forms if I ever need it. Then you just need ...
-
Stay calm Catharine...Breath Deeply....
You have republished your forms?
Are the forms full trust?
You are a local Admin on your new PC?
Are you using Visual Studio or just Scripting?
Often a lot of security is part of Internet Explorer settings and Zones.
Those are a few things I could think of.
-
I do not think you can check the value of the box itself, since there is no value, what you have to do is use the same formula that the expression bow itself is evaluating.
Expression Box (x + y + z)
Conditional Format (x+y+z) <= -1 then font Red.
-
The issue comes down to dynamic queries.
In InfoPath you can not have a dynamic query on secondary data connections except with web services. SharePoint uses web services but it does not provide the ability to pass a parameter. You have to load the whole list and then use filters to only display the correct record.
With a database ...
-
Does anyone know how to use the where clause with the shape clause? I get a error on the following code at the Where clause....
command += "{select ";
command += "[CA1],[HOUR_DOLLAR],[DIST_NONDIST],[MASTER],";
command += ...