Subform not showing data

Creating and using forms
Post Reply
slgarrett
Posts: 2
Joined: Mon Nov 28, 2016 9:16 pm

Subform not showing data

Post 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.
Open Office 4.1.3, Windows 10
MSSql Express 2014
Shirley L. Garrett
User avatar
Villeroy
Volunteer
Posts: 31344
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Subform not showing data

Post by Villeroy »

Parallel to this topic right now: viewtopic.php?f=39&t=86234
I hope this helps.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
slgarrett
Posts: 2
Joined: Mon Nov 28, 2016 9:16 pm

Re: Subform not showing data

Post 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.
Open Office 4.1.3, Windows 10
MSSql Express 2014
Shirley L. Garrett
Post Reply