InfoPath Dev

Hi Kathy, If the SQL statement works in the SQL Server Management Studio, I would suggest modifying the /where parameter to match. In other words, please try: ModifySqlQuery /dsname=Pb_VW_Units /where=WHERE (Forecaster = N'Summary') Let us know if this fails. You are using the command correctly, so it's just a matter (I think) of ...

hi.... i have a question about copying a Repeating table and using in another view of the same form.   I created a repeating table with a date picker control.   it works good and formats correctly to the sharepoint  (mm/dd/year).   I tried to copy that same repeating table control to another view and it 1.) says ...

 OK, my command is this: ModifySqlQuery /dsname=Pb_VW_Units /where=where Forecaster='Summary' This is the message I get when trying to run.  The query cannot be run for the following DataObject: Pb_VW_Units InfoPath cannot run the specified query. [0x80040E14][Microsoft OLE DB Provider for SQL Server] Incorrect syntax near ...

This is my requirement: I am trying to develop a web enabled Infopath 2010 form, which the users will access from Sharepoint 2010. When the form data is filled out and submitted, the form should be submit to Form Library on the Sharepoint and to SQL Server 2008 R2 database as well for reporting purposes. The member can come back to the form, ...

This is my requirement: I am trying to develop a web enabled Infopath 2010 form, which the users will access from Sharepoint 2010. When the form data is filled out and submitted, the form should be submit to Form Library on the Sharepoint and to SQL Server 2008 R2 database as well for reporting purposes. The member can come back to the form, ...

Thanks for the input guys.  Looks like now() is going to work!  Jimmy, I didn't try your formula because now() was the easiest choice.  I will keep this thread bookmarked just in case now() doesn't work at some point. Thanks again! DJ

Might also be worth trying to use now() instead of today, particularly if you are using both a date and time in the form. I had a similar issue recently where this resolved it.  Grant

Try translate(date, '-:T', '') <= translate(today(), '-:T', '')