Stephen...
Check the SendUpdates flag on the remote view. Believe it or not, if it
is set to False, Tableupdate will still return a True even though the
data did not actually get sent to SQL.
Barry Childs
Programmer Analyst, Sr.
Select Portfolio Servicing, Inc.
Phone: (801) 293-2569
eMail: barry.childs At selectservicing .D.O.T com
-----Original Message-----
From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces At leafe .D.O.T com]
On Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI
Sent: Friday, July 30, 2004 8:13 AM
To: profoxtech@leafe.com
Subject: VFP8: TABLEUPDATE()
I'm doing a tableupdate(0,.t.) (after an insert) on a remote view that
is a product of a MSSQL2K table.
llSuccess=tableupdate(0,.t.)
llSuccess is true after executing the above line, I set it to .F. before
executing the line.
However, when I do a subsequent requery(), the newly inserted record
doesn't appear. If the tableupdate was true then why doesn't the record
come across?
v/r
Stephen S. Wolfe, GS-11, DAFC
Data Services Manager
stephen.wolfe At macdill .D.O.T af.mil
(813) 827-9972 DSN 651-9972
[excessive quoting removed by server]
©2004 Barry Childs |
