General information
Category:
Coding, syntax & commands
>Hi,
>
>I want to create copy of some of my tables.
>In a central station I want to combine those tables data into one table.
>
>I use the APPEND FROM command to do that.
>
>Problems:
>1. I get a error message that the table doesn't belong to the database and if I want to delete the link. How do I delete the Back Link programaticly?
>
>2. After I delete the link APPEND FROM doesn't work, the error message states that the table is READ ONLY. How I get around this?
>
>Thanks in Advance,
>
>Gadi Hutt
You have copied a file which belongs to a database. As i recall, you have done this to keep the long field names you are using. (See yoúr older threads.)
What you can do is the following.
At the client side copy the data to a new free table.
At the server side you can create a view for the free table with something like:
select myverylongn as myverylongname1, etc etc
Then you can use append from the view instead of from the original table.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only