Found the answer, thanks to the dev blog.  The Values() function gets me the info I need:   var strNewEIN = Values("comp_EIN") // sql string that will do the update for this company sql = "UPDATE Company SET comp_ssnein=" + strNewEIN + " WHERE comp_CompanyId=" + ...

 I'm attempting to craft an update table script that takes the information stored in Field A and adds it to Field B, depending on certain conditions.  I managed to get the script to work, but if the script is triggered by editing the data in Field A, Field B gets updated with the old value of Field A, not the new ...

 As far as I am aware, an Enterprise Server License for Crystal Reports is required to give Crystal Report writing access to all users. Even though you can select "Crystal Reports" as an option in the user's Security profile, all that does is grant them full reporting capability with the basic Sage report writer or with Crystal ...

 Can anyone explain how a Marquee block works?  The documentation is very scarce on this.  Supposedly, it reads from a "Custom Captions" table, but I can't seem to find this table in the application. Any example of the proper settings for such a block would be greatly appreciated. Thanks, - Matt -

 From my discussions with Sage, no, there is no way to do this.  Perhaps the feature has been added in 6.2? I is quite annoying, though. Drives my users crazy...

 I realize that, in general, dashboard items can be created in the "blocks" area of a particular entity.  However, I am specifically looking for the programming that was used to create the "Today" block on the dashboard, which lists pending communications and appointments with icons in a two-column format.  I ...

I'm running CRM 200.  I was not able to find this in the blocks area under any of my entities.  I'll look again in case I missed it.  If you could confirm the entity that they are stored under, I would appreciate it. Thanks.

I just recently started to investigate dashboards for my corporation, and I stumbled upon the Today block.  I like the way the information is presented and would like to create a "Tomorrow" block, if possible. Does anyone know where this block is stored?  I've check the Communications entity, but I did not see it.  ...

 I got it figured out now.  I was missing # signs on the oppo_ssnein field.  Also, my system uses oppo_PrimaryCompanyID as the link between opportunity and client.  Once I got those two things resolved, it worked perfectly. Thanks for the help!

I tried an ExecSQL command in my workflow using the following syntax: Update company set comp_ssnein = oppo_ssnein where comp_companyid = #oppo_companyid# However, I get an Invalid Workflow ExecSql error. Any suggestions on where I went wrong with the syntax?