Web Only Version Pain

January 13, 2010 by stewart · 2 Comments
Filed under: EnterpriseOne - General, EnterpriseOne - SQLs, eGen, sql 

We seem to be having an issue with old “web only” versions.  There are times when the “web only” version causes the other version to not egen correctly.  So, below is the SQL that can be used to select the “web only” versions.

SELECT count(*) FROM COPD811/F983051
WHERE VRVCC2='1'             

If you want to be more precise, you can grab the “web only” versions that have been executed prior to a certain date by using the VRVED field and the six digit date which can be found on the e1 dates page.

Tags: , , , , , , , , ,

Related posts

Comments

2 Responses to “Web Only Version Pain”
  1. Anthony says:

    Just found your Blog as a fellow CNC would like to say thanks :)

  2. stewart says:

    Your welcome Anthony! Thanks for stopping by. I hope you find the site useful.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!