Are you asking whether the VFP View is available on another machine, or whether the SQL Server table is visible? If the View is part of a dbc database then the answer *may* be yes, on the SQL table I'm 99% sure its no. If, for whatever reason you don't want to complete the transaction then surely you issue a rollback?
(... if this is for getting FK for child records then +1 for using a stored proc)
On 01/03/2016 21:54, Chris Davis wrote:
Hi All
If I start a SQL transaction and append records via a VFP View, issue a table update but don't COMMIT the transaction are these records available from another machine? If they are how could I know that they have been appended in a transaction that may well end up getting rolled back?
Thanks
Chris.
<snip>