Tutorial fails to run with UCASE error

rbuser

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

nicocizik

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.

rbuser

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

nicocizik

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.

rbuser

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