>>>>>>No great biggie here.
>>>>>>
>>>>>>I'm replacing a system from its FPD26 days, and the tables still need to be used by the old system. There are cases where there's a 1-m reln. so as I create a certain rec I need to create < = 3 related table recs. I'm afraid of crashes during this process, or during my programmed cascaded delete
>>>>>>
>>>>>>I was wondering if anyone knew of, or has developed a clever way around the fact that you can't use transactions here, as the old tables aren't part of a dbc. The only way I can think of is to keep track of newly created recs and deleting them if, say, a related TableUpdate() fails, or say, using RECALL when part of a cascaded delete fails.
>>>>>>
>>>>>>'ppreciate it
>>>>>>
>>>>>>Terry
>>>>>
>>>>>Terry,
>>>>>If the old system would continue to use them then you already would access via a view, no? There is a dbc IOW.
>>>>>Cetin
>>>>
>>>>Sorry, Cetin, I don't follow you. I don't access the tables as views - just as tables. Non-dbc tables don't support views do they, or am I missing something here.
>>>>
>>>>Whatever, how can I use xactions?
>>>
>>>What I'm saying is simple. Create a dbc and views for tables.
>>>Cetin
>>
>>But if I create a dbc and add these tables to it, won't they then be "tainted" with VFP7 properties, such that the FPD26 appplication will no longer recognise them (being of their future)?
>>
>>Also, because of the legacy of the way the old system works, there's a different folder for each of a series of transport authorities. Each set of tables would have to be assigned to its own dbc, i.e. a new dbc created and populated. Then, there's the problem that certain tables, for certain authorities, do not have the same structure as others, e.g. a key code may be c(2) for one and c(4) for another.
>>
>>It's not the way I designed the system (if I could see the design I'd be spinning in my grave) and I'm stuck with it.
>
>I didn't say add tables. I said create views for the tables. You can create a dbc and its views programmatically on the fly.
>Cetin

Thanks, Cetin. I twigged on after I left work last night. :-) This is a concept I hadn't thought of. I'm not sure it's feasible in this case, for the above reasons, but I'll have a wee experiment to see how it goes.