|Posted: 06/07/2013, 6:58 PM
I have ListBox in one of my records (a search record).
I need to know how to do at least one of these 2 things:
1) Change the SQL in a Before Build Select (or Execute).
I found this in the CCS documentation, but it gives me an error.
//Tasks_BeforeExecuteSelect ((TableCommand)Select).SqlQuery = new StringBuilder("select top 3 * from ages");
It doesn't like the "TableCommand" part... But the documentation doesn't say if I maybe need to add some sort of "Using" tag at the top of the page.
2) Change only the "DataTextField".
I've tried to use the DataTextField property of MTListBox, but nothing happens. I must be using it wrong.
Has anyone ever tried something like this? I've done it in other languages, but I can't get it to work with C#... Thanks.