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

Hans Mayer

• 30 août 2017 13:29

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!

0

• 

  Hans Mayer

  ★ BarTender Hero ★

  • 31 août 2017 08:39

  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 !

  1
• 

  Matt Brooks

  ★ BarTender Hero ★

  • 7 septembre 2017 12:50

  Looks good, Hans!

  0
• 

  Shotaro Ito

  ★ BarTender Hero ★

  • 8 septembre 2017 06:21

  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
• 

  wo ter

  ★ BarTender Hero ★

  • 3 avril 2020 08:17

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

  0

Vous devez vous connecter pour laisser un commentaire.