Newbie Questions

Re: Need to use a prompt to get data from a sql table data source

Jimmy — Thu, 18 Jun 2009 16:13:59 GMT

Qdabra's QueryDB web service was designed especially for this purpose and I would recommend checking it out if you might be doing this type of work from time to time:

http://www.youtube.com/watch?v=odt7QaPuVDo

If it's just for this one scenario and you are somewhat handy with code, you may also want to check out this post I made a while back:

http://www.infopathdev.com/forums/p/9467/33496.aspx#33496

Need to use a prompt to get data from a sql table data source

kikibrown01 — Thu, 18 Jun 2009 15:40:37 GMT

We need to know how to use a field as a prompt to get the correct row of data returned from a sql table. We have a view built with 10000 unique rows based on position data, we would like the manager to be able to enter a position number and have the data connection pull back the unique row of data attached to that position number. We can't figure out how to get the prompt to work