Question Progress 9.1d Nested Query & Field Names

AlexTheDroog

New Member
I am running Vantage 6.1 with a Progress 9.1D back end. Vantage uses something called Business Activity Query as a front end GUI for writing database queries.

1) If I do a calculated field, the field name displays as Field1. The "AS" command does not seem to rename the field. I also tried to output place holders (Just named fields with no data). The closest I can get is using ="".

2) I wanted to use a nested query to preform an "IN" or "NOT IN" query. I'm not sure how to go about that.
 
Top