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)
"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)
Please sign in to leave a comment.