T
Tom van Stiphout
Forms in ADP can have a stored procedure as the RecordSource. That sproc can
take input parameters, which are specified in the InputParameters property.
Example: RecordSource="dbo.EmployeesByID" (or use the RecordSourceQualifier
to specify "dbo"), InputParameters="@ID=1"
On A2007 Runtime this no longer works: Bad query parameter '@ID'.
On A2007 (with or without the /runtime command line switch) it does work.
The only workaround I have found so far is to put the entire expression in
the RecordSource property like this: "exec dbo.EmployeesByID @ID=1", and
leave InputParameters empty. I don't think this is an intentional change by
Microsoft.
I have put a backup of the NorthwindCS database and the ADP here:
http://www.kittest.com/NorthwindCS_A2007RT.zip These files are identical to
the ones that shipped with A2000, with the addition of the EmployeesByID and
EmployeesList sprocs, and a few test buttons on the Main Switchboard. Just
like with the original NorthwindCS, you may have to fix up the database
connection before it opens properly.
I know there is a bug in the A2007 runtime. Clint Covington wrote on Jul-20:
"There is a known bug where reports don't work in ADPs. We are working on a
QFE for the issue." That was 2 months ago, and I think the QFE hasn't been
released yet. I'm also not at all sure it will fix this issue, if indeed it
is a bug.
My questions:
* Can you confirm the behavior I am describing?
* Is this a bug?
* Any better workarounds than the one I described above?
-Tom.
take input parameters, which are specified in the InputParameters property.
Example: RecordSource="dbo.EmployeesByID" (or use the RecordSourceQualifier
to specify "dbo"), InputParameters="@ID=1"
On A2007 Runtime this no longer works: Bad query parameter '@ID'.
On A2007 (with or without the /runtime command line switch) it does work.
The only workaround I have found so far is to put the entire expression in
the RecordSource property like this: "exec dbo.EmployeesByID @ID=1", and
leave InputParameters empty. I don't think this is an intentional change by
Microsoft.
I have put a backup of the NorthwindCS database and the ADP here:
http://www.kittest.com/NorthwindCS_A2007RT.zip These files are identical to
the ones that shipped with A2000, with the addition of the EmployeesByID and
EmployeesList sprocs, and a few test buttons on the Main Switchboard. Just
like with the original NorthwindCS, you may have to fix up the database
connection before it opens properly.
I know there is a bug in the A2007 runtime. Clint Covington wrote on Jul-20:
"There is a known bug where reports don't work in ADPs. We are working on a
QFE for the issue." That was 2 months ago, and I think the QFE hasn't been
released yet. I'm also not at all sure it will fix this issue, if indeed it
is a bug.
My questions:
* Can you confirm the behavior I am describing?
* Is this a bug?
* Any better workarounds than the one I described above?
-Tom.