In DB Manager changing field type from String (or other) to Reference just changes to Integer instead

[nickneustroev]

Wappler Version : 4.4.5
Operating System : Win10
Server Model: NodeJS
Database Type: SQLite local
Hosting Type: Local self host

How to reproduce

1. Create a string field (or any other type)
2. Go to field Properties and change Type to Reference. Set table and field.
3. Click “Apply Database Changes”.
4. Back to the field to see that the type is Integer now.

[George]

Could you also post the change file that got generated? Did it execute successfully? Did you change just one field?

Also note that changing fields type to completely different one might result in loosing data as there is no conversion involved so it is up to the database what it does with it.

[nickneustroev]

Before changes was applied.

After it was applied.

@George

Did it execute successfully?

Seems like it.

@George

Did you change just one field?

Yes

@George

Also note that changing fields type to completely different one might result in loosing data as there is no conversion involved so it is up to the database what it does with it.

Understood. To be clear, I am not planning to use this option myself.
I just trying DB Manager for the first time, so testing different things and reporting all unusual and potentially troublesome issues.

[Teodor]

This has been fixed in Wappler 4.8.3