Passthrough Queries with Quick Data

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/332109171

July 05, 2009, 05:54 PM

Stefaans

Passthrough Queries with Quick Data

Hi Does anyone know if there is some way to issue a 'passthrough' query to SQL Server or Oracle from within Quick Data.

WebFOCUS 7.7.01 Windows, TSO 7.0

July 06, 2009, 03:22 AM

GamP

Since quick data calls up a version of the report assistant, I don't think there is a way to insert some non-gui code like sql passthrough code. But maybe someone else comes up with a brilliant idea?

GamP

- Using AS 8.2.01 on Windows 10 - IE11.
	in Focus since 1988

July 06, 2009, 03:28 AM

<JG>

Not as a direct query as they must be created using the Report assistant which does not allow you to write
an SQL Passthrough request.

However if you use Structured Adhoc Forms (SAF's) then you can, as the query behind
the form can be SQL Passthru.

The Quick data tech memo does not show SQL Passtrugh but it does explain using SAF's.

Using the WebFOCUS Quick Data Add-In