Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Deleting Records on ADS/CDX

2 posts in FoxPro Last posting was on 2005-07-06 20:14:55.0Z
Osvaldo L Aoki Posted on 2005-07-04 20:26:46.0Z
Reply-To: "Osvaldo L Aoki" <osvaldo@aoki-sis.com.br>
From: "Osvaldo L Aoki" <osvaldo@aoki-sis.com.br>
Newsgroups: advantage.foxpro
Subject: Deleting Records on ADS/CDX
Date: Mon, 4 Jul 2005 17:26:46 -0300
Lines: 18
Organization: AOKI Sistemas
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 200.153.218.53
Message-ID: <42c99d0f@solutions.advantagedatabase.com>
X-Trace: 4 Jul 2005 14:33:19 -0700, 200.153.218.53
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!200.153.218.53
Xref: solutions.advantagedatabase.com Advantage.FoxPro:199
Article PK: 1109554

HI,
I have a question about deleting records on ADS/CDX,
when I am scanning for many records for deleting,
do I have to SKip() to next records, or when I delete
one, ADS skip to next record automatically....

do while cl_cod == wcl_cod .and. !eof()
if rlock()
Delete
endif
dbSkip()
enddo

I think that ADS is skiping to next records after deleting current record.
Is that Correct ?
Is there anyway to avoid it ?


Alex Wong (ADS) Posted on 2005-07-06 20:14:55.0Z
From: "Alex Wong \(ADS\)" <alexw@extendsys.com>
Newsgroups: advantage.foxpro
References: <42c99d0f@solutions.advantagedatabase.com>
Subject: Re: Deleting Records on ADS/CDX
Date: Wed, 6 Jul 2005 14:14:55 -0600
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 198.102.102.7
Message-ID: <42cc3c86@solutions.advantagedatabase.com>
X-Trace: 6 Jul 2005 14:18:14 -0700, 198.102.102.7
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.7
Xref: solutions.advantagedatabase.com Advantage.FoxPro:200
Article PK: 1109553

Hi Osvaldo,

Are you using Clipper to access the database? Which version of the ADS are
you using? You should post this to the Advantage.Clipper NG.

I am not a Clipper expert, but if the show delete is off, this may be the
expected behavior.

Alex

"Osvaldo L Aoki" <osvaldo@aoki-sis.com.br> wrote in message
news:42c99d0f@solutions.advantagedatabase.com...
> HI,
> I have a question about deleting records on ADS/CDX,
> when I am scanning for many records for deleting,
> do I have to SKip() to next records, or when I delete
> one, ADS skip to next record automatically....
>
> do while cl_cod == wcl_cod .and. !eof()
> if rlock()
> Delete
> endif
> dbSkip()
> enddo
>
> I think that ADS is skiping to next records after deleting current record.
> Is that Correct ?
> Is there anyway to avoid it ?
>
>