SQL Query based on "Object Value" (Embedded Data) in Text Field Follow
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!
Please sign in to leave a comment.