Page 1 of 1

Error prompting parameter ParameterNameSubstitution

PostPosted: Tue Mar 12, 2019 9:30 pm
by dig314
LibreOffice Base
Version: 6.0.6.2 (x64)
Windows 10

OpenOffice 4.1.2
Windows 7


I get an error in Base ( both LibreOffice and OpenOffice ) when I try to prompt for a parameter. The same query works if I supply the parameter directly in the statement.

The database is an ODBC connection to SQL Server. A similar MSAccess query using the same ODBC connection works when prompting for the parameter.

SQL Status: 07009
The data content could not be loaded.
Invalid descriptor index.
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.

Dig

Re: error prompting parameter ParameterNameSubstitution

PostPosted: Tue Mar 12, 2019 11:40 pm
by UnklDonald418