|
|
| Charlie Lutz 2005-11-17, 8:23 pm |
| I am trying to use the copy option of the update set class to make a copy of some tables (actually a subset of the tables). The copy is working fine, but it is not creating the index files. Is there any way to copy the index (mdx) as well?
Thanks,
Charlie
| |
| Roland Wingerter 2005-11-18, 3:23 am |
| Charlie Lutz wrote
>I am trying to use the copy option of the update set class to make a copy
>of some tables (actually a subset of the tables). The copy is working
>fine, but it is not creating the index files. Is there any way to copy the
>index (mdx) as well?
------
Use the tabledef class to get information about the indexes of the source
table. Then use this information to recreate the indexes in the destination
table.
Roland
| |
| *Lysander* 2005-11-18, 3:23 am |
| In article <3r7Y7gB7FHA.1492@news-server>, ich@hier.de says...
> Charlie Lutz wrote
y=20[color=darkred]
=20[color=darkred]
the=20[color=darkred
]
> ------
> Use the tabledef class to get information about the indexes of the source=
=20
> table. Then use this information to recreate the indexes in the destinati=
on=20
> table.
Or... use the copytables() method of the database, zap the destination=20
table, and then start your update-set action.
--=20
ciao,
Andr=E9
| |
| Roland Wingerter 2005-11-18, 7:23 am |
| "*Lysander*" wrote
>
> Or... use the copytables() method of the database, zap the destination
> table, and then start your update-set action.
-------
That's probably the easiest way, but copyTables() only works within the same
database.
Roland
| |
| Roland Wingerter 2005-11-18, 7:23 am |
| Roland Wingerter wrote
>
> Use the tabledef class to get information about the indexes of the source
> table. Then use this information to recreate the indexes in the
> destination table.
------
Try updateSetEx.cc, which I posted in dbase.shared-code.
Roland
| |
| Ken Mayer [dBVIPS] 2005-11-18, 9:23 am |
| Charlie Lutz wrote:
> I am trying to use the copy option of the update set class to make a copy of some tables (actually a subset of the tables). The copy is working fine, but it is not creating the index files. Is there any way to copy the index (mdx) as well?
Why not just use COPY TABLE or database.copyTable()?
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Roland Wingerter 2005-11-18, 8:23 pm |
| Ken Mayer [dBVIPS] wrote
>
> Why not just use COPY TABLE or database.copyTable()?
------
From what I understand Charlie does not want to copy complete tables.
Roland
| |
| Charlie Lutz 2005-11-21, 9:23 am |
| In article <c6ZgqiE7FHA.1492@news-server>, dbase@_nospam_golden
stag.net
says...
> Charlie Lutz wrote:
>
> Why not just use COPY TABLE or database.copyTable()?
>
Can I use that to ONLY copy part of the table? For example: copy table
for field 1 = true.
Charlie
--
____________________
________
Charlie Lutz
#1000441
| |
| Charlie Lutz 2005-11-21, 9:23 am |
| In article <fmR$pa76FHA.1232@news-server>, lutz@*wes.army.mil says...
> I am trying to use the copy option of the update set class to make a copy of some tables (actually a subset of the tables). The copy is working fine, but it is not creating the index files. Is there any way to copy the index (mdx) as well?
>
>
> Thanks,
> Charlie
Thanks for the suggestions, I will dig into them.
Charlie
--
____________________
________
Charlie Lutz
#1000441
| |
| Ken Mayer [dBVIPS] 2005-11-21, 9:23 am |
| Charlie Lutz wrote:
> In article <c6ZgqiE7FHA.1492@news-server>, dbase@_nospam_golden
stag.net
> says...
>
>
> Can I use that to ONLY copy part of the table? For example: copy table
> for field 1 = true.
No, sorry. I didn't see that you needed that capability.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
| |
| Charlie Lutz 2005-11-22, 7:23 am |
| In article <nhKTALq7FHA.1228@news-server>, dbase@_nospam_golden
stag.net
says...[color=darkred]
> Charlie Lutz wrote:
I didn't think I could, but there are so many pieces of dB that I either
don't know or have forgotten I know, that I wanted to make sure <g>.
Thanks,
Charlie
--
____________________
________
Charlie Lutz
#1000441
|
|
|
|