This topic is locked
[SOLVED]

Record Being Edited Removes Other Existing Data

5/20/2024 11:47:10 AM
PHPRunner General questions
J
Jon_AK author

In version 11 of PHPR, I have a simple app with 9 fields in a single Postgres database. I have not added coded items yet, just picked the database to use & selected the fields I wanted to see. The record is created fine with or without entering the Bid Price & leaving the remaining fields empty (not yet ready to complete the rest). However, when I choose to edit a record & add a Revised Bid Price, the amount currently in the Bid Price field is wiped out. The same goes for the Send Approved & Sent columns fields, it wipes out the data in the Bid Price & Revised Bid fields. PHPR is appears to be reading the entire record into memory so when the generated Save click is executed, shouldn't PHPR be writing either just the altered fields only & leaving the unaltered fields alone or writing the entire record back?

J
Jon_AK author 5/26/2024

Just a followup. This issue was remedied by altering the data type of the two fields in question. Postgres has a data type of Money, which is what the two fields were set to display & is the data type I chose to use. Unfortunately, the use of this data type inserts a dollar sign $ in the data stream which caused PHPR to produce these strange results. Changing the data type to Numeric cured the problem Many thanks to Sergey for his help with this.