Well, I haven't really begun with any particular SQL software yet. Just thinking about things. Maybe it is too soon to think of such things ?




>>As someone new to SQL some aspects of the concept seem troubling to me. For example, it appears that data is pulled from the database in small portions and then through the use of some form. During this process, all sorts of transactions may be occuring with the database which are unknown to that processing on the local data.
>>
>>If that processing is reporting, fine, no problem. However, what if someone brings in some data to edit and before they have a chance to put it back, someone deletes the record they pulled in to edit ? There appears to be no way (at least no inherent) to mark that data so that no-one will be able to delete it while it is out being edited.
>>
>>Oh, I suppose you could put a field in every file called BEING_EDITED and set this flag before bringing the data to your local site. Of course, this leaves the system open for problems if the user that set the flag never gets back to the database on the server.
>>
>>Is this how you do it or do you just throw the edited record away (not likely) if it no longer exists when they try to write it back to the data.
>>
>>Any thoughts on these types of things ?
>
>Don,
>
>Are you using SQL Server data or VFP data?