Changing or returning calculated fileds in a dataset

Classic Servoy
1

I am playing with the It2be calendar plugin.

I ahve a database which has an appointment time stored as a unix datestamp. (MySQL)

I then have calculated fields converting that to a date time stamp within servoy.

When doing a SQL query to get the events for the calendar plugin, it doesnt seem to return the servoy calculate fields. but i can get the start date UNIX filed and the length from my core database.

Is there a simple way of working through the buffered dataset that returns and add a column and change another one?

or do i need to build these start and end date fields into my back end SQL table.

David

2

You could always store the calculated columns in your backend database. Just define two new columns in servoy with the same name and datatype as you calcs…

3

Then you may need to force Servoy to update the stored calcs.

4

Yes,

that is what i have done, except the primary interface to the database is a PHP web interface, so i have retrospectively changed the values of the new fields and will make sure when a future entry is added they are popluated.

Thanks for that