# getFoundset() unexpectedly returns empy fs

**URL:** <https://forum.servoy.com/t/getfoundset-unexpectedly-returns-empy-fs/11102>\
**Category:** Classic Servoy\
**Created:** [September 1, 2009, 12:46am UTC](https://forum.servoy.com/t/getfoundset-unexpectedly-returns-empy-fs/11102 "2009-09-01T00:46:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![maria](https://avatars.discourse-cdn.com/v4/letter/m/34f0e0/32.png) [@maria](https://forum.servoy.com/u/maria)\
**Post date:** [September 1, 2009, 12:46am UTC](https://forum.servoy.com/t/getfoundset-unexpectedly-returns-empy-fs/11102/1 "2009-09-01T00:46:19Z")

</div>

Hi,

I want to get a table’s records as a foundset but the method databaseManager.getFoundSet(globals.DB\_SERVER\_NAME, “lookup\_productpricecode”) returns empty foundset, although there are records in the table. Why? (the server and table name are ok)

Cheers,  
Maria

---

<div class="post-metadata">

**Author:** ![Harjo](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/harjo/32/4873_2.png) [@Harjo](https://forum.servoy.com/u/Harjo)\
**Post date:** [September 1, 2009, 6:08am UTC](https://forum.servoy.com/t/getfoundset-unexpectedly-returns-empy-fs/11102/2 "2009-09-01T06:08:33Z")

</div>

and if you do: fs.loadAllRecords() ??

or do a find first?

if(fs.find()) {  
fs.column = ‘mysearch’  
fs.search()  
}

---

<div class="post-metadata">

**Author:** ![maria](https://avatars.discourse-cdn.com/v4/letter/m/34f0e0/32.png) [@maria](https://forum.servoy.com/u/maria)\
**Post date:** [September 1, 2009, 7:10am UTC](https://forum.servoy.com/t/getfoundset-unexpectedly-returns-empy-fs/11102/3 "2009-09-01T07:10:42Z")

</div>

> Harjo:  
> and if you do: fs.loadAllRecords() ??

Now it works ![:oops:]( "Embarassed") ![:oops:]( "Embarassed") ![:oops:]( "Embarassed")  
Thanks ![:)]( "Smile")
