Freehand SQL Views for Foxpro db
20 October, 2009
I am trying to create yellowfin views using custom SQL on a foxpro db.
These views would then be used to create reports.
When I select the ?freehand sql? option to author a view I cannot select the Foxpro DB DSN to select the tables.
These views would then be used to create reports.
When I select the ?freehand sql? option to author a view I cannot select the Foxpro DB DSN to select the tables.
Freehand SQL views cannot be written against the FoxPro DB because it doesn't support the necessary SQL syntax required for this option. The database source needs to support SQL Subselects for this to work. Yellowfin detects the type of database it is connected to and restricts access from functions that are beyond the databases capabilities.
You should be able to create a Freehand SQL report, using existing SQL. But not a view.
I am not sure about the internal capabilities of FoxPro.. but possibly you can create a Database View within FoxPro itself, and then create a Yellowfin View based on that.
Otherwise you will have to replicate the SQL View's functionality using the Drag-n-Drop View-Builder.
You should be able to create a Freehand SQL report, using existing SQL. But not a view.
I am not sure about the internal capabilities of FoxPro.. but possibly you can create a Database View within FoxPro itself, and then create a Yellowfin View based on that.
Otherwise you will have to replicate the SQL View's functionality using the Drag-n-Drop View-Builder.