Counting items in a column?

[golyg]

In my app, I do not want the user to be able to enter a value if 5 values already exist.
On the 'Add' button, I have this:
/////////////////////////////////////////
SELECT Count(people)
INTO :num_people
FROM t_people
Where ((total_d = :in_total)
COMMIT;
if(num_people > 5) then
MessageBox(sg_msg)
else
OpenWithParm(wc_form_people_permission, TheItem )
end if
//////////////////////////////////////////////
But num_people is always = 0.

any ideas?

thanks
g

 

[shiongss]

Hi,

I guess the problem most properly cause by the Where Clause. Is it the ":in_total" same as the people u want to count?(Is it a numeric?) What data is "total_d" stored? U may try to select * where total_d = :in_total by backdoor, see is there any rows return? If no rows, means no data attached to that criteria.

Hope this could help you to debug...

 

[rt63]

I also see a semi colon missing after your select query (i.e. before COMMIT) - that could also be causing the problem. In debug mode, check out the sqlca transaction object values to see if any problems with the query execution.
RT