So - if it's a data session DBF - all the referential integrity is managed by the DS, right?
Does it error out on the server file?
Does the DS have all the info it needs to accomodate the local dtat set.
The last resort would be to copy the DBF's out of the DS - clean them up - and then move them into a fresh clean DS. IE - have one DS for the Server - one for local.
Look at the DBF's when outside the DS if you can - compare them -s= somehour to the DS's DBFs.
I thought I talked you out of the DS years ago - back when we called you Natalie!:-)
T
>>>I got it again even with SET EXCLUSIVE OFF on replace mNotes with m.lcString in Load_Trans command.
>>>
>>>I'll get new copy of data and will resume my tests.
>>
>>Naomi - I had that a long time ago - I forget what I did, but, try this,
>>
>>1) open your DBF
>>2) delete all the tags (delete tag (mytagname))
>>3) SORT on the primary or most used look up field or fields to a temp dbf (set dele on so deleted records will be ignored) - make your physical order your primary order.
>>4) ZAP your "permant" DBF
>>5) APpend your tmp dbf to it
>>6) index each tag
>>
>>Is it a local DBF - or on a server someplace?
>
>I'm testing locally.
Imagination is more important than knowledge