B
Bill
Guest
What is the syntax to run a straight sql statement in a progress application?
SELECT count(distinct myField2) FROM myTable WHERE myField = myVariable);
I've figured out how to do this with a for each but I would still like to run this command. Using a for each:
def var iTmpCount as int no-undo.
for each myTable no-lock where myField = myVariable break by myField2:
if first-of (myTable.myField2) then
iTmpCount = iTmpCount + 1.
end.
Continue reading...
SELECT count(distinct myField2) FROM myTable WHERE myField = myVariable);
I've figured out how to do this with a for each but I would still like to run this command. Using a for each:
def var iTmpCount as int no-undo.
for each myTable no-lock where myField = myVariable break by myField2:
if first-of (myTable.myField2) then
iTmpCount = iTmpCount + 1.
end.
Continue reading...