Liveware Publishing Support Forum

I have never used RI_REPLACE and I have an occasion where I would like to use it.____I have a UserSQL and part of the SQL filters on a Date.____How can I prompt for the date so it is part of the SQL statement (the result set will be too big if not part of the initial Select).____This is the initial User Defined SQL:__SELECT *__FROM customers__WHERE dEffDate = <<^09/28/2005^>>____Can I use:____SELECT *__FROM customers__WHERE dEffDate = <<?"Enter Date">>____Can this be done? If so, how?____Thanks

You cannot automatically prompt for an RI_REPLACE value. You would need to write your own front end code the collect the value from the user and then programatically populate the RI_REPLACE value with the user input.____Kathleen__R&R Support

Thanks!