Hi All,
Am simply trying to rename a column in an sql query in Progress 9.2 (from the tracks):-
The following query:-
select pt_part as part from pt_mstr.
...gives me:-
** Invalid datatype -- sample types are: char, integer, date, logical (222)
And this query:-
select pt_part, 1 as part from pt_mstr.
...gives me:-
** AS or LIKE phrase not allowed with expressions. (591)
What's going on?
Thanks,
Rob
Am simply trying to rename a column in an sql query in Progress 9.2 (from the tracks):-
The following query:-
select pt_part as part from pt_mstr.
...gives me:-
** Invalid datatype -- sample types are: char, integer, date, logical (222)
And this query:-
select pt_part, 1 as part from pt_mstr.
...gives me:-
** AS or LIKE phrase not allowed with expressions. (591)
What's going on?
Thanks,
Rob