Page 1 of 1

Subform not showing data

Posted: Mon Nov 28, 2016 9:42 pm
by slgarrett
We are trying to migrate our membership data to SQL Server Express 2014, but still use the data input forms from OO version 4.1.3. We've got the Member information, along with the Membership History information tables migrated and connected by a MemberID number. We can see the relationship connection in both programs. We copied the data input form from Open Office, and changed the Content Table in Form Properties to the MS SQL Table, changed the Master and slave fields to match the correct tables, but it doesn't work. The error message we are getting is "You tried to set a parameter at position '1' but there is/are only '0' parameter(s) allowed. One reason may be that the property "ParameterNameSubstitution" is not set to TRUE in the data source." When we searched for this error message, we found information that said to update Open Office to a later version, but we already have the latest. We can't find the property "ParameterNameSubstitution" anywhere in the MS SQL database.

Re: Subform not showing data

Posted: Tue Nov 29, 2016 5:43 pm
by Villeroy
Parallel to this topic right now: viewtopic.php?f=39&t=86234
I hope this helps.

Re: Subform not showing data

Posted: Fri Dec 02, 2016 5:51 pm
by slgarrett
This reference did not help me. It doesn't seem to be quite my situation. The form I'm using is an Open Office form that works well with an Open Office database. The only change we made was to copy the tables from Open Office to MS SQL Server Express, and to change the name of the tables in the form. We expected it to work the same way, but it didn't.