Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
You might want to try a slightly different method.
Create a remote view of the table you want to add data to, using the view designer. Make sure it is updateable.
If you have a local table with the data in it that you want updated, make the field names of this table the same as the field names in the remote view.
Then simply do a an APPEND FROM into the remote view from the local data.
If you need a program, set variable names to the field names in the remote view, populate the values, then do an append blank - gather memvar loop and this will add the data as well.
I've done this many times with great results.
If there are errors, aerror will always give you the error information.
>hi
>
>it changes the variables to, b, c... and add the instruction aerror() but did not give result, aerror, no return error.
>
>:(
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement