Hi,
I've been using PHPRunner for a few months now, and it is a fantastic product. For someone like me who is not a developer, PHPRunner opens up a whole new world. I am however stuck with a problem, and after searching the forum, I have not found a solution yet.
I'm busy with a small project to update specific fields in our ERP database. The fields are CHAR type fields, and because it's the ERP database, I dont feel confortable changing the type to VARCHAR.
My problem is the anoying spaces after the value in the field when you edit a record. It's possible to use the RTRIM function in SQL to remove the spaces, but then you get a SQL error when trying to update/edit the field. My question is if is possible to get the data out of the database as is (no RTRIM), and then strip the spaces before it is displayed on the Edit page (I don't mind spaces on the List page)?
Thanks in advance.