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.
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.