Re: Newbie Help Plz

From: Mumblez <mumblez2002_at_btinternet.com>
Date: Mon, 3 Nov 2003 14:01:49 +0000 (UTC)
Message-ID: <bo5n4c$f3e$1@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 Mon Nov 03 2003 - 08:01:49 CST