Subform not showing data
Posted: Mon Nov 28, 2016 9:42 pm
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.