# Refresh Record from database syntax help

**URL:** <https://forum.servoy.com/t/refresh-record-from-database-syntax-help/1173>\
**Category:** Classic Servoy\
**Created:** [February 3, 2004, 12:33pm UTC](https://forum.servoy.com/t/refresh-record-from-database-syntax-help/1173 "2004-02-03T12:33:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Niall](https://avatars.discourse-cdn.com/v4/letter/n/73ab20/32.png) [@Niall](https://forum.servoy.com/u/Niall)\
**Post date:** [February 3, 2004, 12:33pm UTC](https://forum.servoy.com/t/refresh-record-from-database-syntax-help/1173/1 "2004-02-03T12:33:02Z")

</div>

Can somebody explain the syntax for:

databaseManager.refreshRecordFromDatabase(foundset , 2)

How do I define the found set and what does the number mean please?

I’m assuming that it will update the records in the foundset to cater for changes made on the SQL server by direct query.

Any help / examples appreciated

Niall

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [February 3, 2004, 1:03pm UTC](https://forum.servoy.com/t/refresh-record-from-database-syntax-help/1173/2 "2004-02-03T13:03:24Z")

</div>

Hi Nialle,

Please take a look at:

[http://forum.servoy.com/viewtopic.php?t=811](http://forum.servoy.com/viewtopic.php?t=811)

The number is the record index in the foundset.

Paul

---

<div class="post-metadata">

**Author:** ![Niall](https://avatars.discourse-cdn.com/v4/letter/n/73ab20/32.png) [@Niall](https://forum.servoy.com/u/Niall)\
**Post date:** [February 3, 2004, 2:20pm UTC](https://forum.servoy.com/t/refresh-record-from-database-syntax-help/1173/3 "2004-02-03T14:20:45Z")

</div>

Thanks for this Paul but I get a verification error when I try this on line 3 pos 37

Is there something I’m not doing / changing?

BTW I’m a newbie when it comes to Java, sorry.

Niall

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [February 3, 2004, 2:38pm UTC](https://forum.servoy.com/t/refresh-record-from-database-syntax-help/1173/4 "2004-02-03T14:38:07Z")

</div>

Niall,

The Forum breaks up the code: the second line needs to be connected to the first line and the 5th line to the 4th line.

Then it should work.

Paul