FP Database Result missing Criteria/Ordering

  • Thread starter Thread starter Andre T.
  • Start date Start date
A

Andre T.

When I use database result wizard in FP 2000 against MS Access 2000 on my
WinXp 2000 Pro, I encounter the following problem:

At step 3 of 5, I selected the fields from the <Edit List...> button, then
clicked <More Option...> to get in More Options screen. Strange things
happen here: only the default button is enabled, both Criteria and Ordering
buttons are grayed out.

How can I enable these two buttons? Your advices and comments will be
appreciated.

Andre T.
 
-----Original Message-----
When I use database result wizard in FP 2000 against MS
Access 2000 on my WinXp 2000 Pro, I encounter the
following problem:

At step 3 of 5, I selected the fields from the <Edit
List...> button, then clicked <More Option...> to get in
More Options screen. Strange things happen here: only
the default button is enabled, both Criteria and Ordering
buttons are grayed out.

How can I enable these two buttons? Your advices and
comments will beappreciated.

Andre T.
Click to expand...

This usually occurs because you specified a custom query
in step 2 of the wizard. Once you tell the wizard that you
want to supply your own SQL statement, the wizard can no
longer make SQL statement modifications.

If this is indeed what's going on, you'll have to control
criteria by hand-modifying your SQL statement's WHERE
clause, and ordering by modifying the ORDER BY clause.

Jim Buyens
Microsoft FrontPage MVP
(e-mail address removed)
http://www.interlacken.com
Author of:
*------------------------------------------------------*
|\----------------------------------------------------/|
|| Microsoft Office FrontPage 2003 Inside Out ||
|| Microsoft FrontPage Version 2002 Inside Out ||
|| Web Database Development Step by Step .NET Edition ||
|| Troubleshooting Microsoft FrontPage 2002 ||
|| Faster Smarter Beginning Programming ||
|| (All from Microsoft Press) ||
|/----------------------------------------------------\|
*------------------------------------------------------*
 
Hi, Jim -

Thanks for the advice. Indeed I've been doing custom
query, and have been doing WHERE and ORDER BY myself.
I'll try the other way you suggested.

Thanks,
Andre T.
 
Back
Top