[ic] Replacing SQL Databases

Stefan Hornburg Racke interchange-users@interchange.redhat.com
Wed Apr 10 10:56:01 2002


cfm@maine.com writes:

> On Wed, Apr 10, 2002 at 03:45:54PM +0200, Stefan Hornburg (Racke) wrote:
> > 
> > Hello, Interchange users !
> > 
> > A customer of our company would like to upload a new databases where
> > many rows are deleted. This is no problem with text databases, you
> > just drop the new file and reconfig.
> > 
> > This don't work for SQL databases, only new records are added, but
> > the old ones with no counterpart in the upload stay there. Is there
> > a Interchange way instead of using SQL statements to achieve
> > database updates with deleting records ?
> 
> What do you mean by "don't work for SQL databases"?
> 
> We typically do everything we can to get clients to think of
> replacing their data (we only use SQL) in its entirety, otherwise
> it will surely "diverge" from what the customer thinks he has and
> trying to maintain consistency through web forms is hopeless.

I tried to upload and import the database in question, hit "Apply Changes",
but the old records didn't vanish. It is a foundation-based catalog.

Ciao
        Racke

-- 
Think of it !

For projects and other business stuff please refer to COBOLT NetServices
(URL: http://www.cobolt.net; Email: info@cobolt.net; Phone: 0041-1-3884400)