> One more question... after set this properties to new
> order by column, the query need be refreshed ? like
> iboquery1.refresh ?

No, just change that part of the SQL using the SQLOrder property and IBO
takes into account all things and does the refresh for you automatically.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com