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

ODBC Express End User preview error

edited June 2003 in End User
RB 7.02 D6 Dade with OE Sybase5 db

Calculated fields with sub selects give me an odbc error when I
preview from the data tab of: Syntax error: near ')' in
...=rb_item.floderid[)] select_rb_folder_ ...

NOTE the report runs fine! and the magic sql is fine in a standard
TOEQuery. A simple example off of the rb dictionary tables yields
this sql:

SELECT rb_item.itemname,rb_item.ID
,rb_item.folderid
,(select rb_folder.foldername from rb_folder where rb_folder.id
= rb_item.folderid) select_rb_folder_foldern
FROM rb_item rb_item

Thanks,

Rick Matthews
Dartek Systems Inc.

Comments

  • edited June 2003
    When you create the dataview, and exit the query designer, the SQL should be
    valid. If you don't preview the dataview, but directly go to the SQL tab of
    the query designer, and copy this SQL into the TOEQuery, that works but a
    preview does not? In your ODBCXpress DADE plugin, there should be a TOEQuery
    that gets created. This should all behave the same. Is there some setting on
    the TOEQuery that woudl change the SQL type to be compliant with what your
    database expects the SQL to be standardized to?

    Cheers,

    Jim Bennett
    Digital Metaphors


  • edited June 2003
    Thanks Jim,

    Create dataview, exit, use dataview in report, view report - fine. Go
    back to dataview and preview - get error. Paste magic (or regular)
    SQL into a TOEQuery and all is fine.

    Yes I thought it should behave the same both sides - doesn't the
    dataview preview ultimately use the dade plugin TOEQuery?

    I don't have a sample OE end user application but the magic sql is
    very straightforward.

    Can you preview a OE dataview with a subselect custom column? If so
    can you post a link to your dade plugin (and sample OE end user
    project)?

    Thanks,

  • edited July 2003
    Jim I am still at a loss on this one. I am guessing I have an error
    in my daODBCExpress.

    Can you email me your daODBCExpress and your end user sample project
    whose dataview preview works with a calculated field with a subselect?
    I seem to remember that you have a test project but I can't find the
    reference to it.

    (eg. a calc field like "select rb_folder.foldername from rb_folder
    where rb_folder.id = rb_item.folderid" )

    Can you include the version number of ODBCExpress you are using also?

    Thanks,


This discussion has been closed.