relationname.getsize problem

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

relationname.getsize problem

Postby Gert » Tue Apr 12, 2005 6:14 pm

Trying to count the related records I used
Code: Select all
relationname.getsize
in a calculaion. This works fine until you go over 40 related records. Then it always returns 40. Is this a bug, or how do I get over it?
Gert
 
Posts: 24
Joined: Mon Jul 12, 2004 8:52 am
Location: Antwerp, Belgium

Postby patrick » Tue Apr 12, 2005 7:00 pm

It's a limitation. If you use getSize() in a loop, it gets updated once you hit 40, so looping is safe. With databaseManager.getFoundSetCount you can do a count(*) with a foundset, that will give you the exact number.
patrick
 
Posts: 3703
Joined: Wed Jun 11, 2003 10:33 am
Location: Munich, Germany


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 6 guests

cron