Can't make SQL statement work in SQL expression field of RDC, ok in vb

[TNN]

I am using crystal reports 9.0 via the RDC in vb6.0.
A SQL statement that will work in vb6.0 with a ADODC data control will not be accepted as a SQL expression field in the RDC for Crystal. The database properties and oleDB provider are the same for both yet the SQL statement works in VB but not in the SQL expression field in the RDC. Can anyone guess why???

TNN, Tom


TOM

http://WWW.TNPAYROLL@AOL.COM

 

[LazyMe]

You might wanna post the statement in question as well...

Greetings,
Rick

 

[TNN]

LazyMe,
I had the answer explained to me in the Crystal Forum.
The SQL medium I was using in the RDC for Crystal Reports was not meant to return a recordset but only a single field that is then placed on the report. In Crystal I am to use the Command object to return multiple recor recordset.

Thank You for your attention, TNN, Tom

TNN, Tom


TOM

http://WWW.TNPAYROLL@AOL.COM