Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi all,
>
>I have a problem with remote views (table buffering):
>i'm trying to do a TABLEUPDATE(.t., .t.) on a remote view that has all fields updatable (even primary). SQL Server gives me an error saying that i can't insert data because my primary field is null. And, if i make a BROWSE before the TABLEUPDATE, that field has data.
>
>Any ideas?
>
>Ricardo
I have had this problem but it has been a while. So, to the best of my memory, check to see if your primary key is being duplicated and also look at your data types. It seems that I had a data typing issue (in my case it was not allowing nulls and I was trying to move a fox date to a sybase date, which are definately different). Look at the docs for tableupdate and use do an update from the command window using cerrorarray to determine which field is actually causing the error. It's been a while since I have run into this and I hope this helps.
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