I'm executing a query on a table which has some deleted records. Navigating with ARC I'm able to see them on red rows, showing them as deleted, but they are being returned on SQL querys over an OLE DB connection.

How prevent this behavior without packing the table?

Thank you.

asked 23 Jan '13, 08:10

Danniel%20Magno's gravatar image

Danniel Magno
accept rate: 0%

With OLE DB, you can control whether deleted records are returned with the following in the connection string:


The default value for that option, however, is already FALSE ... so the default behavior should be that deleted records would not be returned. So it sounds like maybe the connection string already has the ShowDeleted parameter with a value of TRUE. If so, just change it to FALSE. The connection string parameters for OLE DB are documented here.


answered 23 Jan '13, 08:15

Mark%20Wilkins's gravatar image

Mark Wilkins
accept rate: 26%

For the OLE DB connection you can prevent deleted records from being shown by setting ShowDeleted=false; in your connection string.
This should be the default so if you could also remove the ShowDeleted setting this should resolve the issue.

Here is a link to the help file detailing all the OLE DB connection string options. Connection String Parameters (Advantage OLE DB Provider)


answered 23 Jan '13, 08:16

Edgar%20Sherman's gravatar image

Edgar Sherman
accept rate: 25%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 23 Jan '13, 08:10

Seen: 1,859 times

Last updated: 23 Jan '13, 08:16

Advantage Developer Zone Contact Us Privacy Policy Copyright Info

Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.