VFP 6 Replicating a table 4

[eric43]

I have a table with many records - I wish to create an empty temporary table with the same structure with no records.

This will be needed to work whether the new table is in use and hasn't been closed or not.

Is this possible?

Thanks

Eric

 

[Mike Lewis]

Eric,

Here's one possibility:

SELECT * FROM MyTable INTO TABLE NewTable WHERE .F.

Or, change TABLE to CURSOR in the above. That way, the new table will be truly temporary, and will disappear after you close it.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[alvechurchdata]

All I'd add is that the new table will appear in your default folder unless you specify a path. You might find you've created a new table in C:\PROGRAM FILES\MICROSOFT VISUAL FOXPRO 9\ and that's not a good idea.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[mkrausnick]

There's actually a VFP command that does what you want, much faster than SELECT on a large table:

COPY STRUCTURE TO (lcTempFileName)

You can write code to test if the source file is already open and open it if not, then make it the currently selected file and issue the COPY STRUCTURE. You can specify the full path in lcTempFileName. The cloned file is not opened afterwards, so you have to USE it.


Mike Krausnick
Dublin, California

 

[eric43]

Hmm - thanks Mike - I now seem to remember this from Clipper days too.

Eric

 

[Stella740pl]

And you can also

COPY TO NewTable FOR .F. WITH CDX

which is very handy if you have a lot of tags and want to replicate all of them, too.