Information générale
Catégorie:
Codage, syntaxe et commandes
>>Jim:
>>AERROR() shows Error 1547, "Cannot insert an empty row from a view into its base table". When I look up error 1547, it states that you cannot insert a blank record into a table. There is only one new row in the view, and it has something in it, so its not blank. I'm still stumped.
>>
>>Ed
>
>Ed,
>
>I just notice d anothr syntax error in the sample code, you have END TRANSACTION as one word instead of two. Try fixing that and see if the same thing is happening.
Right now I'm just trying get the base table to update, so I am typing the following at the command line:
OPEN DATABASE Data
SELECT 0
USE TableA
SELECT 0
USE Data!ViewA
CURSORSETPROP("buffering", 5, "ViewA")
SELECT ViewA
INSERT INTO ViewA(Dnis) VALUES("Test")
TABLEUPDATE(2,.T., "ViewA")
record is in view, but not in base table. TABLEUPDATE() returns F, AERROR() shows Error 1547, "Cannot insert an empty row from a view into its base table".
Ed
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