old .rtm reports (RB10) doesn't work in RB11
Hi!
I'm using Delphi7 Pro and RBuilder 11 Pro.
I have a problem when trying to load old .RTM files (from RB 10) into the
same app compiled with RB 11.
After a few tests, I have noticed that the error occurs if the SQL order
clause contains a field not included in the SQL fields list.
In the report design form, in the query designer, the fields list tab
contains the following fields:
customer.CODE
customer.NAME
paymethod.NAME
In the Order tab, there is the following condition:
payment.CODE (not included in fields list)
If I delete the order field from the designer, OR add the paymethod.CODE
field to the fields tab, it works fine!!
The question is... Why does the report work correctly in version RB10 but
not in Rb11?
Thanks!
I'm using Delphi7 Pro and RBuilder 11 Pro.
I have a problem when trying to load old .RTM files (from RB 10) into the
same app compiled with RB 11.
After a few tests, I have noticed that the error occurs if the SQL order
clause contains a field not included in the SQL fields list.
In the report design form, in the query designer, the fields list tab
contains the following fields:
customer.CODE
customer.NAME
paymethod.NAME
In the Order tab, there is the following condition:
payment.CODE (not included in fields list)
If I delete the order field from the designer, OR add the paymethod.CODE
field to the fields tab, it works fine!!
The question is... Why does the report work correctly in version RB10 but
not in Rb11?
Thanks!
This discussion has been closed.
Comments
There is now a patch available for RB 11.01 that fixes this issue.
Please send an email to support@digital-metaphors.com and request the patch.
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com