Monday, 11 June 2012

Writing Inline Queries using PS Query Tool

To achive this we can use SQL objects
appdesigner create SQL object with in line select statement
use this SQL as exprestion in PSQuery
click on Add Expresstion


In Expresstion test place give SQL(Name of SQL Object) like ( %SQL(V_TEST))

click on save and then click on use it as field


1 comment:

  1. This does not work in PS 9.1 Ptools 8.51 as it does not allow FROM keyword in expression.DO u know any other way to use inline sub queries as a select column in PS query.

    ReplyDelete