adding a constant value to the results of an progress query

Question

Is there anyway to add a constant value in the results of a progress query?

In sql server you can do it by going

select *, 1 As DateID from dbo.customers

1 being the static field inserted Not sure how or if you can do this in a progress db?

Answer 1

No, there is no way to add constant values to the result when you use "*" in the query. One workaround is to write all the column names instead of using "*" and then at last use constant value in the query.

Example:

select c1, c2, c3, c4, 1 as DateID from dbo.customers