exclude items tagged fro del from querry without Pack

[WillieLoMain]

I have an older app that is built on 2.6a for dos

Some of the functions of the app take a long time to run as written and I am interested in writing some stand alone code to deal with these items.

I have the code written but have the following problem.

When I run the code it includes items that are tagged for deletion but which have not yet been deleted because a pack has not been performed.

I would prefer to do the pack from within the application and am therefore interested in adding some language to the code that I am using to ignore the items that are tagged for deletion.

For the life of me I can not figure out how to do this though.

Thanx in advance

 

[WillieLoMain]

Premature post here folks

Looks like Set Deleted ON does the trick here

Star for me I guess hehe

Probably never would have figured it out if I didnt take the time to ask here

Thanx

 

[Gilesy]

Try putting ... FOR NOT DELETED() in your code.
IE
BROWSE FOR NOT DELETED()
or
SCAN FOR NOT DELETED()

etc.


Good luck

 

[JRB-Bldr]

An alternative method would be to consider adding the following selection criteria to your SELECT - SQL query.

SELECT <your fields>;
FROM tablea, tableb;
WHERE <tableb criteria> = <tablea criteria>;
AND <whatever>;
AND NOT DELETED('tablea');
<etc.>;
INTO CURSOR display

Good Luck,


JRB-Bldr
VisionQuest Consulting
Business Analyst & CIO Consulting Services
CIOServices@yahoo.com