Answering my own question...
Further research revealed that you can get the number of tables in the database with this code.
----- CRReport = createobject ("CrystalRuntime.Report")
----- CRReport.Database.Tables.Count
I include this just in case it helps anyone.
Shawn Burke
>First off thanks to everyone for help with Crystal. I too want to put in an extra plug for Craig and his article (
http://www.craigberntson.com/Articles/kb010.htm) it was a great beginning point.
>
>Question regarding the database object in the CrystalRuntime.Report object. I have successfully figure out that I can get the source table by the following code.
> oTable = CRReport.Database.Tables(1)
>This makes oTable the "BORROWER" table that I created from. My question now is how do I determine the number of tables in the database? I designed the test report, so I new there was one, and tried the above code just because it made sense... luckily it worked. But I cannot find a reference to any function that tells me the number of tables in the databse. I want to loop through the tables and call this code:
> oTable.SetDataSource(oADODB_RecordSet)
>to set the source as the ADODB connection I created for every table. Thoughts?