SET OPTION SQL_BIG_SELECTS = 1 in querry

CodeCharge Studio

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

SET OPTION SQL_BIG_SELECTS = 1 in querry

Author

Message

itzumar

Posts: 88

Posted: 06/07/2013, 10:50 AM

i want to place this line of code in my view. can any body tell me how?

"SET OPTION SQL_BIG_SELECTS = 1"

as i have large number of rows in database? please suggest me how to use it?

should i use in custom code or in view? and how ? any example
_________________
Umar

mor

Posts: 119

Posted: 06/07/2013, 10:57 AM

Quote itzumar:
i want to place this line of code in my view. can any body tell me how?

"SET OPTION SQL_BIG_SELECTS = 1"

as i have large number of rows in database? please suggest me how to use it?

should i use in custom code or in view? and how ? any example

If it needed for one form (for example Grid, Record, etc.) you can use custom SQL query and add yours string at beginning of query.
_________________
Mor ve Ötesi

itzumar

Posts: 88

Posted: 06/07/2013, 6:08 PM

i want it in more than one form. can u help me with example and how i implement it while creating views?
_________________
Umar

These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home | Search | Members | Register | Login