Re: SQL enigma

nseekhim_at_yahoo.com (Shangrila) wrote in message news:<c3718cf9.0304010952.6861ba0_at_posting.google.com>...
> Hi,
> We have stored data in SQL server. Recently we noticed that there are
> hundreds on junk clients which needs to be deleted. The problem with
> these junk clients is that they have certain number of loans attached
> with them. We haven't figured out how to delete it cause each time we
> try a message pops up saying that "Delete statement conflicted with
> the column reference- as a result the statement has been terminated"
>
> We'd appreciate if somebody please show us a way to detele these junk
> usres.
>
> Message anxiously looked forward.
> Thanx & have a nice day.
> We

I realize this is April Fools Day, but what the heck. First of all, are you using Oracle? SQL Server usually refers to a Microsoft product.

Second, this is an obsolete newsgroup. If you are asking about Oracle, you probably want a group underneath it like comp.databases.oracle.misc . If you are asking about SQL Server, go away.

If you are asking about Oracle, be sure and post the version and platform your Oracle is running on, as well as any client software accessing it.

You seem to have run into "referential integrity," which is a fancy term for saying, hey, if there is a loan out there, you can't delete the client that received it. Or something like that. You need to either remove such constraints (not generally a good idea, as they prevent other junk data _that you might not know about_ from accumulating), or remove the treed data leaf first.

You should go see your database administrator. If you don't have one, you should get one.

jg

--
_at_home.com is bogus.
Evil bits are invading your network! 
http://catless.ncl.ac.uk/Risks/22.66.html