Ted Ericson's blog

Retrieving a SQL expression from a data field?

I need some help with how SQL works. Trying to get an auto-salutation to be generated from data entered in the Gen_Tables.

My thinking was that we could put a SQL expression into the description column in Gen_Tables and then use that as a string in a query, but it does not recognize it as SQL, only as a string.

E.G. the value in the field is: Name.FIRST_NAME+' '+Name.LAST_NAME

Store that value in a variable @value

iDashboards community

We have a new sharing site for iDashboards, where you can see and download a set of sample dashboards. With dashboards for Membership, for Events, and for Fundraising, it will do a lot to get you started quickly. You've got to get trained and using this terrific new add-in to iMIS. 

iMIS TaskCentre samples

There is a new "book" of TaskCentre samples and examples drawn from some of the interesting stuff we've been doing for iMIS demos over the past months.  We've gotten LOTS of wows as we show these.  You'll find them under the Implementation tab, way at the bottom, under Third Party Products.  Or search.  From that location, you can download tasks ready for import into iMIS TaskCentre, along with scripts for stored procedures when they require them.

Syndicate content