Error When using custom SQL

rbuser

First, what I'm using:

Delphi 2005
Absolute Database 5.12
Report Builder Trial
Absolute Dade (User provided from Absolute's Website)

Now what I've done:
1. Create form and placed an Absolute database and RP Report control on it
2. Connect to my database
3. Click on report designer of report control
4. Set my data settings to use the Absolute session
5. Use the query designer to select data from two tables
6. Design the layout of the report.

Everything to this point works okay...well except I only get 5 pages, but
I'm presuming that is a function of the trial.

Now, if I go back to the data tab, click on the SQL and then choose Edit
SQL, I get the message that if I do this, I can't use the visual tools
anymore. This is fine, so I click yes.

I'm able to adjust my query and then see the results available in the
report design.

But, as soon as I try to run the project, I get a message that there is an
error reading the dfm of my form.

Just to see if maybe it was something in my query, I closed the project
without saving, reopened it and did the same thing as before, only I
didn't change anything in the query.

Same issue. At this point, since I didn't write the DADE, I'm not sure if
that's where the issue is or if it's something in the Report Builder.

Thoughts?



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi,

Thanks for trying ReportBuilder. For future reference, we prefer that you
use your real name when posting to these newsgroups.

This is not a known issue however we were not aware of a DADE plugin for
Absolute Database. Are you able to successfully alter the SQL using one of
the built in demos included with ReportBuilder? I will download the
Absolute plugin and test it here. On the Absolute DB 3rd Party Addons page,
there are two DADE plugins available.
(http://www.componentace.com/AbsoluteDB_Addons.htm). Which one are you
currently using?

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

Please see below for comments:


Thanks for making it available and without the time limit so that I can
make sure it's what I want to do!!


Okay. No problem. I didn't see that when I signed up...doesn't mean it
wasn't there though.


I didn't try any of the demos. Well, I've looked at code for some of them,
but didn't go though the compiling of any of them or actually running
them. I can try that tonight.


I'm using the first one by Marc Richter. What I did to compile it was
remove the old references and then replace the new ones. Other then that,
I didn't touch anything else.

Thanks,
Chad



--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Chad,

I downloaded Absolute Database and the plugin you are using and installed
both of them for Delphi 2005. After some small modifications I was able to
get the demo app included with the plugin working successfully. I also
noticed that the demo was a bit outdated and did not utilize our new
end-user architecture. I went ahead and updated that and sent it to
ComponentAce. Below is a link to download the update demo. You sould be
able to simply open the EndUser.dpr project and run the app if you have the
Absolute DB and plugin installed into the IDE. Let me know how it works and
if you can recreate the issue you were originally haveing with the demo app.

http://www.digital-metaphors.com/tips/daAbsoluteDB.zip

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

Awesome! I removed the old package, installed yours and ran the demo.
Everything worked out fine.

I then tried to use my program and again got the error.

So I went back into the demo, and right clicked on the report component
and chose the report designer. From the data tab, I created a new query
wizard and just chose the customer table. I dragged the customer number
field on the design tab to the detail band. Everything was still okay at
this point. Then, I went back to the data tab, showed the SQL, and chose
to edit it. I didn't change anything, but his okay and noted the buttons
greying out as expected.

As soon as I tried to run the application, I got the same error as on my
program.

Thanks,
Chad




--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Chad,

I tried the exact steps you describe below however I'm still unable to
recreate the issue. Here are the steps I'm taking, perhaps you can tell me
what I should be doing differently.

1. Open the end-user demo from the example.
2. Run the app from Delphi 2005.
3. Create a new report by right clicking over the list view and selecting
"New Report".
4. Once the designer opens, go to the Data tab and create a DataView using
the Query Wizard (Customer table only).
5. Click the design tab and drag the CustNo field from the DataTree to the
detail band.
6. Click the data tab and select to edit the SQL of the dataview (all
buttons are greyed out).
7. Return to the design tab, save the report and check the preview... all
is still good.
8. Quit the designer and try to load the saved report (still good).
9. Quit the entire application and reload, the report still loads and
previews correctly.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

rbuser

Hi Nico,

Probably the only thing I did different was I didn't create a new
report. From the form designer within Delphi, I right-clicked on the
report component and chose report designer.

I also wasn't hitting save afterwards, though I did check the preview
tab and all was okay so I didn't think there were any issues.

Thanks,
Chad




--- posted by geoForum on http://delphi.newswhat.com

nicocizik

Hi Chad,

Thanks for the clarification, I did not realize you were working at Delphi
design time. It seems you have uncovered an issue that has been in place
for quite some time (i.e Pre-RB 10). We are currently working to resolve
the issue and will keep you updated as we make progress. Note that this
only occurs at Delphi design time. All runtime and template saving
operations are working correctly.

Thanks for you help.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

nardmoseley

A few things found during testing:

- no error occurs when reports are saved and loaded to .rtm files.

- no error occurs during run-time. Reports can be created, saved, loaded,
etc.

The only error we have is with the Delphi IDE - makes it extremely difficult
to track down - we are researching it.


--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com

rbuser

Hi Nico,

Not that I'm glad you have a bug in your software, but I'm sure glad we
were able to nail down that I wasn't crazy.

Chad




--- posted by geoForum on http://delphi.newswhat.com

rbuser

Nard,

Thanks for the update. I'll continue to monitor this thread for further
updates.

Chad




--- posted by geoForum on http://delphi.newswhat.com