|
 |
access_asp thread: Deleting Data - Information deleted but record remains
Message #1 by "Stephen Proctor" <steveproctor@c...> on Sat, 12 Jan 2002 16:44:43
|
|
I am having a problem with ASP using Access database. The program I have
deletes all the records having a certain date. The information and the
records that have that date are deleted. However, on occasion (maybe one
in 20 records), the information is deleted but the record remains. I can
see this when displaying the record in XML and when I look at the table
displaying the date (the border extends past the bottom of the table). I
am puzzled by this.
Is this a null record? If so, is there a SQL command to delete a null
record?
Thanks for help.
Steve
Message #2 by "Steffen Wogensen Jaques" <webmaster@w...> on Sun, 13 Jan 2002 00:25:20 +0100
|
|
Hey Steve,
What is the command you are using to delete ?
Kind regards,
SWJ.
----- Original Message -----
From: "Stephen Proctor" <steveproctor@c...>
To: "Access ASP" <access_asp@p...>
Sent: Saturday, January 12, 2002 4:44 PM
Subject: [access_asp] Deleting Data - Information deleted but record remains
> I am having a problem with ASP using Access database. The program I have
> deletes all the records having a certain date. The information and the
> records that have that date are deleted. However, on occasion (maybe one
> in 20 records), the information is deleted but the record remains. I can
> see this when displaying the record in XML and when I look at the table
> displaying the date (the border extends past the bottom of the table). I
> am puzzled by this.
>
> Is this a null record? If so, is there a SQL command to delete a null
> record?
>
> Thanks for help.
>
> Steve
$subst('Email.Unsub').
Message #3 by "Stephen Proctor" <steveproctor@c...> on Sun, 13 Jan 2002 04:56:56
|
|
Thanks for the response.
The SQL command is: objCommand.CommandText = "DELETE * FROM RMChecks
WHERE Date = #" & strDateForDeletedChecks & "#"
> Hey Steve,
>
> What is the command you are using to delete ?
>
> Kind regards,
>
> SWJ.
>
> ----- Original Message -----
> From: "Stephen Proctor" <steveproctor@c...>
> To: "Access ASP" <access_asp@p...>
> Sent: Saturday, January 12, 2002 4:44 PM
> Subject: [access_asp] Deleting Data - Information deleted but record
remains
>
>
> > I am having a problem with ASP using Access database. The program I
have
> > deletes all the records having a certain date. The information and the
> > records that have that date are deleted. However, on occasion (maybe
one
> > in 20 records), the information is deleted but the record remains. I
can
> > see this when displaying the record in XML and when I look at the table
> > displaying the date (the border extends past the bottom of the
table). I
> > am puzzled by this.
> >
> > Is this a null record? If so, is there a SQL command to delete a null
> > record?
> >
> > Thanks for help.
> >
> > Steve
> $subst('Email.Unsub').
>
>
Message #4 by "Steffen Wogensen Jaques" <webmaster@w...> on Sun, 13 Jan 2002 06:24:01 +0100
|
|
And your saying that it leaves some empty rows in there ? -- Don't they even
have an ID number?
If they don't, I have NO idea how to remove em
Kind Regards,
happycow-
----- Original Message -----
From: "Stephen Proctor" <steveproctor@c...>
To: "Access ASP" <access_asp@p...>
Sent: Sunday, January 13, 2002 4:56 AM
Subject: [access_asp] Re: Deleting Data - Information deleted but record
remains
> Thanks for the response.
>
> The SQL command is: objCommand.CommandText = "DELETE * FROM RMChecks
> WHERE Date = #" & strDateForDeletedChecks & "#"
>
> > Hey Steve,
> >
> > What is the command you are using to delete ?
> >
> > Kind regards,
> >
> > SWJ.
> >
> > ----- Original Message -----
> > From: "Stephen Proctor" <steveproctor@c...>
> > To: "Access ASP" <access_asp@p...>
> > Sent: Saturday, January 12, 2002 4:44 PM
> > Subject: [access_asp] Deleting Data - Information deleted but record
> remains
> >
> >
> > > I am having a problem with ASP using Access database. The program I
> have
> > > deletes all the records having a certain date. The information and
the
> > > records that have that date are deleted. However, on occasion (maybe
> one
> > > in 20 records), the information is deleted but the record remains. I
> can
> > > see this when displaying the record in XML and when I look at the
table
> > > displaying the date (the border extends past the bottom of the
> table). I
> > > am puzzled by this.
> > >
> > > Is this a null record? If so, is there a SQL command to delete a null
> > > record?
> > >
> > > Thanks for help.
> > >
> > > Steve
> > $subst('Email.Unsub').
> >
> >
>
$subst('Email.Unsub').
|
|
|
View Cart
