I need help in Counting the Records - Oracle9i Form Developer

[meLady]

Hello,

I have a form that contains some data and I would like to count them in a new Item text ... I don't want to use the Item Text's property ... I want to use the SQL statement code to count the records ... I named the Item Text as Count_Records ...

So, Can I have your nice help in this (^_^)

[meLady]

anyone can help me ... Please!

[saquib1982]

Hiii...

I think this query is useful:

select count(xx)
into Count_Records
from <Table_Name>;

try this hope this will help u..

[leokamal]

Hello

Here under the query but b4 that i am assuming that the table has an index column. lets say EMPNO in employees table.

Query ...

Select Count(empno) into :rec_count_txt from employees.

But if your form table is not indexed then you can use * in place of field.

Select count(*) into :rec_count_txt from employees.

but the most important thing is where to place the triger. well you should use this triger on block level.

take care,

Bye Bye