Hello,

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
111349
accept rate: 0%


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

ShowDeleted=FALSE;

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.

link

answered 23 Jan '13, 08:15

Mark%20Wilkins's gravatar image

Mark Wilkins
7.2k226133
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)

link

answered 23 Jan '13, 08:16

Edgar%20Sherman's gravatar image

Edgar Sherman
5.4k13185
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

By RSS:

Answers

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

Tags:

×325
×16

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.