Information générale
Catégorie:
Codage, syntaxe et commandes
George,
Thanks for the reply.
I do a TableRevert if the new record is blank because I must have something in some of the fields to save it to my tables.
So I should be ok using APPEND BLANK.
>>Did George say why to use Insert-SQL instead of APPEND BLANK?
>>
>John,
>
>Nadya was getting error 1547: "Cannot insert an empty row from a view into its base table(s). While a view is updating, a new empty record (with no modified fields) is being inserted into one of the base tables of the view.
>
>Make sure each record inserted from a view into a base table has at least one field that has been modified in the view prior to the view update."
Précédent
Suivant
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