Parent / Child Connections

Why does the Child Table not show the correct data?
Whenever possible, use an indexed link to connect two Tables. In some cases you may not be able to create an Index, so the Non-Indexed link option is available.

One example of a problem occurs when using Access databases. If you use an Access Table as the Child and do not use an Indexed link, the Parent/Child connection cannot be made. The Access Child data will always show the entire Table rather than the data associated with the linked field.

What happens to a Parent / Child connection when I change the Index on the Child Table?
Since the Index on the Child Table is essential in connecting to the correct Field in the Parent Table, resetting the Index-order on a Child Table will disconnect any Parent / Child connections made. Also, when you want to reconnect the Parent/Child connection, you must set the Index order in the Child Table back to the Field used in the connection in order to see the correct data. To Set Index Order:
1. Right click the Query for the Table you want to work with
2. Select 'Set Order’

Filters

How do I get Fast Indexed Filter to work?
In order to use the Fast Indexed Filter you must first set the index order of the Table you want to filter.
1. Highlight the Query for the Table you want to filter.
2. Right click the Query.
3. Choose 'Set Order'
4. Choose the field on which you want to filter.

Grid Data

When using Filter-by-Grid, is there an easier way to get to the field I want to filter on other than tabbing?
Yes. Before using Filter | Begin Filter-by-Grid menu, highlight the Field you want to filter on.

Why does the data seem to change in the fields under Single Table or Multi-Table view?
It is important to note that in order for the data in a Grid to show correct information when using a Filter or when connected to an ODBC source (such as Access) that you set the Index Order for the Table. Otherwise, as you edit data or move around the Grid, the data seem to 'change' (though it doesn't actually change in the Table).

To Set the Index Order for the Table:
1. Right click the Query.
2. Choose 'Set Order'.
3. Choose the field you want to Index on. This means you are setting      the Index Order for the Table.

I have data in the Multi-Table View Grid and it is not correct. How do I fix it?
If you are using more than one Table in the Datamodule and you use fields from both Tables in the Multi-Table View, there must be a Parent/Child connection or the data in the Multi-Table View will not be correct. If there is no Parent/Child Index, dQuery assumes a one-to-many relationship. This results in the data appearing incorrect.

In Multi-Table View, if the first table (TABLE1) is listed as the Parent Table, you will see every record of TABLE1 for every entry in TABLE2. Your data will appear like this:

TABLE1 Item1 TABLE2 Entry1
TABLE1 Item1 TABLE2 Entry2
TABLE1 Item1 TABLE2 Entry3
TABLE1 Item1 TABLE2 Entry4
TABLE1 Item2 TABLE2 Entry1
TABLE1 Item2 TABLE2 Entry2
TABLE1 Item2 TABLE2 Entry3
TABLE1 Item2 TABLE2 Entry4
.
.
.
TABLE1 ItemM TABLE2 EntryN

If the second Table (TABLE2) is listed as the Parent Table, you will see every entry of TABLE2 for every record in Table1 (TABLE1) Your data will appear like this:

TABLE1 Item1 TABLE2 Entry1
TABLE1 Item2 TABLE2 Entry1
TABLE1 Item3 TABLE2 Entry1
TABLE1 Item3 TABLE2 Entry1
TABLE1 Item1 TABLE2 Entry2
TABLE1 Item2 TABLE2 Entry2
TABLE1 Item3 TABLE2 Entry2
TABLE1 Item3 TABLE2 Entry2
.
.
.
TABLE1 ItemM TABLE2 EntryN

Indexed Search

Search | Indexed Search does not work. How do I fix it?

In order to use Search | Indexed Search, you must have an active Index. Creating Indexes in Fields when creating a Table does not activate the Indexes. To activate an Index:
1. Make sure you have created Indexes in the Table.
2. Go to Tables | Set Indexes.
3. Set the Order.
OR
1. Right click on the Table.
2. Chose Set Order.

Database Aliases

How do I delete a database alias?
In order to Delete a database connection that uses an ODBC connection, you must do so directly in the BDE in two places Here are instructions :

First close dQuery completely.
1. Open BDE Administrator: Go to | Start | All Programs | dQuery | BDE      Administrator
        a. Go to the Databases Tab.
        b. Right click on Databases.
        c. Choose ODBC Administrator
2. Go to the ‘User DSN’ Tab.
        a. Highlight the Database name you want to delete.
        b. Click remove button.
        c. Click OK
3. Go to the ‘Databases’ Tab of BDE Administrator.
        a. Right click database name.
        b. Choose ‘Delete’ (Youmay get message here that it is not  found– That’s ok just click OK and close out of the BDE)
4. Close the BDE and Open dQuery. You should see that this database is no longer listed.

Export Wizard

Why do I get a 'Rowset is read only' error when trying to export my data?
When 'mapping' fields to a Table that already exists, you cannot export to any AutoIncrement fields in the 'receiving' Table. Though you may export an AutoIncrement field's data, the receiving field's type cannot be AutoIncrement.

SQL Query Designer

When I try to use GROUP BY, I get the error "Database Engine Error: When GROUP BY exists, every simple field in projectors must be in GROUP BY." How do I fix it?
When you use GROUP BY in the SQL Designer every field in the OUTPUT FIELDS list MUST be moved to the GROUPED ON side in the order you want them to be grouped.
Note: you cannot have memo fields when using Group By

When setting more than one condition, the last condition does not work. What do I do?
When setting conditions, in order for the last condition to be applied, press the Enter key.

Reports

Why does the Automatic Report on the Report View Tab wrap text when rows are too long instead of adjusting the line to fit across the page?
The Report View is designed to show a quick report using the View you created in Multi-Table View. Changes are made using the Report Editor:
1. Save the report by going to Report | Save Current Report As. . . on  the menu bar.
2. Save the Report with the name you want to call it, in the directory  you want it stored.
3. Go to Report | Edit Report.
4. Locate the report you just saved.
5. Click OK
This launches the Report Editor where you can drag-and-drop elements, add titles, change font styles and sizes, and make other changes to tailor your report to your requirements.

Why does the menu item, Report | Edit Report not work?
Before you can edit a report, the DataModule and the Report must be saved.
1. To save the DataModule, go to File | Save.
2. To save the Report, go to Reports | Save Current Report As. . .

How do I set properties for text objects?
There are many useful properties for text objects in Reports. Here are some of the most commonly used :

In Report Design Mode, bring up the Report Inspector:
1. Highlight the field you want to edit. Right click it.
2. Choose 'Inspector'.
3. In the Inspector you should see the field you are modifying listed at the top.
4. Go to the 'Properties' Tab of the Inspector and you will see Categories (if you are in Category View)

How do I change the Orientation from Portrait to Landscape?
You can change the page orientation default to Landscape for all reports by going to the Properties | dQuery Properties menu and running the Wizard.

To change the page orientation for one report only, in Report Design Mode :
1. Right click report design surface.
2. Choose Inspector.
3. Click the drop down button (at the top) to view the object list.
4. At the top you will see '. form' Click it .
5. To set the form's properties.
        a. Make sure you are in Category View.
        b. In the 'Properties'Tab find 'metric'. (If in Category View, this will be in 'miscellaneous').
        c. Click the field next to 'metric.'
        d. Click the drop down button.
        e. Choose '3 - Inches'(This changes the setting to inches from metric)
6. Find the 'printer' property (also under 'miscellaneous' in Category View)
        a. Highlight the field next to 'printer'
        b. Click the 'I' iconto 'Drill Down' to it's property set.(in the top you shouldsee printer)
        c. In 'Properties' Tabfind 'orientation' -- change it to '2 - Landscape'
7. Click the back button at the top (you should now be back at '.form')
8. In the 'Properties' Tab find 'PAGETEMPLATE1' (in 'user-defined' in         Category View)
        a. Click the 'I' to 'Drill Down' to the PageTemplate1 Properties.
        b. Change theseproperties (under 'miscellaneous' in Category  View)
             marginBottom = 0.25 (*Press enter to affect changes)
             marginLeft = 0.50
             marginRight = 0.25
             marginTop = 0.50
        c. In 'Position' in Category View, change these properties:
             height = 8.5
             width = 11
9. In the 'Properties' Tab, find 'STREAMFRAME1' (in the 'user-defined' in Category View)
         a. Click the 'I' to 'Drill Down' to the Streamframe1 Properties.
         b. Find theheight, left, top and width properties and enter these values:
             top= stays the same unless you move headings around to             makemore room for the top of the stream frame)
             height = (7.75 - top)
             left = 0.00
             width = 10.25
10. At this point you can move the text objects around to fit the new orientation of the report.

Microsoft Access

Is there anything special to do when working with Microsoft Access Databases and Tables?
When using an Access table as the Child (Detail) Table, always set an Index link. If you do not have an Indexed link, the Parent / Child (Master / Detail) connection cannot be made. The Access Child data will show the entire Table rather than the data associated with the link.

Microsoft Excel

How do I import data from an Excel spreadsheet?
At this time, dQuery does not import column headings from Excel. In Step #8, you will need to have the exact names and column letters of the headings from the Excel spreadsheet in order to map the fields. We recommend printing the first page of the Excel spreadsheet so you will have them in front of you.

1. Start with a new Datamodule.
2. Add the Design Surface the Database and the table you want to import to.
3. Click the ‘Import Wizard’ Toolbar button.
4. Choose Excel Spreadsheet. Next.
5. Find your Excel source file. Next.
6. Set ‘Start Cell’ to A2 (since we are not importing the headings) and ‘End Cell’ should be K397. Next.
7. The Excel columns can now be mapped to the destination Table.
8. At this time, you need to know what the columns in Excel are. Use the print out of the first page to map to the column headings. For example,

Source            Destination
A                     Company
B                     LastName
C                     FirstName
D                     Phone
E                     Address1
F                     Address2
G                    City
H                    State
I                      Zip
J                    Country
K                    BalDue

9. Next .
10. Finish.

1. Start with a new blank Datamodule.
2. Add to the Design Surface the Database and Table containing the data you want to export.
3. Click the Export ‘Export Wizard’ button from the Toolbar.
4. Choose ‘Current Query.’ Next.
5. Choose ‘Excel Spreadsheet.’ Next.
6. Choose the destination file and name where you want to save the new Excel file. Next
7. Check the box, Show Spreadsheet. This will launch the  spreadsheet and you will see all your data in Excel.
8. After you have viewed the Excel spreadsheet, simply close Excel and you will be directed back to the Export Wizard to finish.
9. Finish.

Known Issues

Current limitations of dQuery version 3.01 and earlier versions:
- Cannot open a table that contains field names of more than 31 characters.

These limitations will be addressed in a future release.