How to use variables in Read from table?

In BSQL, can variables be used to select the row to read from? View the following code as an example:

{row="01/12/2023"}
{dbselect: SELECT {=row} FROM Testlist; space=9adsfjsadfk6as; menu=no}

The output should be a list of the row's contents corresponding with the row variable.

I appreciate your help.

Hi @gyger.

The @ prefix is used to denote variables inside BSQL, for example:

{row="01/12/2023"}
{dbselect: SELECT Name, Date FROM Testlist WHERE Date=@row; space=id; menu=no; name=results; multiple=yes}
{repeat: for result in results}
{=result.name} {=result.date}
{endrepeat}

I hope that helps, please let me know if you need any more help with it.

Dimont