Query Module

 

Item Bugs/Issues Status
1 When running a query that spans multiple tables an error occurs: "Command contains unrecognized phrase/keyword." Released in  3.0.780.
2 Cannot edit the query conditions while in the query overview screen. Released in  3.0.780.
3 The query results are showing records that had been deleted so the count is off. Released in  3.0.780.
4 A syntax error occurs whenever a query is ran. Released in  3.0.778. 
5 Added the Debug Mode to query to see the exact syntax of conditions. Released in  3.0.778. 
6 When sending the query output to an Excel spreadsheet it tries to send it to Lotus instead. Released in 3.0.781 
7 When selecting to save the query to a file the "Files of Type" did not show the correct file type. Released in 3.0.781.
8 When adding a query, it sometimes brings over the previous queries conditions Released in 3.0.781
9 None of the queries, either converted or new ones will run. Get message - "QM_SQL()ERROR: cOutput File Empty!"  Released in 3.0.781
10 Place "Edit Record Filter" button next to the Query Condition list Released in 3.0.781
11

I added a new query. It added fine. I then immediately went and clicked on Add to add another query. Error: OLE IDispatch exception code 0 from Nodes: Element not found.             PROCEDURE FORM_QM_MAN.BTN_ADD.CLICK C:\PROGRAM FILES\IRIS 3.0\FRMQUERYMAIN.SCT

Released in 3.0.8
12 If you create a new query in IRis 3.0, the condition from previous query is copied to the new query. Released in 3.0.8
13

Opened IRis Query. Pressed ESC on the keyboard. Error:  Unknown member TRVQUERY. PROCEDURE FORM_QM_MAN.RELEASE C:\PROGRAM FILES\IRIS 3.0\FRMQUERYMAIN.SCT. Line #1  

Released in 3.0.8
14 I downloaded the PDF portion of IRIs, and it installed fine.  The problem I’m having is getting the file to save in a location and have it consistently produce a successful PDF file.  After running a query, I choose the “send the report to” option to PDF Document, and under “Disk File Name” I type the name I want the report saved as.  I have tried several different ways in making this work.  I can not make any sense out of it.  Sometime the PDF file will have contents in it and sometimes the file is blank.  Also, I have tried choosing a specific location for the file, it doesn’t seem to work.  The file keeps going directly to my C:\Winnt\System32 folder and I have to go to Start and Find and have it search for the file to find it.  Released in 3.0.8
15 PDF file in Iris Query - unable to (1) name the file and (2) select location where to save when sending the report to PDF Document. Released in 3.0.9
16 After running a Query, it gives the option “send the report to”, I’ve tried sending the report to a MS Word 2000 Document, and it gives me a blank Word document without the query info.  Is this function working?  Also, the PDF document part doesn’t want to work.  It asked me if I wanted to download that function.  I answered NO to this download.  I have Adobe Acrobat on my computer and was able to print the form to Adobe Distiller which enabled me to get my query to a PDF file.  Is there a way to get the PDF file to work directly from IRis. Answer yes to have IRis install the driver it needs. Once you do that the PDF will work perfectly.  I will test the MS Word procedure and let you know when it may be fixed or any other information I can find out. Released in 3.0.9
17 When deleting a query record it also deletes a group from the groups table. Released in 3.0.9