That's the nature of triggers. You need to be able to handle ANY number of records in the trigger code. Unfortunately, if you're modifying individual records...

I wish I could offer up something helpful here, but I suspect the reason you haven't had a response is because the very nature of the use of something like...

With statements that do things like create triggers or tables or other data structures, (these are called DDL statements, I think), you can't just supply a variable name the way...

Keith.

I just got another ping on this topic so I ended up re-reading your response, and then remembered that at the time I was dealing with that problem, I had...

Glad my experience could be of value. I am "sgmunson", though, not "Ten Centuries"... (you can call me Steve, too)...

The latter is actually an "experience indicator" related...

Once again, "it depends"... It's very difficult to help someone without sample code for the query and sometimes, the xml for the report itself, or at least...

There's always an "it depends" that goes with using a matrix, and it sounds like you may have ran smack into one. You didn't specify any details on...

Thanks for the reply... It continues to amaze me how often something done years ago helps someone currently...

Glad you were able to make use of it.

Steve

(aka sgmunson)

:-):-):-)

Your thanks are appreciated. Something else that may help you with SQL coding is to start using table aliases instead of fully qualifying your table names at every...

This thread is 3 years old, but I'm glad my reply was of some value, as the prior poster never re-posted. The more we can find useful items...

No, and time available to mess around with it has gone to zero with me working outside my home state. However, the data is clearly in existence in...

Ok, I get that. However, the reason that we don't leave the messages on the ISP's mail server is privacy, as it's become obvious that trusting one's e-mail...

IMAP Server ? I've heard the term IMAP before, but I thought Outlook and it's variants are MAPI-based. Can you elaborate on what you mean...

Thanks Ed, I've downloaded the various FineBuild items and now the challenge is to get the time needed to start playing around with it.

Steve

(aka sgmunson)

:-):-):-)

That explains a lot... Knowing exactly which priveleges to grant is the grief that too many of us just aren't familiar with. For desktop...