Event based script help

JOHN COSBY

• November 11, 2021 17:49

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?

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • November 12, 2021 10:37

  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
• 

  JOHN COSBY

  ★ BarTender Hero ★

  • November 12, 2021 14:24

  Thanks Pete, that worked!

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

  0

Please sign in to leave a comment.