Today I've written a program with roughly the following syntax:
for each customer no-lock:
select count(*) into vtotal from orders
where order.cust_id = customer.cust_id.
if vtotal < 5 then next.
for each order where order.cust_id = customer.cust_id no-lock:
display order.
end.
end.
when I run the program I get an error about the -s parameter.
When I replace the select count statement with a:
for each order...
assign x = x + 1.
end.
there's no problem.
Does anybody know what the problem is?
And is this some sort of incompatibility between Progress and SQL?
TIA,
Luuk
for each customer no-lock:
select count(*) into vtotal from orders
where order.cust_id = customer.cust_id.
if vtotal < 5 then next.
for each order where order.cust_id = customer.cust_id no-lock:
display order.
end.
end.
when I run the program I get an error about the -s parameter.
When I replace the select count statement with a:
for each order...
assign x = x + 1.
end.
there's no problem.
Does anybody know what the problem is?
And is this some sort of incompatibility between Progress and SQL?
TIA,
Luuk