Dbf(advantage) version of report explorer demo

rbuser

Hi
I am trying to create a DBF/CDX version of the report explorer demo for
Advantage.

I have converted the tables from ADT to DBF but have had to change some of
the unsupported field types like autoinc (changed to integer), and
Fieldnames1 & 2 changed to fieldname1 & 2 becauser they are too long and
changed them to 254 from 255 characters.

I now can't launch the explorer because of an invalid variant conversion, I
am guessing that it is trying to autoinc the folder id and failing but I
can't find out where it holds the information or what exactly it does when
you launch the explorer as there are no events.

Thanks
Andy

digitalmetaphors

On your Advantage alias configuration, make sure you configure it for the
DBF/CDX table extensions. Run the Advantage Data Architect and select Tools
| Alias Configuration. Other than that it should just work normally. I have
used our Advantage end user demo using these extensions and it works fine.


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi

I don't think I explained it properly.
I have the aliases set up correctly for DBF/CDX but some of the fields in
the original ADT tables had field types and field names that were either
incompatible or too long so I changed them.
Surely you would have had to make these amendments too, the Fieldnames1 name
is too long and the character 255 fields need to be changed to 254.
Now when I launch the report explorer it just gives an error
'Invalid Variant Conversion' which normally points to a null value
somewhere.
My guess it is is tying to read an autoinc value somewhere, but I can't find
where to change the settings.

Thanks

Andy

rbuser

Hi Andy,


just curious, why switching from ADT down to DBF?

regards,
Chris Ueberall;

rbuser

Chris
I am just trying to use the Report explorer demo but all my tables are in
dbf format, but the rbFolder, rbItem etc. are supplied only in ADT format
and I'm guessing I can;t mix on the same form.

Andy

rbuser

Andy,


I don't think so. The report storage isn't coupled in any way with the rest of your data. You could set up to different databases for every part. But normally one uses the same database.

regards,
Chris Ueberall;

digitalmetaphors

Do you have a blank folder and item database table for the reports or is
there null data in the tables? Check the data pipeline connections and make
sure you can populate a DBGrid on a form with the rbFolder and rbItem
datasources.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Jim
Yes the tables are blank as I had re-create them. I'll populate them and
try again.

Andy