My SQl, cannot save altered reports
I have a MySQL database, connecting throug ADO.
When I make a report I can save it. But when I try to alter it I cannot save
it most of the times, I then get an error
saying cannot find the row to be altered. For other tables I have added to
the adodataset: Myadodataset.Properties['Update Criteria'].Value :=
adCriteriaKey; but that did not do the trick here.
Anyone any suggestions??????
When I make a report I can save it. But when I try to alter it I cannot save
it most of the times, I then get an error
saying cannot find the row to be altered. For other tables I have added to
the adodataset: Myadodataset.Properties['Update Criteria'].Value :=
adCriteriaKey; but that did not do the trick here.
Anyone any suggestions??????
This discussion has been closed.
Comments
Which version of ReportBuilder/Delphi are you using? Are you using the
end-user solution including the ReportExplorer and Designer to alter and
save reports similar to the demos located in the \RBuilder\Demos\EndUser
Databases\... directory?
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
I am using the enduser solution simular to the demos,
We used queries for te rbitem en rbitemtemplate tables.
This worked with acces and mssql.
However it did not work with MySQL.
I now replaced them with adotables and in the after open from the table I
added
Myadodataset.Properties['Update Criteria'].Value :=
and now it works So if you use MySQL You can not use adoqueries but you must
use adotables or datasets.
Thanks anyway.
Regards,
Rob Nowee
PS I have the 10.6 version installed and now I do not have the
reportexplorer to alter anymore like stated in the designer manual. Can I
get them anywhere?