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

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 评论

1
Avatar
Hans Mayer
评论操作 固定链接

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
评论操作 固定链接

Looks good, Hans!

0
Avatar
Shotaro Ito
版主
评论操作 固定链接

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-

请先登录再写评论。