> >
> >
> > Tai,
> >
> > you could try:
> >
> >

> > select * from myTable into cursor curtemp where recno()<4
> > select temp copy to c:\temp\curtemp.dbf
> > use c:\temp\curtemp.dbf
> > browse && for you to see no confidential data in curtemp.dbf before you mail it
> > 

> >
> > also mail yourreport.frx
> >
> > Regards,
> >
> > Koen
>
> ---------------------------------------------------------------------
> ---------------------------------------------------------------------
>
> Can I just do "copy to c:\temp\curtemp.dbf"? I got an error "command is missing required clause" when I ran "select temp copy to c:\temp\curtemp.dbf". I want to make sure not to corrupt the database or tables.
>
> Tai Nguyen
sorry slight mistake,

 select * from myTable into cursor curtemp where recno()<4
select curtemp copy to c:\temp\curtemp.dbf
 use c:\temp\curtemp.dbf
 browse && for you to see no confidential data in curtemp.dbf before you mail it
 

also mail yourreport.frx

no problem, you are using a cursor, an not the actual table.\<br />
Regards,

Koen