| Subject | Re[2]: [IBO] get SQL query to report or export |
|---|---|
| Author | Pascal Amesland |
| Post date | 2001-05-09T17:44:10Z |
Hello Jason,
Tuesday, May 08, 2001, 6:48:26 PM, you wrote:
JW> You can tell the TIB_Export component to clone the source dataset (which may
JW> be buffered) using a unidirectional internal query. It uses the
JW> AssignSQLWithSearch method which is designed to move a lot of the queries
JW> criteria from one dataset to another.
JW> HTH,
JW> Jason Wharton
JW> CPS - Mesa AZ
JW> http://www.ibobjects.com
Thanks for that complete answer, i decided to make an export form so i
can use the AssignSQLWithSearch.
But, i should be interressant having the possibility to use it with
the TIB_ExportDialog. This is not the case for now (or did i missed
something?).
Is it something to add to the wishlist ?:->)
JW> ----- Original Message -----
JW> From: "Pascal Amesland" <p.amesland@...>
JW> To: "IBObjects" <IBObjects@yahoogroups.com>
JW> Sent: Tuesday, May 08, 2001 8:18 AM
JW> Subject: [IBO] get SQL query to report or export
--
Best regards,
Pascal mailto:p.amesland@...
Tuesday, May 08, 2001, 6:48:26 PM, you wrote:
JW> You can tell the TIB_Export component to clone the source dataset (which may
JW> be buffered) using a unidirectional internal query. It uses the
JW> AssignSQLWithSearch method which is designed to move a lot of the queries
JW> criteria from one dataset to another.
JW> HTH,
JW> Jason Wharton
JW> CPS - Mesa AZ
JW> http://www.ibobjects.com
Thanks for that complete answer, i decided to make an export form so i
can use the AssignSQLWithSearch.
But, i should be interressant having the possibility to use it with
the TIB_ExportDialog. This is not the case for now (or did i missed
something?).
Is it something to add to the wishlist ?:->)
JW> ----- Original Message -----
JW> From: "Pascal Amesland" <p.amesland@...>
JW> To: "IBObjects" <IBObjects@yahoogroups.com>
JW> Sent: Tuesday, May 08, 2001 8:18 AM
JW> Subject: [IBO] get SQL query to report or export
>> Hello,JW> where
>>
>> 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
>> selected on a grid by clicking the column header (order byJW> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>> ...,...(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
>>
>>
>>
>>
>>
>> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
--
Best regards,
Pascal mailto:p.amesland@...