SQL Database Integration

Re: Switching views with a repeating table

ahardin — Thu, 16 Feb 2006 12:52:50 GMT

Good Job Pete

I thought that might have been it just had the same problem with queryfields of my own to setup a username and login system to feed back into a projects database and produce reporting, luckily i had to only clear three fields first.

Cheers Adam

I'm from WALES
adam.harding@ltsbasset.co.uk

Re: Switching views with a repeating table

pcapsey — Thu, 16 Feb 2006 12:24:07 GMT

Hi Adam,

I think you might have cracked it! I had the table keyed on a number of fields, which are also the query fields used to select records on the Select view. I've changed the table to use the autonumber as the key, and I use that field to move from the Summary to Detail view. When moving back from the Detail to Summary, I set the autonumber to blank. The Summary then displays the subset of records that was originally displayed. The query fields must still hold the original values entered by the user.

One thing to note. When I updated the main data connection in the form, I had to change the SQL statement generated by InfoPath to include the autonumber so that I could use the field in the form.

Thanks for your help,

Pete

Re: Switching views with a repeating table

ahardin — Thu, 16 Feb 2006 11:32:51 GMT

Hi pete

I am over the channel in Wales good to see someone from the UK on here.

the button that goes from summary to detail need only define one field if you have a unique reference number for that record. It can query using that and display it in datafields on the detail view.

Your button on the detail view should clear the reference number queryfield, submit query to database and switch views back to summary view which would still include all records which match back the other criteria.

I hope this helps

Cheers Adam

If you want to talk direct you can get me on adam.harding@ltsbasset.co.uk

Re: Switching views with a repeating table

pcapsey — Thu, 16 Feb 2006 11:25:59 GMT

Hi there,

Many thanks for the replies. However, I couldn't get my form to work following Matt's example, which I worked through, and I couldn't work out what to do from Agni's reply, as I'm not a coder! Maybe I should give more detail about what I'm trying to do.

The first view of my form, Select, has a maximum of 7 hierarchical fields that can be entered by the user and then used to access the database table. For example, "Project" is the highest level field. If the user queries the database table using only "Project", all records for the selected project are returned. The next level is "Subproject". If the user queries the database using "Project" and "Subproject", all records for the subproject within the project are returned.

The records returned from the database are displayed in the second view, Summary, in a repeating table. This shows a snapshot of the records returned from the database, with only certain fields displayed. The user can click a "View" button to show the details of a particular record in the third view, Detail. The button is displayed alongside each record in the table. When the button is clicked, I'm setting the query fields to the values returned for the selected record and requerying the database.

The third view, Detail, shows the full record. I want a button on this view that allows the user to return to the Summary view showing all of the records that were originally returned. But, because I have changed the values of the query fields when moving from the Summary to Detail view, this currently only displays the record from the Detail view on the Summary view.

I've tried using the main database table defined as a secondary data connection in both the Summary and Detail views, but it makes no difference because I still need to set the query fields before moving from the Summary to Detail view.

The main difference between my form and Matt's example is the selection screen. My selection screen allows the user to determine which records to display in the Summary view, whereas Matt's example shows a list of all records in the database table, from which the user selects a record by clicking "View Details".

I think I need to hold the original values of the query fields, as entered by the user on the Select view, and use them to requery the database when moving from the Detail to Summary view. This is where I'm having problems!

Any further help would be appreciated.

Many thanks,

Pete

Re: Switching views with a repeating table

Matt Faus — Thu, 16 Feb 2006 02:07:00 GMT

I think the easiest way to do this would be to use several data connections to the same database, this way you can have "summary" queries and "detail" queries completely seperate. I did something very similiar to what you are describing in this HowTo:

http://infopathdev.com/howto/tutorials/default.aspx?i=0bb37b4de44348408680a53a449f2353

---------------
Matt Faus
InfoPath Dev Texas

Re: Switching views with a repeating table

Agni Jonnalagadda — Wed, 15 Feb 2006 21:11:46 GMT

Hi Pete Capsey,
Welcome to the Forum!
You can write some code in the OnSwitchView method to query the DB.
You can get a reference to the DB dataconnection, and change command if required and call query method of that adapter.
If you want sample code search the forum for "ADOAdapter".

Agni
INFOPATHdev India

Switching views with a repeating table

pcapsey — Wed, 15 Feb 2006 08:49:08 GMT

Hi there,

I'm currently developing an InfoPath form that uses three views. These are:

Select view - the user enters criteria that are used to select records from an Access database.
Summary view - this view shows summary information for all records that meet the criteria entered by the user in the Select view. The information is displayed in a repeating table.
Detail view - the user clicks a button in a row of the repeating table on the Summary view to display the full record using the Detail view. The button sets the database query fields to the values displayed in the row of the repeating table in order to read the record.

My problem is this. I want to be able to go back from the Detail view to the Summary view and show all of the records that were originally displayed in the Summary view. I use a button with a rule to Change Views, but the only record displayed in the Summary view is the one that is displayed in the Detail view.

I think I need to reset the database query fields to the original values entered by the user on the Select view, but cannot find a way to do this. Any help would be greatly appreciated.

Thanks and regards,

Pete Capsey