This question is locked. New answers and comments are not allowed.
I am using Visual Studio 2008 with the latest release version of OpenAccess. The ASP.NET OpenAccessDataSource control is not persisting certain changes I make to a WhereParameter after running the wizard. To repeat, do the following:
1. Run the OpenAccessDataSource "Configure Data Source" wizard. At the filter screen, add a filter (mine is Integer-based). Set its default value to "0" and its source to "None." Click "Finish."
2. Make sure the OpenAccessDataSource is selected. In the "Object Inspector," click the ellipse button that appears when the "Where" property is highlighted. Change the source of the parameter created in step one to "Session." Give it a session key value. In my case, the session key is "company_id." Click "OK" to save the change.
3. In the designer, close the Page and reopen it. Once again, click the ellipse button that appears when the "Where" property of the OpenAccessDataSource is selected. Notice that the changes from step 2 were not persisted.
1. Run the OpenAccessDataSource "Configure Data Source" wizard. At the filter screen, add a filter (mine is Integer-based). Set its default value to "0" and its source to "None." Click "Finish."
2. Make sure the OpenAccessDataSource is selected. In the "Object Inspector," click the ellipse button that appears when the "Where" property is highlighted. Change the source of the parameter created in step one to "Session." Give it a session key value. In my case, the session key is "company_id." Click "OK" to save the change.
3. In the designer, close the Page and reopen it. Once again, click the ellipse button that appears when the "Where" property of the OpenAccessDataSource is selected. Notice that the changes from step 2 were not persisted.