Re: Newbie Help Plz

the database designer put in a constraint to prevent the delete -- so what you're seeing is what should happen if you try to delete a record that is referenced by other records

this should tell you that a) the designer goofed and should have used the ON DELETE CASCADE clause when setting up the FOREIGN KEY constraint, so that dependent records would be automatically deleted, or b) the designer got it right and you shouldn't be deleting this record until you first determine what the dependent records are and what to do with them

• mcs

"Mumblez" <mumblez2002_at_btinternet.com> wrote in message news:bo5n4c$f3e$1_at_hercules.btinternet.com...
> thank you however getting integrity constraint violated - child record
> found
>
> how do i solve this
>
>
>
>
> "mcstock" <mcstockx_at_xenquery.com> wrote in message
> news:QfCdncUIQ5gAJDiiRVn-sg_at_comcast.com...
> > you're looking for the DELETE command with WHERE clause that selects
> records
> > based on the expiration date column compared to SYSDATE (the current
> system
> > date on the database server)
> >
> > (you really need to study the basics of sql before posting questions
like
> > this, though)
> >
> > "Mumblez" <mumblez2002_at_btinternet.com> wrote in message
> > news:bo4c9k$hji$1_at_sparta.btinternet.com...
> > > could someone please tell me how to remove a record that is past the
> > present
> > > date?
> > >
> > > for example if you have users that have an expiry date what sql
command
> do
> > > you use to check the date and then remove that record
> > >
> > > thanks in advance
> > >
> > >
> >
> >
>
>
Received on Tue Nov 04 2003 - 14:19:35 CST