Database Resource

[Matt]

I am new to ebase, I have created a database Resource and want to know if I could use write a SQL statement with Sum or count in it and display that total from the SQL statement in box on a form.

[Simon]

Hi Matt, welcome to the Ebase community!

You can indeed write an SQL statement that does exactly that. From the Assisted SQL in the DB Resource screen, enter the following code:

Code: Select all

count(*) as MY_INT

Fill in the FROM and WHERE boxes as necessary.

Then click the "Add a Resource Field" icon. Call the new field MY_INT, set it to Type NUMBER. Save it, map it to your form field.

You can apply the same logic to Sum, I reckon.

Hope this helps

Simon

[Matt]

That works great thank you