Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Tutorial fails to run with UCASE error

edited July 2016 in End User

RX10.1 Enterprise
RB1702

I'm trying to run the

\Tutorials\Complete\II. Applications\02. End-User Reporting

demo/tutorial.

I removed the "uses: reference to daDBBDE and changed the
iniStorageName to a folder with write permissions allowed.

When I try and design or print any of the entries (e.g. BioLife) I get
a dialog box with:


[FireDAC][Phys][SQLite] ERROR: no such function: UCASE.


Am I missing something in my setup? The wrong SQLITE version in the
path or???

TIA

Cheers,

EdB

Comments

  • edited July 2016
    Hi Ed,

    Thanks for pointing these issues out. In order to avoid the error, you
    can add FireDAC.Stan.ExprFuncs to the uses clause and the demo will run
    correctly.

    I'll update our copy for the next release.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2016

    Hi Nico,

    Thanks!

    This got me further along...

    I can get to design tab now, but I try and preview I get:

    TdaFireDACQueryDataView.SQLChanged: No Database object found,
    euDatabase.


    I can't find where "euDatabase" is specified.

    I tried to add the source to library paths to trace, and now I'm
    getting:
    [dcc32 Fatal Error] ppTypes.pas(1769): F2039 Could not create output
    file 'C:\Program Files
    (x86)\Embarcadero\Studio\18.0\RBuilder\Source\ppTypes.dcu'

    Which is no doubt related to my mucking about with the "cloned" plugin.

    Would you suggest an uninstall/reinstall at this point?

    Cheers,
    EdB




  • edited July 2016
    Hi Ed,

    This is also something that was missed when we converted all these
    tutorials to FireDAC. I will fix this for the next release as well.

    The included reports are really just for show however. You should be
    able to create a new report and access the sample data as you need.

    If you would like to see the sample reports working, follow the steps below.

    1. Open the tutorial in Delphi and select the ppDesigner1 component.
    Set the AllowDataSettingsChange property to True.

    2. Run the tutorial and open one the Accounting/Customer List report in
    the designer.

    3. Switch to the Data tab and select File | Data Settings from the main
    menu. Be sure you see FireDACSession, RBDemos, and SQLite in the
    connection tab. Close the dialog.

    4. The existing QueryDataView still uses "euDatabase" however as a
    connection so you need to delete and recreate it.

    Right click the QueryDataView and select "Delete".

    Select File | New --> Query Designer and add the Customer table with all
    fields.

    5. Preview the report.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2016
    That did it, thanks!

    So the reason I couldn't find a reference to euDatabase** was because
    the template with it is actually stored in the table. Got it.

    **That or the whole EU brexit thing is getting out of hand...

    Cheers,
    EdB

This discussion has been closed.