da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Sort Question

Forum List » AnyDAC » v 1.x General English

kquick
User

Fresh Boarder

Posts: 1

Karma: 0

Sort Question

Posted: 2007/12/23 17:02

What have I done wrong
when I use this line of code in Delphi I get A error from AnyDac

DtMdlTrain.TblClient.View.Sort := 'lname ASC';

This is the only way I could come up with to do a sort ascending on a field in a TADTAble. I have used this same method with Delphi DBExpress and ADO Table components except that i do not have to call table.view.sort just table.sort

Diman

Admin

Posts: 1470

Karma: 18

Re:Sort Question

Posted: 2007/12/24 01:20

Hello

1) AnyDAC has different syntax - field[:[D][A][N]];...
Where D-desc,A-asc,N-nocase
2) So, you can write - DtMdlTrain.TblClient.SourceView.Sort := 'lname:a';
3) In v 2.0 you can write DtMdlTrain.TblClient.IndexFieldNames := 'lname:a';

Regards,
Dmitry

Forum List » AnyDAC » v 1.x General English