Query button will not return data from SQL 2000

M

MCAlicea

I have SQL 2000 installed with one table connected my InfoPath forms. The
first form is just for submitting data to the table, that one works fine.
The second form is for queries/updating the table. Whenever I click on the
Run Query button I get an error stating:

"The Specified query did not return any data. You can revise the query, or
you can click New Record to enter a new record."

I have verified that there are recods in the table and have searched for
that data, but can't get anything.
 
S

S.Y.M. Wong-A-Ton

Please verify that you have typed in an exact match into one or more
queryFields. Please note that if you try to search using a wildcard
character, you will get the message you got, since InfoPath only supports
exact searches out-of-the-box.
 
Top