Passing values to later use in the SQL.

rbuser

Hi,
Does anyone know how to pass parameters from the application to the SQL?

Let's say End-User enters a value into some field in the application and
later on wants to reference to the inputted value(actually use it) in the
manually modified SQL, for example in the "where" clause.
Is there a way to accomplish this?

Thanks.
Moisey Blehman,
Software Developer

digitalmetaphors

You'll have to programatically change the SQL object to have SQL generated
for the WHERE clause. Here is an example of dynamically creating a criteria
object on a dataview:

http://www.digital-metaphors.com/tips/AddSearchCriteria.zip

Cheers,

Jim Bennett
Digital Metaphors

rbuser

"Jim Bennett (Digital Metaphors)" wrote in

digitalmetaphors

If you have edited the SQL, then you have to update the where clause. Here
is an example of do this on an manually edited dataview.

http://www.digital-metaphors.com/tips/EditSQLAndSearch.zip


Cheers,

Jim Bennett
Digital Metaphors