InfoPath Dev

still no luck after clearing the datatype errors. no more errors, but still no data. the command is reporting success in the execution history and examining packets sent to the server shows that the SQL statement is being sent, however the server is not receiving the data.

on re-checking, the old form has the same error. Apologies, this form is giving me brain damage I think. I did however get a new error about datatypes when trying to run: The query cannot be run for the following DataObject: approvers InfoPath cannot run the specified query. [0x80040E07][Microsoft OLE DB Provider for SQL Server] Error ...

the modifysqlquery command was succeding before. now It returns the following error: ModifySqlQuery error: InfoPath has encountered an error. The operation failed.  The form's code contains an error. The following call in the form's code failed: ADOAdapter.Query Operation aborted

There are quite a few data connections and they are all working as expected. Thank you for all your help!

Ah I see now. I entered the command in the proper way I think, however there is nothing populated in the error or results field and the success marker is checked. same is true in execution history. Any advice?

I keep getting an error: "GetXml/dsname" does not point to a valid location path of a field or group. is there something wrong with my syntax? GetXml /dsname = approvers

we tried recreating the connection from scratch in a new form with the same results.

I'm having problems with a form handed down to me. we recently went through some changes with the stored procedure and it now requires an additional parameter. we've been using the modifysqlquery command in qrules to achieve this, however after altering the procedure and adding the additional parameter, the query returns nothing. no ...