v processing question

[Jeff Harrison]

Courtney wrote:
> 
> Guys and Gals
> 
> I have a question about vprocessing...
> 
> Can u update a record while running a vprocessing?
> 
> What I want to do is to update a field so that next time that 
> particular
> record is not selected again.  We use a field to indicate 
> when we emailed
> the client.  When we create the record we blow all 9's into 
> field indicating
> that this record is to go thru the processing to send emails. If any
> condition comes up that stops it from getting an email (no 
> email address to
> send to, the email client switch is not set to "Y", etc) I 
> blow in 8's in
> the vprocessing table.  I debugged one record, and when it 
> got to one of the
> "stops", processing should have blown in 8's but did not...am 
> I missing
> something?
> 
> 

Yes.  You are not actually in update mode when you are in v processing so
you will need to issue an explicit "write" in order to make sure any changes
you make are permanent.

As a general rule, I would stay away from doing writes in v processing.  Why
not just write to your flag in the regular output processing?

Jeff Harrison
jeff.harrison at epixweb.com

Author of JHExport and JHImport - The fastest and easiest ways to generate
code for filepro exports and imports.  Demos available upon request.