Malibucompany
asked on
Copying Tables in Fox 9
I have a table-table a I copy it to table b. I look at table b and the names of some of the fields have been altered. a filed called AVERAGEPRICES1 gets copied as AVERAGEPR1. I tried the copy command and the copy structure command. Same thing anyone run into this?
D
D
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works great thank you
Hi pcelba,
Okay, then I also learned something: COPY TO accepts database path. But I'm very sure USEing a dbf of a dbc does open the dbc, it's just not getting the active DBC, therefore MODIFY DATABASE fails.
CLOSE DATABASES ALL
?ADATABASES(laDBCs) && 0
USE seomdbf && dbf of a dbc
?ADATABASES(laDBCs) && 1
MODIFY DATABASE alone will still prompt with a file open dialog, because the database is not set active. DBC() does also still remain empty for the same reason. But simply use the database combobox in the standard toolbar of the VFP IDE and you'll see.
Bye, Olaf.
Okay, then I also learned something: COPY TO accepts database path. But I'm very sure USEing a dbf of a dbc does open the dbc, it's just not getting the active DBC, therefore MODIFY DATABASE fails.
CLOSE DATABASES ALL
?ADATABASES(laDBCs) && 0
USE seomdbf && dbf of a dbc
?ADATABASES(laDBCs) && 1
MODIFY DATABASE alone will still prompt with a file open dialog, because the database is not set active. DBC() does also still remain empty for the same reason. But simply use the database combobox in the standard toolbar of the VFP IDE and you'll see.
Bye, Olaf.
Yes, you are right. The database is open but not active. I just forgot we have SET DATABASE command... (and I've never used the combo).
Thanks
Thanks
ASKER
How would u use that command I cant get it to work keep getting errors
database name is databasea
table name is tablea
copy to tableb
Is is such an intricate program to fully learn it would take years it would seem I appreciate your help. The books I have are all from FOX 6 and there always seems to be little pieces here and there that they leave out
Thank You
D