1217148 - What is the maximum size for a SQL command?

SAP Knowledge Base Article - Public

1217148 - What is the maximum size for a SQL command?

Symptom

In Crystal Reports 9 and above, the Add Command function is used to create a SQL command (such as a SQL query).

 

What is the maximum size for a SQL command?

Environment

  • Crystal Reports
  • Crystal Reports for Visual Studio

Resolution

The maximum size for a SQL command is 64 KB. If your SQL command is larger than 64 KB, we recommend using a stored procedure.

For more information on the Add Command function, download cr_query_engine.pdf from the Business Objects support site at http://support.businessobjects.com/search.

Keywords

ADD COMMAND SQL QUERY LIMIT MAX BIGGEST SIZE CR CR9 CR10 CUSTOMIZE CUSTOMIZED Crystal Reports Add Command SQL Query Maximum , c2015231 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2 ; SAP Crystal Reports, developer version for Microsoft Visual Studio ; SAP Crystal Reports, version for Visual Studio .NET 2005 ; SAP Crystal Reports, version for Visual Studio .NET 2008