Can I use SQL statement in Progress?

[Kenneth Chow]

Can anyone tell me if I can use SQL statement in Progress?

For example, I tried writing the follow statement aiming at find the number of records in a table but can't compile.

def var a as int.
a = select count(*) from table table_a.

But it is okay just to type select count(*).....to display the total number of records.

 

[Chris Kelleher]

DEFINE VARIABLE a AS INTEGER.
SELECT COUNT(*) INTO a FROM table.

 

[Kenneth Chow]

Thx chris. You're really a expert.