Sort Record after using 'union' command

lee

Delphi Developer

Sun, 16 Jan 2005 13:54:21 GMT

Sort Record after using 'union' command

Hi guy,

good day. Anyone of you know how to sort the record after using 'union'
command ? 'order by' giving me an error message.

Thank in advance

Henk Holterma

Delphi Developer

Sun, 16 Jan 2005 17:45:14 GMT

Re:Sort Record after using 'union' command

Lee,

This question isn't specific for IBX. Consider
borland.public.interbase.general in the future.

You can order a UNION by using column numbers, for example:

ORDER BY 3, 1 DESC, 2

-hh-

Quote

"lee" <leebanc...@hotmail.com> wrote in message news:3d477a58_2@dnews...
> Hi guy,

> good day. Anyone of you know how to sort the record after using
'union'
> command ? 'order by' giving me an error message.

> Thank in advance

Other Threads

1. Using DOS 'move' command through TP7

2. Equivalent of C 'Union'

3. sort a union, view of union

4. Q: Sorting a Databound Grid Or Moving Record's

5. Howto sort '+', '-', '*', '/',... with Delphi3

6. Using Dos's copy command.

7. Command line builds of EXE using custom component don't work

8. Sort order using Stored Proc's and filtering

9. Delphi 2.0 - Using TList Object's Sort Method

10. I don't get '...another user has changed the record'(second post)