Sort

[Rickinrsm]

See the SORT portion of the script at the bottom of the post.

q=

Query
ANSWER: RIV:AnswerTopOffices.DB

Coastal.DB | SalePrice | ListName |
| CALC SUM ALL AS SalePrice | Check |

EndQuery


if not q.executeQbe()then
errorShow()
return
endif
If Not tc.open("RIV:AnswerTopOffices") then
errorShow()
Return
endIf

Sort "AnswerTopOffices.db"
ON "SalePrice" D
EndSort

This sort fails? Nothing seems to work.

Any assistance wold be greatly appreciated.

Thanks much. Rick

 

[TonyMcGuire]

Just by chance, do you have "D" declared as a variable?

Either in this method, or at any level higher where this method can 'see' it?

If so, the sort will fail.

Could this be the issue?


Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.

 

[Rickinrsm]

The only other D in is my Alias statement which is pointing to my D drive. Could that be the problem?

I thought that D after the word SORT stood for decending?

thanks . . . Rick

 

[Rickinrsm]

Here is my aslia statement . . .

addAlias("MYDIR","Standard","D:\\Pdoxwin7\\Working")


Could this be the problem?

thatnk again.

 

[TonyMcGuire]

I just relooked.

You are setting the answer table to "RIV:", but your sort statement doesn't have an alias, and so is using ":WORK:".

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities.