evaluate for %variable%) needed

[Claudio]

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

[Claudio]

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