ODBC Express End User preview error

rbuser

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.

digitalmetaphors

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

rbuser

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,

rbuser

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,