Changing Types of Colums in Dataprovider

It would be nice if it would be possible to change the type of a dataprovider even if it is already in use.

e.g. changing a type from integer to number or number to text.

Currently i need to delete the columns and create new ones - even if i just want to change it from integer to number. The data used is lost…

Rainer Boehm

rainer / dsp:
It would be nice if it would be possible to change the type of a dataprovider even if it is already in use.

e.g. changing a type from integer to number or number to text.

Currently i need to delete the columns and create new ones - even if i just want to change it from integer to number. The data used is lost…

Rainer Boehm

Hi Rainer,

You CAN change the datatypes of columns - just not using the Servoy “Define Dataproviders” interface. You need to go to the backend database directly and change the datatype.

Bob Cusick

HI Bob,

do you know how this can be done in Firebird and Sybase?

it is possible to alter the fields directly on DB level.
But if the Dataprovider would offer this function, i do not have to use an additional application everytime.
e.g. if it is possible to create / delete fields and tables in mysql and other databases it would surely not be that problem to change the field type directly via servoy.

Rainer

Firebird and Postgress are the only databases supporting this. it is not in the SQL specification either.