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!

4 意見

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-

0
Avatar
wo ter
評論操作 永久連結

You can use ?<named datasource> to build a dynamic query.

登入寫評論。