Copy a Table

[Wayne Wengert]

When a specific event occurs I want to make backup copies of 2 tables using
names like "BkupTbla081204 .xml" and "BkupTblb081204 .xml". What is the best
way to do this? I suspect there is some simple method that I have
overlooked.

Wayne

[Cor Ligthert]

Wayne,

When a specific event occurs I want to make backup copies of 2 tables using names like "BkupTbla081204 .xml" and "BkupTblb081204 .xml". What is the best
way to do this? I suspect there is some simple method that I have
overlooked.

Wayne

What do you want to know how to make the name or how to write the table,
however a complete solution?

dim myfilename as string = "BkupTbla" & Now.tostring(MM ddyy) & ".xml"
myds.writeXML(m yfilename)
myfilename = "BkupTblb" & Now.tostring(MM ddyy) & ".xml"
myds.writeXML(m yfilename)

Because of the current date and your sample I think you want the US date
notation and I have made it in that, for most other countries you have to
change the dd and the MM in the sample. (This is for when someone search on
this sample).

I hope this helps?

Cor

[Wayne Wengert]

Cor;

Thanks for the response. The solution you offered creates a backup table
from the open dataset. I am looking for a way to make a copy of a table when
the contents of that table are not open in a dataset. I guess I could read
the table into a dataset and then write that out to a new table but I was
looking for some sort of simple table copy process?

Wayne

"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:Ol******** ******@TK2MSFTN GP09.phx.gbl...

Wayne,

When a specific event occurs I want to make backup copies of 2 tables using

names like "BkupTbla081204 .xml" and "BkupTblb081204 .xml". What is the best way to do this? I suspect there is some simple method that I have
overlooked.

Wayne

What do you want to know how to make the name or how to write the table,
however a complete solution?

dim myfilename as string = "BkupTbla" & Now.tostring(MM ddyy) & ".xml"
myds.writeXML(m yfilename)
myfilename = "BkupTblb" & Now.tostring(MM ddyy) & ".xml"
myds.writeXML(m yfilename)

Because of the current date and your sample I think you want the US date
notation and I have made it in that, for most other countries you have to
change the dd and the MM in the sample. (This is for when someone search

on this sample).

I hope this helps?

Cor

[Cor Ligthert]

Wayne,

The same simplicity I assume you have an existing one you want to protect, a
good idea with a XML file. All typed in message so watch typos.

\\\
Dim myfilenameB as string = "BkupTblb" & Now.tostring(MM ddyy) & ".xml"
dim myfilenameA as string = "BkupTbla" & Now.tostring(MM ddyy) & ".xml"

if file.exist(myfi lenameB) then
File.delete(myf ilenameB)
end if
file.move(myfil enameA, myfilenameB)
file.copy(myori ginal, myfilenameA)
///
In this the B is deleted,it is up to you if you want that or to do something
else with it.

I hope this helps?.

Cor

[Wayne Wengert]

Thanks again Cor;

I'll adapt that to my situation

Wayne
"Cor Ligthert" <no**********@p lanet.nl> wrote in message
news:u1******** ******@TK2MSFTN GP12.phx.gbl...

Wayne,

The same simplicity I assume you have an existing one you want to protect, a good idea with a XML file. All typed in message so watch typos.

\\\
Dim myfilenameB as string = "BkupTblb" & Now.tostring(MM ddyy) & ".xml"
dim myfilenameA as string = "BkupTbla" & Now.tostring(MM ddyy) & ".xml"

if file.exist(myfi lenameB) then
File.delete(myf ilenameB)
end if
file.move(myfil enameA, myfilenameB)
file.copy(myori ginal, myfilenameA)
///
In this the B is deleted,it is up to you if you want that or to do something else with it.

I hope this helps?.

Cor