Cannot find what you need? - Click here to contact us

Close




Query is too complex

For some of the complex searches that use nested queries you may receive the notice 'Query is too complex'. This is normally only seen when you are using the simple file database which has a limitation on the size of the query you can ask to the database.

At this time the only way around this limitation of the simple file database is to reduce the amount or size of results you are searching for. You can also upgrade your database to MSSQL (SQL Express is free) which has a much larger query size.

Please let us know if you have received this error so we can confirm there is no other problem or issue.
Last updated, 8 April 2014, 07:58




Leave a reply (Login required)




Schedule it Ltd
/faq/10338/query-is-too-complex

Subscribe to our newsletter and receive our free scheduling tips and articles to help you improve the planning in your business. Unsubscribe anytime.

GET STARTED RESOURCES
Login Support and Help
Register Blog
Features Privacy Policy
Online Pricing Terms and Conditions
On-Prem Pricing Industry Sectors
Latest Version Reviews and Feedback
Live Webinar Status
APPS POPULAR SEARCHES
Web App Team Scheduling
iOS App Employee Planning
Android App Customer Scheduling
Zapier App Engineer Scheduling


Start Your Free Trial Today



Copyright © 2003-2022 Schedule it Ltd. All rights reserved.
Schedule it on LinkedIn   Schedule it on Twitter   Schedule it on YouTube   Schedule it on Facebook
Join Us - Live Webinar
...
 
Help Topics
Contact Us