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?

Thanks,

>-----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)
|/---------------------------------------------------
*----------------------------------------------------