InfoPath Dev

Ernesto, I too am having the problem.  It seems to me that it's a permissions issues on the local drive.    I had our Network Admin log in and try to use the form and he has no problem because his c:/users/"username"/appdata folder is read/write, but I don't have admin rights to my local ...

Yes, it was blank.  Current was view 1.  I did a pause after the bad command, but it showed no info.  I did get it figured out.  But I would love to figure out why the command didn't appear and why the error node was blank. 

I always know if I post a note, than I will figure it out.  I used another query that worked:  concat("ModifySqlQuery /dsname=REVENUE /where=where Forecaster='", QueryChange, "'") not sure why the N'" doesn't work in the revenue query but does in the main, but thanks anyway.  :)

Hi.  I am at it again, and now I am trying to add another query.  The original Query:  concat("ModifySqlQuery /dsname=Main /where=where (Forecaster = N'", QueryChange, "')") works fine.  But the following query brings no resulta and checking the command and success of qrules shows no blank after it ...

Hi, can you tell me if this query can be used for multiple selects, for example dsname=Genstates /where=Where StateID = '" , Field1, "and CityID = '", Field2, "'")

LOL, I am also a bit OCD, which is why I have tried it all ways.  But it looks like what I missed before was the quotes around the '  because when I do it like "'" it now works.   I have several data connections, the main connectioned query worked perfectly, but the secondary one was where I was having ...

ok, thank you. 

I'm still having trouble with this and I believe it's because I need to put quotes around the field name.    If I use ModifySqlQuery /dsname=Main /where=where ("Forecaster" = 'Summary') this retrieves data but ModifySqlQuery /dsname=Main /where=where (Forecaster = 'Summary') does not.   How do ...

Those Pesky Parenthesis!  I am always forgeting them.  Thanks for your help with this.  by the way Qrules ROCKS! 

Actually it wasn't, but I see what you are saying, I did change the name to main unstead of main connection and now get this error message: The query cannot be run for the following DataObject: Main InfoPath cannot run the specified query. [0x80040E14][Microsoft OLE DB Provider for SQL Server] Incorrect syntax near ...