2. PHPRunner General questions
  3. Changing field type
This topic is locked

Changing field type

 		10/27/2015 4:00:58 PM
PHPRunner General questions
greggk author

I had a project that was working great. Now the customer wants the order number to have an alphabet letter to it. Before, the field type was INT, now I have to change the field type to varchar. I have tested it and some how it still doesn't work. When I add for example 123a, it just leaves it blank. I went through and made sure that there wasn't anything in the settings that would force the field be int, but couldn't find anything. Anyone have an idea of where else I could look for a solution?
Sergey Kornilov admin 10/27/2015

After field type was changed 'Synchronize database' on 'Datasource tables' screen and this would take care of this issue.
greggk author 10/27/2015



After field type was changed 'Synchronize database' on 'Datasource tables' screen and this would take care of this issue.


I did the Synchronize database, and still no go. I am now able to do 123.01 though, and I wasn't able to do that before I changed the field type to varchar. But as soon as I try to put in 123a and save, it just leaves it blank.
If I manually edit the MySQL database to 123a, it does show up in the list page, but as soon as I load the add page, or edit page, it goes away.
greggk author 10/28/2015

I noticed one more thing that hopefully can generate some ideas.

Under EDITOR, I go to the selected field, and I check "Required Field" and also "Prevent duplicate value"

The HTML input type is text and everything else on that page is normal. I have build all the pages, and re uploaded all the pages, and still I cannot enter any type of text in that box, but I also noticed that even though I have checked the box prevent duplicate value, it would still allow me to add two order numbers of equal value.

How can this be?

Where else can I look in the software to try to figure this out? I'm using 8.0 build 24793

Thanks.
I just noticed one more thing, I've been testing out different browsers for this, and I noticed that the Chrome browser doesn't even allow me to type in text in that field, so it's definitely an issue with the php files being generated that some how is preventing the text.