SQLQueryString does not work

[adigrescenko]

When I use :
Report.SQLQueryString = "Select * from MyTable"
it is not working
If I stop the program on tis line, end I run it step by step, after executing this line, SQLQueryString = "". Nothing happend. Why?
What should I do?

 

[HowardHammerman]

There is some problem in the way you are connecting to your database. Can you get data out just connecting through Crystal using the ODBC DSN?

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[adigrescenko]

I connect this way:

DatabasePath = "c:\work\adi\test.mdb"
TableName = "MyTable"
DBTables.Add DatabasePath, TableName

than

str = "Select * from Table"
Report.SQLQueryString = str