DB.SQL.QUERY Requires Destination Number in Excel

SUMMARY

When using the DB.SQL.QUERY function with a TYPE of three, the argument DESTINATION must be specified.

The query will also fail if the second argument, QUERY, is not enclosed in double quotation marks (").

MORE INFORMATION

When you specify a filename that contains the query you are trying to pass to Q+E, you must specify a destination number for the extracted records. If no destination number is selected, the result of the query will not appear on your active sheet.

Notes

1. The function DB.SQL.QUERY() is provided by the add-in macro QE.XLA. You must have QE.XLA open to use this function.

2. The following example assumes that the query file QUERY1.QEF contains a valid Q+E query.

3. If QUERY1.QEF is not in the current directory, you will need to add the complete path to it. For example

         c:\excel\qe\query1.qef
   

   A1: =INITIATE("qe","system")
   A2: =ACTIVATE("sheet1")
   A3: =DB.SQL.QUERY(3,"query1.qef",1,,false)
   A4: =RETURN()

REFERENCES

"Q+E for Microsoft Excel User's Guide." Version 3.00, page 71.