Event based script help Follow

0
Avatar
JOHN COSBY

I'm trying to figure out what I've done wrong here:

In "Procedures for all events":

    Dim mydatetime

In "Document Events / OnOpen":

    mydatetime = Now

In "Template Objects / Text 1 / Data sources / Multi-Line Script": 

    value = mydatetime

 

Text 1 displays <Empty>.

Using msgbox, I can see that "mydatetime" receives a value during OnOpen but is blank in the context of "Text 1".

Any ideas?

2 comments
0
Avatar
Peter Thane
Comment actions Permalink

I had the same thing but then added it as a Script Library object via the text field itself and now I can call it up with the Value = MyDateTime command from multiple fields:

0
Avatar
JOHN COSBY
Comment actions Permalink

Thanks Pete, that worked!

One step closer to handling the multiple queries when using SQL SP in a database connection...

Please sign in to leave a comment.