upcoming 2.0 version

[Harjo]

We are busy with some upcoming projects, and we want to straight some things out.
In the upcoming version of Servoy it will be possible to use database autoincrement generators. right?
Will it also be possible, that if a user updated or created a new record (outside Servoy, by PhP or something else) that this is instantly seen in the Servoy Client?

Or do you have to do all kind of methods, before this update is seen?

[Harjo]

any news?

[Jan Blok]

In the upcoming version of Servoy it will be possible to use database autoincrement generators. right?

Correct, check the column data provider properties in Servoy 2.0 beta releases

Will it also be possible, that if a user updated or created a new record (outside Servoy, by PhP or something else) that this is instantly seen in the Servoy Client?

Or do you have to do all kind of methods, before this update is seen?

It will not be instantly seen,since it is impossible to add a change listener on a database, currently there are 2 ways to make changes visible:
1) flush client cache in admin page
2) databaseManager.refreshRecordFromDatabase(foundset,record_index)

In option 2 we could make make if record_index is -1 all records are updated from db (let us know if this is wanted)

[pbakker]

The -1 option is something I would like

Now I have to make a loop to go through the foundset.

Thinking of this whole update issue: Would it be possible to get a property on a form that, if set to yes, would always refresh the data displayed on the forn when the form is loaded again?

This would solve most of the issues, I think.

Paul

[Harjo]

I agree with Paul

P.S. What is exactly "record_index is -1"
I know "0" and any other number. but -1?

[pbakker]

I assume -1 is not a record index, so if we would put that there, the function would know it has to refresh the entire dataset

Paul

[Jan Blok]

Yep, will be availeble in Servoy 2.0 rc5