Claudio wrote:
Hi all,
i have a problem with the SQL-Plugin, that performs a dynamic query:
select fieldname%number% from table where id=%digits%
the problem is that the returned variable has a dynamic name (fieldname1, fieldname2, fieldname3, etc.), so I've tried to adapt the SQL-Query to get a fixed variablename:
select fieldname%number% as newvar from table where id=%digits%
but the sql-plugin do not return any value for newvar then. I think the sql-plugin do not recognize the "as name"-option in the statement.
Is there any way to use a evaluate-Function?
Something like like 'evaluate("fieldname%number%")' or something like '%fieldname%number%%'.
Why not using in advanced-section a "set local call variables" to: varname=%evaluate("fieldname%number%")% ???
Bye, Claudio
<{POST_SNAPBACK}>
We already found a solution to that problem!
When there is a need to use a single dynamic varname i.e. to record to a wav-file,
just need to save the file as all possible fieldnames in a row:
i.e.
select fieldname%number% from table where id=%digits%
saving then a WAV as %fieldname1%%fieldname2%%fieldname3%%fieldname4%.wav with:
fieldname1="" (not defined)
fieldname2="" (not defined)
fieldname3="record1234"
fieldname4="" (not defined)
will result in saving the file "record1234.wav".
==================
setting a local call variable in the advanced tab:
file=%var1%%var2%%var3%%var4%.wav
with the following definitions:
var1= (not defined)
var2= (not defined)
var3=12
var4= (not defined)
will result in data=12.wav
==================
or with these definitions:
var1=8
var2= (not defined)
var3=923
var4= (not defined)
will result in file=8923.wav
==================
This should help other USERs of this precious program!
Bye!
Claudio
the non existant