Are Help/Systems products compatible with i5/OS V6R1?
Help/Systems is committed to making our products compatible with the new release of i5/OS. We began shipping V6R1-compatible code for most products at the end of April 2008. For more information, download the new Help/FACTS, “Compatibility information for Help/Systems products moving to i5/OS V6R1 (IBM i 6.1)” or contact technical support.

Does Help/Systems hold a User Conference?
Yes, Help/Systems is hosting a User Conference June 17-20, 2008 in Minnesota. If you haven’t received a brochure in the mail, visit www.helpsystems.com/education/camp/ to download a copy and register online.

Are hyperlinks supported in my ESEND e-mail messages?
Yes, if the message type is *HTML. Here are some formatting tips:

• E-mail links: Use mailto:myname@mydomain.com or just myname@mydomain.com.
• Web site links: Use http://www.helpsystems.com or just www.helpsystems.com.
• Document links: Enter the complete HTML reference <A href=”http://www.helpsystems.com/intel/video.html”>a SEQUEL movie page</A>. This will display as a SEQUEL movie page in your e-mail.

I am trying to move a Microsoft Access project to SEQUEL ViewPoint and I am stuck on one formula. In Access, I use this formula to add a trailing 00001 to a trimmed field:

Left([eqmfsn],4) & “00001″

How would I do this in Viewpoint?

Here’s a good way to handle this in Viewpoint:

SELECT DECIMAL(CAT(SST(CHAR(cusno),1,6), CHAR(’00001′)),15,2) name(calc1), cusno*100000+1 LEN(15,2) name(calc2)

FROM sequelex/custmast

Just replace the name variables with your own file names.

This entry was posted on Wednesday, April 2nd, 2008 at 8:33 am and is filed under ESEND, SEQUEL. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.