Re: Dynamic Sql in Forms 4.5

have you tried using lexical parameters?

these types of parameters can be used to dynamically replace the FROM or WHERE or GROUP BY clauses.

you reference them in sql with the ampersand, &.

Select * from &tableName
Where &whereClause
;

Darrell Zawada

-- 
z