Normal sql query via odbc (openlink) does not work in progress

[navila]

Hi all I want to make this sql instruction from openlink odbc :

select vend_code,count(*) as howmany from customer group by vend_code

the as does not work, It also does not work from the progress procedure editor.

This is a normal ansi-SQL statement ... What could be wrong ?

Thanks

NEA

 

[franklin1232]

Well it won't work using the procedure editor. The procedure editor only support 4GL. You would have to do something like this.

FOR EACH Vend_Code.
ASSIGN i = i+1
END.
DISPLAY i

There might be a record count fuction, but I'd have to look it up.

For ODBC use MSQuery to build your SQL statement then look at the SQL string. You will notice some difference if you use to looking at SQL server or MS Access. I haven't used the openlink drivers. With version 9.1a and above Merant and Progress have colabarted on a decent SQL-92 driver.

http://www.progress.com:6336/dynaweb/psdoc91c/@Generic__CollectionView;cs=default;ts=default