How To Use A Fixed Substring Named As The Key Of The Query In Db Reading Follow
Good morning, i need help.
I have to print fields data of a database in a label BUT not using a fixed value as key (criteria in query window) and nor a prompt but a a text fileld nemed (ex.) "filedtext1" in the "datasource->screed data->name" filed.
If this is not possibile is there any way to retrive a value in the db using a vb script in the label field ?
(so there i could refere to the fieldtext1 as Format.NamedSubStrings("fieldtext1") and in some way read the db using Format.NamedSubStrings("fieldtext1") ad key)
something like
"Value = Field("DATABASE.DESC") where Field("DATABASE.ARTCD") = Format.NamedSubStrings("fieldtext1") .... "
( i know.. this is vb and not sql but is just to give an idea of what i mean)
1 comments

Shotaro Ito
★ BarTender Hero ★
I recon there's no way to use named datasource (named substring) as a query condition.
If you're using Commander / command line, you can give query prompt from Command line by /?"Query prompt name"="Value".
see http://forums.seagullscientific.com/index.php?/topic/290-variable-in-query/
For Batch Maker, you can specify query prompts value in batch.
Please sign in to leave a comment.