Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Who I cool Used a Limit from a CustomSQL

Status
Not open for further replies.

mcruli

Programmer
May 23, 2003
1
US
If Make a Limit based in a CustomSQL. From the Query, this work. Bud if i try to make this limit from a EIS form, this Dnot work, ?¿ ; I Try this code from BRIO EIS from:


Limit = ActiveDocument.Sections["Query"].Limits.
CreateLimit("V Segmentomovil.Movil")
ActiveDocument.Sections["Query"].Limits.Add(Limit)
Limit.CustomSQL = "{ fn LENGTH(V_Segmentomovil.Movil) } >5"
Limit.DisplayName = "Movil_SQL"

Console.Writeln("Limit Moviles_SQL_WHEREQuery")


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top