OK, probably old hat to most if not all of you guys here but this is day two of me, Firebird and SQL.

I have finally decided to delve into that mystical language of SQL. It always seemed like a lot of effort until I started some study yesterday.

I just made a bare bones app in D5 with a TDBGrid and in the ColumnTitleClick event, two lines of code.

Wow, wow wow. :)

Query1.SQL[0]:='SELECT * FROM Employee ORDER BY '+Column.FieldName;
Query1.Active:=True;

I AM hooked. Probably a million things wrong with that approach, but it sorted dates, dollars everything.

Harry