Home DADE

My SQl, cannot save altered reports

edited June 2007 in DADE
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??????

Comments

  • edited June 2007
    Hi Rob,

    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

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited June 2007
    Dear Nico,

    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?

This discussion has been closed.