SQL Query based on "Object Value" (Embedded Data) in Text Field Follow

0
Avatar
Hans Mayer

I create labels manually but would like to use Source Type "Database Field" (SQL Server) to recieve [Name] for [ConfigID]

Manually this works : 
SELECT [NAME] FROM [dbo].[CONFIGTABLE] WHERE [CONFIGID] = 'CFG099526'

But I would like to do like this dynamically:

SELECT [NAME] FROM [dbo].[CONFIGTABLE] WHERE [CONFIGID] = 'USE OBJECT VALUE FROM TEXT FIELD'

See instruction here: http://i.imgur.com/ak03d2N.png


(1) Can I only do this by "Visual Basic Script" ?

(2) If yes, are there any "example Scripts" for that?

(3) If no, how can I achieve this?

thank you in advance!

3 comments

1
Avatar
Hans Mayer
Comment actions Permalink

dynamically updating label based on "text fields" works perfect for pictures : http://i.imgur.com/pzSGU9e.png

If information on label changes => then the picture is changed automatically in real time :-)

this is really nice !

0
Avatar
Matt Brooks
Comment actions Permalink

Looks good, Hans!

0
Avatar
Shotaro Ito
Moderator
Comment actions Permalink

BarTender doesn't have the exact function.

However you can use 'query prompt' to change SQL Query value etc in print time.

Please check the video below:

https://support.seagullscientific.com/hc/en-us/articles/230880448-Using-a-dynamic-filter-Video-5-36-

Please sign in to leave a comment.