Information générale
Catégorie:
Codage, syntaxe et commandes
> I am inserting into SQL Server via a remote view.
>
> I am issuing TABLEUPDATEC) after every action but it keeps returning ".F."
>
> The record is inserted and it seems to be fine in SQLServer but the unique numeric key "ID" field that is automatically inserted by the SQLServer is always showing up in my view as "0" (when I BROWS
> until I close the view and open it again then that field displays the coerrect numbers.
>
> I feel that I have to "refresh the view" somehow to get a ".T." from TABLEUBDATE(.T.,.T.)
>
> Any clues folks, if you need more details let me know.
Are you also using transactions in addition to buffering? Do you have
any trigger code in the remote table? What buffering scheme are you
using?
FYI, I assume you are using the identity clause in SQL server to
generate your unique numbers, you can query this by SELECT
@@Identity.
Scot.
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