Hectar
As I understand it, if you issue a COPY TO and include the DATABASE clause then your new table will be part ot=f the database and enjoy the privileges thereof, e.g. long field names, RI etc.
HTH
Terry
>Hi, does anyone knows how can i save a view into a table. Because when i want to save my online view the name of the fields are truncated. The remote database is oracle and I want to have a physical dbf for each view. I know there's a field name limit in a standalone dbf, but is there a way of doing this inside a fox database?
>
>Thanks in advance
>Hector L.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.