jlo
|
| Posted: 01/29/2004, 7:32 AM |
|
Search_Results.txtSQLdisplay.Value = Search_Results.datasource.SQL 'works
Hi
trying to retrive the AssembledWhere property with no success
I have a textbox in 'Search_Results' grid form , when I try and set it in the Search_Results_txtSQLdisplay_BeforeShow() event I am not sure what the object in object..AssembledWhere should be. I have tried
'Search_Results.txtSQLdisplay.Value = clsSearch_ResultsDataSource.GetWhere()
'Search_Results.txtSQLdisplay.Value =clsSearch_ResultsDataSource.AssembledWhere
'Search_Results.txtSQLdisplay.Value =clsSQLParameters.AssembledWhere
'Search_Results.txtSQLdisplay.Value =Search_Results.AssembledWhere
'Search_Results.txtSQLdisplay.Value =Search_Results.datasource.AssembledWhere
'Search_Results.txtSQLdisplay.Value =clsSearch_ResultsDataSource.AssembledWhere
'Search_Results.txtSQLdisplay.Value =clsSearch_ResultsDataSource.Where
any help appreciated , sorry to be such a newby 
|
|
|
 |
DonB
|
| Posted: 01/29/2004, 9:46 AM |
|
It is available in the WhereParameters property of the Datasource, but will
not be defined until the Before Execute Select event. Look at the Code page
of any page with a datasource and you will see how it all gets put together.
--
DonB
http://www.gotodon.com/ccbth
"jlo" <jlo@forum.codecharge> wrote in message
news:6401927a4822fc@news.codecharge.com...
> Search_Results.txtSQLdisplay.Value = Search_Results.datasource.SQL 'works
> Hi
>
> trying to retrive the AssembledWhere property with no success
> I have a textbox in 'Search_Results' grid form , when I try and set it in
the Search_Results_txtSQLdisplay_BeforeShow() event I am not sure what the
object in object..AssembledWhere should be. I have tried
>
> 'Search_Results.txtSQLdisplay.Value =
clsSearch_ResultsDataSource.GetWhere()
> 'Search_Results.txtSQLdisplay.Value
=clsSearch_ResultsDataSource.AssembledWhere
> 'Search_Results.txtSQLdisplay.Value =clsSQLParameters.AssembledWhere
> 'Search_Results.txtSQLdisplay.Value =Search_Results.AssembledWhere
> 'Search_Results.txtSQLdisplay.Value
=Search_Results.datasource.AssembledWhere
> 'Search_Results.txtSQLdisplay.Value
=clsSearch_ResultsDataSource.AssembledWhere
> 'Search_Results.txtSQLdisplay.Value =clsSearch_ResultsDataSource.Where
>
> any help appreciated , sorry to be such a newby
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
jlo
|
| Posted: 01/30/2004, 3:47 AM |
|
thanks thats great
|
|
|
|
|
