Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid object name TableName
Message
De
13/01/2021 13:20:17
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01677801
Message ID:
01677826
Vues:
46
>>>I found the problem! The "wrong" table name was in the Trigger of the SQL Server DB.
>>
>>My first thought when I read your message was about the trigger, but you told you deleted that table? Did SQL Server still allow you to delete it?
>
>I was trying to delete a row, not a table. And I was confused (I am so busy these days, both personal and work that I can't think straight). And I thought that the delete trigger was not part of the procedure. But it turns out, it is. The fix was easy; simply comment the "wrong" table in the trigger code.

As far as I understand, you try to alter (SQL UPDATE, in DBX REPLACE) the value of a field that you use for something like deleted, not delete a column?

There is a way to update a SQL Server that is called Delete and Insert - First delete the old record, then insert a new one with the new values. so this may raise the delete trigger
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform