FAQ
Parent
/ Child Connections
Why does the Child Table not
show the correct data?
What happens to a Parent / Child
connection when I change the Index on the Child Table?
Filters
How do I get Fast Indexed Filter
to work?
Why do the results of using the
Filter Wizard not immediately appear on screen?
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?
Why does the data seem to change
in the fields under Single Table or Multi-Table view?
I have data in the Multi-Table
View Grid and it is not correct. How do I fix it?
Indexed
Search
Search | Indexed Search does
not work. How do I fix it?
Database Aliases
How do I delete a database alias?
Export
Wizard
Why do I get a 'Rowset is read
only' error when trying to export my data?
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 setting more than one condition,
the last condition does not work. What do I do?
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?
Why does the menu item, Report
| Edit Report not work?
How do I set properties for
text objects?
How do I change the Orientation
from Portrait to Landscape?
Microsoft Access
Is there anything special to
do when working with Microsoft Access Databases and Tables?
Microsoft Excel
How do I import data from an
Excel spreadsheet?
How do I export data to an Excel
spreadsheet for further analysis?
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.
Why
do the results of using the Filter Wizard not immediately appear
on screen?
When using the Filter Wizard's Standard or Fast Indexed Lookup, the
results do not show in the DataModule until you move off of the Query
you are filtering and then move back. This is a refresh issue we will
correct it soon.
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’ (You may 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. Charges 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'
icon to 'Drill Down' to it's property set.(in the top you should
see printer)
c. In 'Properties'
Tab find '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 these
properties (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 the
height, left, top and width properties and enter these values
:
top
= stays the same unless you move headings around to make
more 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.
How
do I export data to an Excel spreadsheet for further analysis?
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.
|
