Retrieving stored data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre Alicea - 07 Oct 2004 19:52 GMT

Hello all,
Pardon the question if it's a simple one, as I'm just getting my feet wet
with this application.... If I create a form that stores data directly into
a database, can I use that form to retrieve the form's data from the
database??

Reply to this Message

Jerry Thomas [MSFT] - 07 Oct 2004 22:30 GMT

YES!

I would suggect starting with a very simple Access database and just spend a
little time seeing how things work. Create a database with 4 or 5 fields.
Make some of them text and some numeric.
Then create a new InfoPath form using "New from Data Connection". You will
end up with a template for querying and submitting data.

Signature

Jerry Thomas[MSFT]
<Jerryth@online.microsoft.com>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

> Hello all,
> Pardon the question if it's a simple one, as I'm just getting my feet wet
> with this application.... If I create a form that stores data directly into
> a database, can I use that form to retrieve the form's data from the
> database??

Reply to this Message

Andre Alicea - 10 Oct 2004 01:37 GMT

Jerry,
Thanks for your response. I've done that with a SQL Server db. I was
successfully able to create a template against a SQL db and then use the
form to enter data to the database. My question comes about when I am
trying to retrieve specific data. For example, one field in my db and on
the form is 'BacklogID'. When I enter the BacklogID and hit search, it
appears that data is retrieved for all of the records in my database. I use
SQL Profiler to look at the query that is being sent to the database, and it
appears that there is no code that generates the where clause of 'where
BacklogID = xxxx'.

> YES!
>
[quoted text clipped - 10 lines]
> > a database, can I use that form to retrieve the form's data from the
> > database??

Reply to this Message

Jerry Thomas [MSFT] - 11 Oct 2004 19:28 GMT

It sounds as if your query field isn't from the QueryFields section of your
data Source.

Signature

> Jerry,
> Thanks for your response. I've done that with a SQL Server db. I was
[quoted text clipped - 29 lines]
> > > a database, can I use that form to retrieve the form's data from the
> > > database??

Reply to this Message

Andre Alicea - 11 Oct 2004 20:19 GMT

Is there a way to use one field for both data entry and data query?
Ideally, I would like to have two buttons on the bottom of the form. One
for submit and one for search. If I click the submit button, then it would
write/update the database. If I click the Search button, then it would
query the database. Is this possible??

> It sounds as if your query field isn't from the QueryFields section of your
> data Source.
[quoted text clipped - 37 lines]
> > > > a database, can I use that form to retrieve the form's data from the
> > > > database??

Reply to this Message

Jerry Thomas [MSFT] - 12 Oct 2004 01:54 GMT

You can have the Query field with a default value = the Data field.

In the Data Source view of the Task Pane, right click BacklogID under
"queryFields" and select Properties.
In the Default Value field, click the function button and select the
BacklogID field under "dataFields".

(Just to make sure it is working you could add the query field to your form
and then take it out later.)

Now your Submit can do what you need and your query will be based on what is
in the BacklogID data field!

Signature

> Is there a way to use one field for both data entry and data query?
> Ideally, I would like to have two buttons on the bottom of the form. One
[quoted text clipped - 55 lines]
> > > > > a database, can I use that form to retrieve the form's data from the
> > > > > database??

Reply to this Message