TBatchMove / Creating a databse table at runtime? 
Author Message
 TBatchMove / Creating a databse table at runtime?

: I am building a generic window that allows users to export database
: tables to a ASCII file or a Paradox/dBASE table. The user has the ability
: to set which fields are exported and what order they are in. This is easy
: enough to do for ASCII files, but I am having problems with the
: Paradox/dBASE formats

: It is simple to use the TBatchMove component to move the data from the
: source table to the destination table, but I can't restrict the fields
: that are exported or the order in which they are exported. Given that you
: can apply a filter to the source TTable to reduce the rows that get
: moved, I assumed that I could "hide" fields from the TBatchMove
: component. I tried to set the following properties and  they were ignored
: during the batch transfer:

:                  tblSource.FieldByName('FirstName').Visible:= False;
:                  tblSource.FieldByName('FirstName').Index:= 3;

: Am I missing something? If this can't be done using the TBatchMove
: component I guess that I will have to create a table on the fly (I have
: no idea how to do this). Does anyone have any ideas?

:       Thanks
:       -Scott

: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: |  \ /  Scott Swartz         |                                          
: |  >i<  Net*Centric          | Rules are to be taken literally by fools

: |       (617) 868-8600 x138  |                                          
: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Scott if I'm correct you can use a BatchMove on a Query as well as a
table, why not use a query with only the columns you want (in the order
youw and) and base the BatchMove on the Query instead of the table?

--
 _____________________________________________________________________________

|There are two major products that came out of Berkeley: LSD and UNIX.  We    |
|don't believe this to be a coincidence. -- Jeremy S. Anderson                |



Sun, 31 May 1998 03:00:00 GMT  
 TBatchMove / Creating a databse table at runtime?
I am building a generic window that allows users to export database
tables to a ASCII file or a Paradox/dBASE table. The user has the ability
to set which fields are exported and what order they are in. This is easy
enough to do for ASCII files, but I am having problems with the
Paradox/dBASE formats

It is simple to use the TBatchMove component to move the data from the
source table to the destination table, but I can't restrict the fields
that are exported or the order in which they are exported. Given that you
can apply a filter to the source TTable to reduce the rows that get
moved, I assumed that I could "hide" fields from the TBatchMove
component. I tried to set the following properties and  they were ignored
during the batch transfer:

                 tblSource.FieldByName('FirstName').Visible:= False;
                 tblSource.FieldByName('FirstName').Index:= 3;

Am I missing something? If this can't be done using the TBatchMove
component I guess that I will have to create a table on the fly (I have
no idea how to do this). Does anyone have any ideas?

        Thanks
        -Scott

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|  \ /  Scott Swartz         |                                          
|  >i<  Net*Centric          | Rules are to be taken literally by fools

|       (617) 868-8600 x138  |                                          
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



Sun, 31 May 1998 03:00:00 GMT  
 TBatchMove / Creating a databse table at runtime?

Quote:


>Subject: TBatchMove / Creating a databse table at runtime?
>Date: 13 Dec 1995 13:20:33 GMT
>I am building a generic window that allows users to export database
>tables to a ASCII file or a Paradox/dBASE table. The user has the ability
>to set which fields are exported and what order they are in. This is easy
>enough to do for ASCII files, but I am having problems with the
>Paradox/dBASE formats
>It is simple to use the TBatchMove component to move the data from the
>source table to the destination table, but I can't restrict the fields
>that are exported or the order in which they are exported. Given that you
>can apply a filter to the source TTable to reduce the rows that get
>moved, I assumed that I could "hide" fields from the TBatchMove
>component. I tried to set the following properties and  they were ignored
>during the batch transfer:
>                 tblSource.FieldByName('FirstName').Visible:= False;
>                 tblSource.FieldByName('FirstName').Index:= 3;
>Am I missing something? If this can't be done using the TBatchMove
>component I guess that I will have to create a table on the fly (I have
>no idea how to do this). Does anyone have any ideas?

Maybe I'm being slow, bot wot about the Mapping property of the tbatchmove.
Seems it may do wot you need

Boris Ingram, Cyborg Software

http://www.pcb.co.za/users/borising/cyborg.htm



Fri, 05 Jun 1998 03:00:00 GMT  
 TBatchMove / Creating a databse table at runtime?
Quote:
>> I tried to set the following properties and they were ignored

during the batch transfer: <<

Try using the Mapping property of TBatchmove.



Sun, 07 Jun 1998 03:00:00 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. Creating a Temp Table with TBatchMove (MSSQL 6.0)

2. creating secondary index in paradox table at runtime??

3. Newbie Question - Creating Access Table at Runtime

4. How to create Access table at runtime

5. Help: Creating indexes on tables at runtime

6. Help: Creating Tables at runtime.

7. Create a Paradox Table at Runtime Please Help

8. Creating Specific Paradox Version Tables at Runtime

9. D2: Creating Data Tables at Runtime

10. Creating Tables/Stored Procs at runtime

11. Create Pdx table with password at runtime ????

12. Create Pdx table at runtime

 

 
Powered by phpBB® Forum Software