CodeCharge Studio | All ASP PHP Perl ColdFusion Java C#.NET VB.NET |
This example shows how to modify the SQL statement that is used to retrieve records for a Grid form. The example shows a Grid called Tasks that is based on the tasks database table.
Function Tasks_DataSource_BeforeBuildSelect(Sender) Tasks.DataSource.SQL = "SELECT * FROM Tasks" End Function
function Tasks_DataSource_BeforeExecuteSelect(& $sender) { global $Tasks; $Tasks->DataSource->SQL = "SELECT * FROM Tasks"; }
sub Tasks_DataSource_BeforeExecuteSelect() { $Tasks->{DataSource}->{SQL} = "SELECT * FROM Tasks"; }
//Tasks_BeforeExecuteSelect e.getCommand().setSql("SELECT * FROM Tasks");
'Tasks_BeforeExecuteSelect CType(Select_,TableCommand).SqlQuery = new StringBuilder("select top 3 * from ages")
//Tasks_BeforeExecuteSelect ((TableCommand)Select).SqlQuery = new StringBuilder("select top 3 * from ages");