Display the result of executing sql statement in the text field

[vbtux]

Hi,

my code sql is:
select count(F1) from Table1

I wanna know is it possible to display the result of executing sql statement in the text field ?

Thank you

[HighAley]

Hello.

my code sql is:
select count(F1) from Table1

I wanna know is it possible to display the result of executing sql statement in the text field ?

You can do it in 2 ways:

1. Use this expression in text box {Totals.Count(Table1)}

2. - Create new Data Source.
- In Select Data windows press New Query.
- Write next query select count(F1) cnt from Table1
- Press Retrieve Columns
- Use next expression in text box {DataSource1.cnt}

Thank you.

[vbtux]

Thank a lot. I do not know why I have not thought of that.:biggrin:

[Andrew]

Hello,

Have a great day!