Post reply

Mark as Deleted. IsDeleted Column. Index Question

  • December 21, 2006 at 8:41 am

    #679456

    Always remember this... between you and the server, only the server has the need to be lazy .

  • December 21, 2006 at 8:42 am

    #679459

    I must keep the data in the same table since I have Offline Distributed Databases and the only way to comunicate (till now) it's via XML files where I send the last changes since last sinchronization using a Datetime column. When the target database reads the package it can only do an Insert or an update, but not a delete. I also cannot send the Delta if I physically delete the row from the live table.

    I agree with you all that the deleted records belong somewhere else and not in the "active" table. But in my current situation I cannot change the main export logic. That's why I tried with the views solution and wanted to make the best out of it.

    The 3 reasons what peterhe mentions in his last post are also valid for me, but my main problem is the import/export functionality.

    Nito

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply