BOb 4.1.2
Oracle 7.3.3.0.0
Citrix 1.60.179.94 (Service Pack 5)
Is there anyway to access the SQL when using Freehand SQL as a data provider.
I know that BOb itself doesn’t recognize Freehand, since it bypasses the universe, but is there a way using SBL/OLE to extract the SQL automatically so it can be saved to a text file?
We have several reports using Freehand SQL so this is not a one-time process.
BOb/SBL seems to lack any exposed properties or methods for Freehand SQL. Given that limitation, my approach to automating Freehand reports is to have SendKeys choose an SQL text file that has been previously adjusted in code as needed, and run it.
Oren Haber-Schaim
Fidelity Investments
Is there anyway to access the SQL when using Freehand SQL as a data provider.
I know that BOb itself doesn’t recognize Freehand, since it bypasses the universe, but is there a way using SBL/OLE to extract the SQL automatically so it can be saved to a text file?
We have several reports using Freehand SQL so this is not a one-time process.