Subject | get SQL query to report or export |
---|---|
Author | Pascal Amesland |
Post date | 2001-05-08T15:18:17Z |
Hello,
Is there a mean to get a SQL query text from a TIB_query, to assign it
to a cursor or an other query, with the sort fields (asc or desc) that where
selected on a grid by clicking the column header (order by
...,...(asc or desc))?
The goal is : exporting data or printing data, with the same datas
in the same order that the TIB_grid a user is looking at
(excuse for my bad language, if you don't understand what i wrote,
ask me ).
--
Best regards,
Pascal Amesland - PA Soft
p.amesland@...
______________________________________
____ ___ _____ ______
/ __ \/ | / ___/____ / __/ /_
/ /_/ / /| | \__ \/ __ \/ /_/ __/
/ ____/ ___ | ___/ / /_/ / __/ /_
/_/ /_/ |_| /____/\____/_/ \__/
______________________________________
Tel: 03 89 60 52 21
Fax: 03 89 43 78 99
35 rue sainte Therese
68200 MULHOUSE
FRANCE
Is there a mean to get a SQL query text from a TIB_query, to assign it
to a cursor or an other query, with the sort fields (asc or desc) that where
selected on a grid by clicking the column header (order by
...,...(asc or desc))?
The goal is : exporting data or printing data, with the same datas
in the same order that the TIB_grid a user is looking at
(excuse for my bad language, if you don't understand what i wrote,
ask me ).
--
Best regards,
Pascal Amesland - PA Soft
p.amesland@...
______________________________________
____ ___ _____ ______
/ __ \/ | / ___/____ / __/ /_
/ /_/ / /| | \__ \/ __ \/ /_/ __/
/ ____/ ___ | ___/ / /_/ / __/ /_
/_/ /_/ |_| /____/\____/_/ \__/
______________________________________
Tel: 03 89 60 52 21
Fax: 03 89 43 78 99
35 rue sainte Therese
68200 MULHOUSE
FRANCE