Norm-al
asked on
Sorting NULL values in DBGrid
I want to sort my priority field ascending but some records are blank/null and by default, the sort puts those records first, before the other records thta have values. How can I sort my priority field ascending but place all the records with null fields at the bottom?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oops nevermind, I got the field in but can't seem to find the OnCalcField event... I set up the type as CalcEdit.
OnCalcFIeld is TDataset event
What component are you using? TAdoQUery?
What component are you using? TAdoQUery?
ASKER