Data Analyst

<div>
Very Simple. Well Yes. &nbsp;Is Now. 
 
I was so close. &nbsp; Single quotes to the rescue! &nbsp; 
 
Lol. 
 
Thank you
</div>

Very Simple. Well Yes.  Is Now.

I was so close.   Single quotes to the rescue!  

Lol.

Thank you

<div>
<div class="content wysiwyg-content">
How do I tell if a record returned from a seek command is marked for deletion? 
 
 
----------------------------------------------------- 
set safety off 
 
SELECT scrubFile 
INDEX ON PRRecno TAG PRRecno 
 
&nbsp; &nbsp; USE PullFile EXCL 
&nbsp; &nbsp; SCAN ALL 
&nbsp; &nbsp; &nbsp; *-Search the Scrubfile based on Pullfile.PRRecno = Scrubfile.PRrecno 
&nbsp; &nbsp; &nbsp; IF SEEK(PRRecno, 'scrubFile') 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;&gt; I need to add a condition here: 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp; if the scrubfile row found is not marked for deletion 
&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp;&nbsp;Process the Pullfile record 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp; else 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp; delete the pull file record 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp; endif 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp; &nbsp; &nbsp; ENDIF 
&nbsp; &nbsp; ENDSCAN 
&nbsp; &nbsp; 
&nbsp; &nbsp; *- Pack both tables
</div>
</div>

How do I tell if a record returned from a seek command is marked for deletion?


-----------------------------------------------------
set safety off 

SELECT scrubFile
INDEX ON PRRecno TAG PRRecno

    USE PullFile EXCL
    SCAN ALL
      *-Search the Scrubfile based on Pullfile.PRRecno = Scrubfile.PRrecno
      IF SEEK(PRRecno, 'scrubFile')

               >> I need to add a condition here:
           		&& if the scrubfile row found is not marked for deletion
      			           && Process the Pullfile record 
			&& else
				 && delete the pull file record
			&& endif
					
				
		   		
      ENDIF
    ENDSCAN
    
    *- Pack both tables

How to tell if record returned from seek is marked for deletion?

Visual FoxPro (VFP), and its predecessor FoxPro, is a data-centric, object-oriented, procedural, database programming language and IDE from Microsoft last released in 2007 that still has some active use due to its low cost of deployment and fairly rapid development. In 2008, Microsoft released a set of add-ons for VFP's xBase components to allow interoperability with various Microsoft technologies. It allows data processing against its native file-based data tables or database servers such as SQL Server.