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>
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
