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?
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