running sql from CR

[cancer2006]

I am using CRW8.5 and Access97.
Is there a way to run sql statements from CRW8.5?

I have to run about 10 or more sql statements and output the results in table. Then write my report off that table.
Thank you.

 

[synapsevampire]

Depends upon the SQL Statements.

If you're using Access,why not build queries there with one final query as the datasource for the report?

A lesser known trick with CR 8.5 is that you can use an RDO/ADO connection, within there you can paste in SQL for the source of a report, but it doesn't allow parameters.

-k