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.

SQL Filter on Deleted Records

2 posts in FoxPro Last posting was on 2008-12-11 15:09:06.0Z
Tom Hahn Posted on 2008-12-11 14:59:24.0Z
From: "Tom Hahn" <thahn@hahntech.com>
Newsgroups: Advantage.FoxPro
Subject: SQL Filter on Deleted Records
Date: Thu, 11 Dec 2008 09:59:24 -0500
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 69.249.207.195
Message-ID: <4941294f@solutions.advantagedatabase.com>
X-Trace: 11 Dec 2008 07:53:03 -0700, 69.249.207.195
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!69.249.207.195
Xref: solutions.advantagedatabase.com Advantage.FoxPro:286
Article PK: 1109639

Is there a way in SQL to filter out deleted records in DBF tables? In other
words, eliminate deleted records without using TADSSetting which seems to be
giving me a problem in an environment where both Advantage and FoxPro are
accessing tables.


Edgar Sherman Posted on 2008-12-11 15:09:06.0Z
Date: Thu, 11 Dec 2008 08:09:06 -0700
From: Edgar Sherman <no@email.com>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
Newsgroups: Advantage.FoxPro
Subject: Re: SQL Filter on Deleted Records
References: <4941294f@solutions.advantagedatabase.com>
In-Reply-To: <4941294f@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <49412b80@solutions.advantagedatabase.com>
X-Trace: 11 Dec 2008 08:02:24 -0700, 10.24.34.164
Lines: 19
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.FoxPro:287
Article PK: 1109643

No there is not any way in SQL. This is set by the "show deleted" flag.

Since you mentioned TAdsSettings I am guessing you are using Delphi.
This settings object should work just fine and if you are having trouble
there may be something else in the settings component causing it.

An alternative would be to add ACE to the USES clause and call
ACE.AdsShowDeleted(false). Also, remember this is a global setting
affecting the entire application.

Edgar

Tom Hahn wrote:
> Is there a way in SQL to filter out deleted records in DBF tables? In other
> words, eliminate deleted records without using TADSSetting which seems to be
> giving me a problem in an environment where both Advantage and FoxPro are
> accessing tables.
>
>