vbojan
Well Known Member
Hi List,
Is there any way in JDE to retrieve sum for some field without of fetching records (like "SELECT SUM (FieldName) FROM (TableName) WHERE…")? I’d like to avoid network traffic with:
TableName.Select
TableName.FetchNext
While SV File_IO_Status is equal to CO SUCCESS
TableName.Fetch Next
End While
and fetch the result only.
Thanks in advanced.
Bojan.
B733.2, SP 10, NT 4.0, SQL 7.0.
Is there any way in JDE to retrieve sum for some field without of fetching records (like "SELECT SUM (FieldName) FROM (TableName) WHERE…")? I’d like to avoid network traffic with:
TableName.Select
TableName.FetchNext
While SV File_IO_Status is equal to CO SUCCESS
TableName.Fetch Next
End While
and fetch the result only.
Thanks in advanced.
Bojan.
B733.2, SP 10, NT 4.0, SQL 7.0.