How To Use A Fixed Substring Named As The Key Of The Query In Db Reading Follow

0
Avatar
Legacy Poster

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)

 
 
 
( The value of "fieldtext1" will change as i'll batch print using a txt where i'll have the value of the substirng defined with name and screen data source).
 
Thanks a lot... it's very very important to me.

1 comments
0
Avatar
Shotaro Ito
Comment actions Permalink

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.