-----Original Message-----
FP 2000 seems to have a size limit on placing large SQL
Statements into the Custom Query box in the Database
Results wizard.
Anyway around this?
Define as much of the query as possible within the
database, and then use a simpler SQL statement in the DRW.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------