-
I'm confused as to what you are trying to do and what your desired result is - can you tell me what you want the outcome to look like (your formula has "/" in it, and there are none in your output, so I'm sort of baffled) and attach a sample form under the options tab?
Thanks!
-
Hi - I'd love to see if I can repro this (the load time issue) on our Office 365 site. Can you either attach your test form under Options or email it to Support AT Qdabra DOT com and reference this thread?
Thanks!
-
Good to know that worked - the genius label needs to go to Jimmy Rishe, tho, as he was the one who showed me that. :) All I did was manage to remember it....
Glad everything is working the way you need it to!
-
Try setting implicit_transactions to off in your stored procedure - I don't recall all the details on why, but I think this will get your sp to not roll back.
-
And I'm sure you've done this already... but if in SSMS, you execute this command:
EXEC User_Request_SP_Test1 '3342671'
You get data rows back? When you created the data connection, did you use a table that returns the same columns as your stored proc?
-
Can you run SQL Profiler and see if the stored proc is being executed?
-
In your first method, if you remove the RunQuery(query) line, what happens? Off-hand, I'd assume conn.Execute is going to run the query. Your second method is using an older version of the InfoPath Object Model.
-
substring(now(), 12, 5)
-
Conditional formatting can use values of fields. Fields are bound to controls. Some controls are drop downs. Yes, you can hide something based on the value of a field that is bound to a drop down. However, as I have been trying to say throughout this exchange - in order for your formatting to work, you need to know what the possible values of the ...
-
This is a perfectly normal way to do this. You just have to know the value of CurrentApprover and whether it will match the AccountID for the supervisor. I asked about that, but don't think you've replied? Have you verified the values should be the same? Put both fields on the form and check.